Linked Server Data Access Problem

Hi,

Here is the problem:

I have a server that is linked to two other servers. The server I am linking has SQL Epress installed, whereas the servers I am linking to (and getting the data from) are enterprise versions of SQL. I used the following code to link both the servers (changing the server name and the datasrc field) and both worked fine.




Code Block
EXEC sp_addlinkedserver

@ Server='SALEEN',
@ srvproduct = 'SQL OLEDB Provider',
@ provider = 'MSDASQL',
@ datasrc = 'Debtsolv_Test'
GO

EXEC sp_addserverlogin 'SALEEN', 'false', 'NULL', 'sa', '**********'




One of the links is fine and I have no error messages when trying to access the data, but the second link throws this error when I attempt to get any data from the linked server:




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


I am pretty new to SQL and am totally stumped! If any one has any ideas I would be greatful.

Thanks