DSN-less ODBC connect string for legacy Sybase Adaptive Server Anywhere
This is a failed response to this article: Sybase, VB and ADO
I just did a VB6 project connecting to a legacy ASA 7 database. After failing to use ASAProv OLEDB provider altogether (for one reason or another) and much research, here is the connect string for OLEDB Provider for ODBC shim for a DSN-less ODBC driver connection:
Provider=MSDASQL.1;Driver={Adaptive Server Anywhere 7.0};CommLinks=TCPIP,SharedMemory;EngineName=<database_name>;UID=DBA;PWD=SQL
where <database_name> is the instance name dbeng7.exe is running the db under. Check the engine log for 'Starting database "<database_name>"'.
You can find all the valid property names for an ODBC connect string by creating a system DSN, adjust settings and inspecting values HKLM\SOFTWARE\ODBC\ODBC.INI\<system_dsn> key.
The available ODBC drivers that can be used under Driver property of the MSDASQL provider connect string are subkeys of HKLM\SOFTWARE\ODBC\ODBCINST.INI
Apparently Sybase login passwords are case insensitive which I find quite hilarious.
cheers
</wqw>
Answer
Wow, I actually wrote that article in the last millennium, I believe.
Let me take this point by point.
OLEDB provider works fine for it, I remember using them from back in the day. Just follow instructions here: http://www.vbrad.com/article.aspx?id=81 on how to create a connection string.
For ODBC, going to http://www.connectionstrings.com/ has never failed me. They got connection strings up wazoo.