Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers