question

paulunsy avatar image
paulunsy asked

ODBC Linked Server where Driver not showing where the Provider is not listed

Hi Guys I'm sure this is very simple, but its something I've never done. I'm trying to set up a linked server from SQL to Advantage Database. I have the provider drivers installed and can create ODBC DSN, tested via Access. Now I want to create a linked server to SQL but I'm struggling. I've tried the following: EXEC master.dbo.sp_addlinkedserver @server = N'Bradford', @srvproduct=N'Advantage', @provider=N'Advantage StreamlineSQL ODBC', @datasrc=N'k:\Conctrav\DATA', @provstr=N'servertype=ads_remote_server;tabletype=ads_cdx;' But I get an error when I test it: The OLE DB provider "Advantage StreamlineSQL ODBC" has not been registered. (Microsoft SQL Server, Error: 7403) Alas, the provider does not appear in the Providers folder within the linked server folder. I cannot however find how to add the Advantage DB provider in there... Does this driver need to be added to the server? If so, how do I do that? If not, what am I doing wrong? Any help would be greatly appreciated...
odbc
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

paulunsy avatar image
paulunsy answered
Thanks, but after a little tinkering, the darned thing just started working!!! Not a clue as to what I was doing different... Thank you for your time anyway. Thanks
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

tanglesoft avatar image
tanglesoft answered
Only seen this problem installing a 32 bit driver on a 64 bit OS and had to install the 64 bit version. Some KB articles suggest re-registering the following file %CommonProgramFiles%\System\Ole DB\msdasql.dll with REGSVR32.EXE.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.