Unexpected error when importing numerical data fields.

• A Ironside

  SSC Rookie

  Points: 39

  More actions

  June 2, 2005 at 6:25 am

  #88524

  I'm using SQL Server 2000 to import tables from am ODBC Oracle provider. When the data fields are text only, the import works well. When I include a numerical field, I get the following:

  Context: Error calling GetNextRows. Your provider does not support all the interfaces/methods required by DTS.

  and

  HResult of 0x80074005 (-2147008507) returned. Unexpected error occured. An error result was returned without an error message.

  I've isolated the problem to my SQL server config, because I can pull the same data with MS Access and with Oracle SQL*Plus on the same server.

  Any ideas? Any help would be appreciated.

• Shaun McKee

  SSC Veteran

  Points: 216

  More actions

  June 6, 2005 at 7:35 am

  #563183

  A similar post was made a few years ago on experst exchange.  Here is the link: http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20130720.html

  Specifically the post by AngelIII "How do you connect to Oracle (ODBC/OLEDB)

  I assume that you use ODBC, and you should try OLEDB Provider instead..."

  Good luck.