Why!!!!!!!

[MattShoreson]

dont sybase publish more flipping information!

I am looking to connect to a sybase db using ADO

I have got...
"Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"

Does anyone have any idea what the provider should be?

 

[DM Unseen]

tricks to use:

for ODBC string:
Install sybase (ODBC/OLDEDB) driver(s) on client computer(if
applicable).
Create a file DSN to your server/database with ODBC manager. do not
forget to test the connection!
read file DSN with notepad. This will contain all info except password.

for OLEDB string:
create a new txt file with explorer, rename it to .udl file.
Now double click and use the wizard to connect to your data. You can
even select the DSN you created within the ODBC manager!
Now save the file and open it with a Unicode text editor, and you can
see the ADO connection string to use.
see

http://msdn.microsoft.com/library/d...CreatingConfiguringUniversalDataLinkFiles.asp

Dm Unseen

 

[Bob Phillips]

Who needs Sybase?

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForAdaptiveServerAnywhere

--
HTH

Bob Phillips

"MattShoreson" <[email protected]>
wrote in message
news:[email protected]...

 

[Patrick Molloy]

I use this for ADO connectiob to Sybase

DRIVER={Sybase ASE ODBC _
Driver};UID=My_UID;PWD=My_PWD;NA=bhmxdbp,3700;DB=MyDatabase