Hello: I'm trying setup a link server from sqlserver 2012 (64 Bits installed in a winserver 2012) With a Sybase Database (my database is C:DBasesCONVIAL2009.DB). I have ASA 9.0, with Sybase 32 and 64 bits installed in the same server. Someone could help me with the correct parameters?
MS request this data:
exec sp_addlinkedserver @server = 'TESTING' ,
@srvproduct = 'Sybase',
@provider = 'ASAProv.90',
Sp_addlinkedsrvlogin @useself='false ', @rmtsrvname = 'TESTING', @rmtuser = 'User Name', I'm typing (dba) @rmtpassword = 'Strong Password' I'm typing (sql)
I changed the RPC parameters to TRUE.
The error received is "cannot initializate the data source of OLE DB provider "ASAPRov.90" for linked server"
Thanks a lot.
You need to ensure that the OLE DB provider is registered with the system first. The bitness of the OLE DB provider needs to match the bitness of your running application - in this case, the bitness of Microsoft SQL Server (so, x64).
There should be two DLL files in your SQL Anywhere 9.0.2 x64 directory:
regsvr32 dboledb9.dll regsvr32 dboledba9.dll
Regarding the error: