Re: OLEDB with ASE 12.5.3 ESD2 and VS 2005....
Matthew P. Seltzer
In response to your questions:
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.
Yes, you should be able to use the 15.0.3 drivers provided you have
installed them correctly.
2. Do I need to set up a DSN to access the database?
No, not if you are using OLEDB.
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;"
Try this as your connection string:
"Provider=ASEOLEDB.1;Data
Source=server:port; User ID=userid;Password=password;"
where 'server' is the IP address of the database instance and 'port' is the
assigned port number.
Best,
mseltzer@<no-spam>fidelis.org
Paul Vero [Sybase]
You can create a Data Source for the ASE OLE DB Provider by Sybase, if you
wish
- Run the utility in %SYBASE%\DataAccess\bin\sybdrvadm.exe, Sybase ASE Data
Source Administrator.
- You can only create ASE OLE DB Data Sources. Fill in connect info in the
General Panel and test connection
- In the connection string replace teh items for Server Name, Server, Port -
however you do it, with Data Source and set
the name you provided with the admin tool. [This info is stored in teh bin
folder as "Name_You_Gave_It.sod" - a text file
Just use the "Name_You_Gave_It" for the Data Source property.
-Paul
"Matthew P. Seltzer" <msel...@fideliscare.org> wrote in message
news:4a8aee5f$2@forums-1-dub...