Sybase Connection: Data source name not found and no default driver specified

[VAer]

Error Message.jpg

Error message: see the screenshot.

Set Cn = CreateObject("ADODB.Connection")

' Drive path information found when running Regedit, I have replace some characters with ABCDE   H:\syb-15_0\DataAccess\ODBC\dll\ABCDE.dll
Cn.Open "driver={ABCDE};" & _
    "database=MyDataBaseName;" & _
    "srvr=MyDataServerName;" & _
    "uid=" & MyUserName & ";pwd=" & MyPassword

I have try to put whole drive path H:\syb-15_0\DataAccess\ODBC\dll\ABCDE.dll inside {}, and it did not work either.

I also found database/srvr information when running Regedit.
http://www.erlandsendata.no/english/...adacconnstring


One more thing: In VBA developer window, there is Reference under the menu Tools, and I am not sure if I need to choose something. I did not find Sybase listed there.

Thanks.