Tuesday, March 20, 2012

Remote server query

I am getting the following error:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [DataDirect][ODBC Sybase Wire Protocol driver]Insufficient information to connect to the data source.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].

Any idea?

Thanks, YBWhat code created this error? (Your connection string would be helpful).|||I am using the sp_addlinkedserver stored procedure and then trying to do an open query.
Here is the code below.

sp_addlinkedserver 'ABCDE','','MSDASQL','ABCDE',null, 'UID=username;PWD=passwd;Database=database;
Select * into Reports.dbo.Results from openquery(ABCDE, 'select * from Result');

Thanks.|||Try breaking the database off of the @.provstr parameter, and setting that in the @.catalog parameter.

No comments:

Post a Comment