Hello,

I'm trying to set up a connection to a Sage300CRE company using a "DSNLess" ODBC connection.  It appears that the only password it will accept without giving me an ERROR [28000] [Sage][SQLEngine] (31830) Username and password is required - is "password"  (all lower case).

This isn't a file permissions issue - i'm running as a local admin on a sage installation on my local PC - and it works if the password is "password" .  Tried the code on windows 10, and on Windows Server 2019

Is there a way to have a somewhat more obscure password other that just "password"?

Here is the connection string I am using.

<add key="ConnectionString"  value="Driver=Timberline Data;UID=sageuser;PWD=password;DBQ=C:\\ProgramData\\Sage\\TIMBERLINE OFFICE\\Data\\Electrical Contractor Sample Data;CODEPAGE=1252;"/>

Thanks in advance!