Error 7399 Sql Server to Sybase

• Jay bajwa

  SSC Journeyman

  Points: 93

  More actions

  January 11, 2007 at 8:46 am

  #153378

   

  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

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  January 15, 2007 at 9:26 am

  #683281

  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."