Skip to Content
0

Use Excel 2013 VBA code to access Sybase (ODBC; ASE Driver version 15)

Jan 19, 2017 at 08:21 PM

386

avatar image
Former Member

Anyone one know how to connect to Sybase via Excel VBA? The code gets error message: Data source name not found and no default driver specified.

I am not an IT person, not sure if I describe my question correctly.

Thank you so much!

cn.open "Driver={Adaptive Server Enterprise};server=myServerAddress;
port=myPortnumber;db=myDataBase;uid=myUsername;pwd=myPassword;"
sybase.jpg (40.9 kB)
sybase-2.jpg (51.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers