Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

ODBC Erratic Password errors

Sage 50 general help forum - Free help and support for all general issues
Post Reply
alan.skinner
User
User
Posts: 1
Joined: 24 Oct 2019, 12:57
Sage Version: v2018 24 UK/Europe/Africa

ODBC Erratic Password errors

Post by alan.skinner » 24 Oct 2019, 13:06

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

User avatar
brucedenney
Site Admin
Site Admin
Posts: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: ODBC Erratic Password errors

Post by brucedenney » 24 Oct 2019, 13:11

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.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 18 guests