January 11, 2007 at 8:46 am
Hi All,
I have seen numerous threads related to the above, however nothing seems to help me with the errors as stated below. I have tried numerous formats to no avail :
dbcc traceon (7300, 3604)
insert OPENQUERY(INVENT, 'select servername, databasename from sqlserver_backup')
values('TEST', 'TEST')
insert into INVENT.foo.dbo.sqlserver_backup' values('TEST', 'TEST')
All fail with :
Server: Msg 7399, Level 16, State 1, Line 3
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: The provider did not give any information about the error.].
This is from Sql Server 2000 to Sybase 12.5.1.
Select statements work fine. Any help would be greatly appreciated.
January 15, 2007 at 8:00 am
This was removed by the editor as SPAM
January 15, 2007 at 9:26 am
please do not cross post --> http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=92&messageid=336187
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply