SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 sqlserver2005 cant link to my informix server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aburabbi
Starting Member

Ghana
1 Posts

Posted - 12/07/2008 :  22:41:29  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 01/03/2009 :  13:03:20  Show Profile  Reply with Quote
Is your SQL Server 2005 64-bit?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000