SQL Anywhere 5.5 connection Quote:I am evalualtiong your product and one type of dtabase that I need to connectto is a SQL Anywhere V5.5.03 WRT database, but I am having no luck getting it to work. I used the wizard with ASA database type, but get error "provider can not befound" message.
The error indicates that the OLE DB provider for the ASA database type was not installed. Perhaps there is a different provider installed.
Please try to make a new connection. Instead of using the connection wizard (which is usually the best choice of the options) use the Microsoft Data Link Properties wizard.
http://www.oraxcel.com/projects/sqlxl/help/techniques/data_link_properties/ On the first tab it should link a provider specific for your database. If it lists any Adaptec or Sybase provider, try it.
I would be interested to hear if you managed to make a connection in such a way. I would like to build that into SQL*XL as well, so please let me know.
If it doesn't work, you can try a ODBC connection. In the new connection screen select the ODBC function to see whether you can create a connection using ODBC.
If this also does not help, perhaps the correct drivers/providers were not installed. I had a look at
www.sybase.com but could not see which drivers they offered for download. Perhaps it is on your installation CD for the database? Keywords: client components or client drivers, ODBC, OLEDB.
Let me know the outcome!
Pages: 1