Connect to a Sybase Advantage database (4 replies)
Well, throw enough spaghetti at the wall, a piece eventually sticks:
Provider=ASODBC;DSN=(dsn name you configured in ODBCad32);Uid=(db login id);Pwd=(db login id);
Well, I spoke too soon. In Database Connections, I am now getting the "Connection Successful" response.
However, I trying to do my first simple query via Iman, I'm receiving: "Provider cannot be found. It may not be properly installed".
Any ideas?
David, a couple of things:
- We support only 32-bit database drivers (as IMan is 32-bit...due to the Sage300 being 32-bit & a couple of other applications). Therefore the ADSODBC64 driver cannot be used.
- Can you please send screenshots of your database connection setup & your DB Reader screens?
Thanks
Okay - now I got it. The next Sybase n00b can thank me...
Provider=MSDASQL;DSN=(dsn name you configured in ODBCad32);Uid=(db login id);Pwd=(db login id);
https://msdn.microsoft.com/en-us/library/ms675326(v=vs.85).aspx
I'm trying to connect to a Sybase Advantage 11.10 database; based on another forum post, I am trying strings from https://www.connectionstrings.com/. However, I am running into two problems consistently:
Iman reports either:
1) Could not determine connection type from connection string.
2) The 'ADSODBC' provider is not registered on the local machine.
Ditto failures on ADSODBC64 as well.
My assessment so far (being a n00b) seems to be ...
Error #1 I'm guessing comes from trying to use a connection string that fails to begin with "Provider=".
Error #2 I have no clue; from what I can tell in the OBDC manager, the files present in the C:\Program Files\Advantage 11.10\ODBC folder, the registry, and what I've researched on the interwebs, all files and registry settings seem to be in place though it's very possible I'm missing something.
Would greatly appreciate any expertise or experience that can be shared as I've never fiddled with an Advantage DB.