July 30, 2013 at 8:44 am
Hi,
I have a 64-bit Windows 7 ultimate server with SQL srv 2008 R2 (64 bit). I am trying to pull data from a Sybase database by using Linked Server in SQL srv. so, I have created ODBC DSN for SYbase connection. DSN works perfectly when connecting from ODBC DATASOURCES(64BIT)..
Im trying to create LinkedServer in Sql using wizard, but I am getting following error msg,
"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"...
I tried with 32 bit ODBC dsn also, but no use.
Can anyone experienced and solved this?
July 30, 2013 at 4:00 pm
Linked servers uses OLE DB and not ODBC. While you can use the MSDASQL provider to do OLE DB over ODBC, I think it is better to use an OLE DB provider if there is one. (And I assume that there is one for Sybase.)
Rather than using the GUI, I recommend using sp_addlinkedserver directly. Or at least, if you want me to help you, I need to see the call to sp_addlinkedserver you are trying.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
July 31, 2013 at 3:43 am
A ODBC DSN should work. I've used it myself, but not to Sybase.
In New Linked Server Wizard I enter the folllowing:
Linked server: <SERVER NAME>
Other data source: Microsoft OLE DB Provider for ODBC Drivers
Product name: <Server name>
Data source: <Server name>
<Server name> = ODBC DSN
You only need a 64 bit ODBC DSN
July 31, 2013 at 6:50 am
Hi,
the below query I am using, I downloaded Sybase OLEDB provider, and I am trying to link sybase thru sp_addlinkedserver....Now I am getting "cannot create an instance of OLEDB provider "ASeOLEDB" for linked server" error....I have tried both GUI and query but same error takes place..
sp_addlinkedserver
@server = N'SybaseLinkedServer',
@srvproduct = 'Sybase',
@provider = N'ASEOLEDB',
--@datasrc = N'SybaseDSNNew',
@provstr=N'DRIVER = {Sybase ASA ODBC Driver} ;SERVER=servrname;DATABASE=DBname;UID=sa;PWD=pwd;'
July 31, 2013 at 12:55 pm
Did you install a 64-bit version of the provider?
I have never worked with linked servers to Sybase myself, but I found this document which may be helpful.
(That text "this document" is a link. I did not include the URL, because it's insanely long.)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply