Why!!!!!!!
 

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?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=380819

Why!!!!!!!
 

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/de...aLinkFiles.asp

Dm Unseen

Why!!!!!!!
 

Who needs Sybase?

http://www.carlprothman.net/Default....rv erAnywhere

--
HTH

Bob Phillips

"MattShoreson"
wrote in message
news:MattShoreson.1qz3ul_1119351955.8059@excelforu m-nospam.com...

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?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=380819

Why!!!!!!!
 

I use this for ADO connectiob to Sybase

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




"MattShoreson" wrote:


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?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=380819