sqlserver2005 cant link to my informix server

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

Other Forums

Other Topics

sqlserver2005 cant link to my informix server

Author

Topic

aburabbi
Starting Member

1 Post

Posted - 2008-12-07 : 22:41:29

Error Message: OLE DB provider "MSDASQL" for linked server "gtsun2" returned message "[Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "gtsun2".

CREATION OF LINKED SERVER USING ODBC [INFORMIX 2.80 32 BIT] OR [INTERSOLV 3.01 32-BIT INFORMIX]

EXEC sp_addlinkedserver
@server = N'gtsun2',
@srvproduct=N'Informix-CLI 2.9 (32 bit)',
@provider=N'MSDASQL',
@datasrc=N'Localserver',
@catalog='cmbs',
@provstr=N'server=gtsun2;
database=cmbs;
uid=reports;password=reports';

ADDING REMOTE USER
EXEC sp_addlinkedsrvlogin
@rmtsrvname='gtsun2',
@useself='false',
@locallogin='gtdomain\reports',
@rmtuser='reports',
@rmtpassword='reports'
THEN I USE select * from gtsun2.master.dbo.sysdatabases. THATS OK.

BUT WHEN I USE select * from gtsun2.master.dbo.sysdatabases, I GET THIS ERROR MESSAGE

I AM ALSO USING THIS TYPE OF SECURITY FOR MY LINKED SERVER. I HAVE ADDED USER reports. This user is known on the remote server and also on the domain of the local machine that has sqlserver2005.

SAARATU

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-03 : 13:03:20

Is your SQL Server 2005 64-bit?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources