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. asked 30 Oct '13, 10:40 jhenaoc Volker Barth |
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 Ensure that Regarding the error: answered 30 Oct '13, 11:02 Jeff Albion Jeff Thanks for your answer. I registered the two dboledb libraries, also, verified the file dblgen9. In the next link, you can see the ODBC in the server. Please see it and give me your recomendations. link text
(30 Oct '13, 13:45)
Jhenao
Comment Text Removed
Your screenshot is indicating that you have created a 32-bit ODBC DSN for this entry - you need to create a 64-bit ODBC DSN in order for the 64-bit Microsoft SQL Server to access the DSN definition. In order to create the 64-bit DSN, be sure to launch the 64-bit ODBC administrator from
(30 Oct '13, 14:48)
Jeff Albion
Replies hidden
As the screenshot shows that jhenaoc is already using the 64-bit ODBC administrator, he would only have to "Add..." a 64-bit DSN straight from that dialog. Aside: Whereas User DSNs are shared between 32-bit and 64-bit, System DSNs are not, as is explained here. @jhenaoc: If you have setup the correct DSN, make sure to set the required properties for the linked server, particularly the "AllowInProcess" option - cf. my older FAQ...
(01 Nov '13, 06:52)
Volker Barth
|