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.
Tuesday, March 20, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment