ODBC behavior error

[sec4zj]

Hello,

I am getting the below error when I try to connect to this database using a connection string. This connection worked for a long time and recently started throwing this error - no changes have been made to the database and I've double checked the user ID and password. Any help would be much appreciated!

DataSource.Error: ODBC: ERROR [HY000] [AspenTech][SQLplus] Invalid UID/PWD
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Details:
DataSourceKind=Odbc
DataSourcePath=driver={AspenTech SQLplus};host=ROCSAWN00015
OdbcErrors=[Table]

[v-yalanwu-msft · Accepted solution]

Hi, @sec4zj ;

According to your description, there may be two reasons, one is the user name and password; the other is the version reason; you can try the following ways:

1.What's the version of ODBC did you create, 32 bit or 64 bit?  if your app is configured for 32-bit (Platform option of x86) and is running under 64-bit Windows, you will need to use the 32-bit Data Sources applet under Administrative Tools in Control Panel to create the DSN. Also, the Oracle Client software must match the platform the app is running under (32 or 64-bit)

2.Please verify the User credentials as it would be the case sensitive issue. I suggest to use upper case while you connect to ODBC.

In addition, you could refer this link.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.