OleDb with ASE 12.5.3 ESD2 and Visual Studio 2005

[kevinmcelhiney]

Our shop here has a bunch of Sybase unix-based servers but
no one is accessing them from a Windows-based app using
OleDb. I'm trying to access a server running ASE 12.5.3
ESD2. I currently have the 15.0.3 drivers installed. My
questions are:

1. Will the 15.0.3 drivers work correctly against a 12.5.3
server? I have the 12.5.2 drivers available if they will
work better.

2. Do I need to set up a DSN to access the database?

3. What should my connection string look like? The one I am
trying looks like:

"Provider=Sybase ASE OLE DB Provider;Data
Source=server:port; User ID=userid;Password=password;"

Of course, "server", "port", "userid", and "password" all
have the proper values, but I think this is wrong.

Can someone give me a hand?

Thanks in advance,
Kevin

[Ex_Soft]

> 3. What should my connection string look like?

Sybase OLEDB Provider for ASE (sybdrvoledb.dll)
http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00075...
connStr="Provider=ASEOLEDB;Server=localhost;Port=5000;Initial
Catalog=testdb;User ID=sa;Password=";

ASE OLE DB Provider (sydaase.dll) by DataDirect
connStr="Provider=Sybase.ASEOLEDBProvider;Server Name=localhost;Server
Port Address=5000;User ID=sa;Password=;Initial Catalog=testdb";