SageForum for UK versions of Sage 50- Help and support.

Im using sage UK V26.1 (same issues with V25...).

I have created a website that uses ODBC64 (on 64 bit windows7 and 2008 server) to query our SAGE database.

The problem is it fails.. quite often with either of the following errors


ERROR [28000] User ID or Password invalid ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 26.1

OR

ERROR [28000] User ID or Password invalid ERROR [01000] The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 26.1 ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

The password is fine it works probably 75% of the time.
The same ODBC query i.e. web page, will work perfect if i press refresh, until it fails again of course...

Any ideas what could be wrong, any special connection string settings I may be missing.

If i write a program to hammer the ODBC with the same queries , ie not from a website it seems to never fail.

Thanks

The sage database is slow and clunky at the best of times with ODBC.

If you want performance then the best route is to make a clone of the table(s) needed to MySQL or another such database and then query that.