Sybase Linked Server Question,

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Sybase Linked Server Question,

Author

Topic

tbraga
Starting Member

11 Posts

Posted - 2009-02-17 : 18:07:15

Hi All,

I am creating a linked server connection from MS SQL 2005 to Sybase. I have my SystemDSN working, it successfully connects to the Sybase database. I have added my linked server using the code below but I get an error when I try to view the tables and I'm not sure where to go from here. Here is the SQL code I am using to create the linked server:

-- Adding linked server:
exec sp_addlinkedserver @server = 'PUBLISHING' ,
@srvproduct = 'Sybase',
@provider = 'MSDASQL',
@datasrc = 'publishing'
go
-- Adding linked server login:
sp_addlinkedsrvlogin @useself='false', @rmtsrvname = 'PUBLISHING',
@rmtuser = 'username',
@rmtpassword = 'password'

exec sp_tables_ex 'PUBLISHING'

The error I recieve is this: OLE DB provider for MSDASQL for lniked server returned messsage "Data source name not found and no default driver specified"

Any help would be great on how to get around these two,
Thanks,
Tim

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-17 : 18:11:31

http://support.microsoft.com/kb/280102