www.Inmagic.com    Inmagic Forums    Inmagic Forums  Hop To Forum Categories  ODBC    ODBC Error - Unable to open table
Go
New
Find
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Posted
We have successfully pulled over 5000 records into our .net application from Inmagic Content Server via the latest version of the InMagic Content Server odbc driver to crawl, make the query and retreive the records from an individual database. Of these we have around 50 records that do not import. We get the same warning message for each of them:

Message: System.Data.Odbc.OdbcException: ERROR [S0000] [InMagic, Inc.] [CS
ODBC Driver] [Content Server] Unable to open table
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode
retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject()

Any ideas why only a fraction of the records are rejected? Don't think it is a permissions problem as we are able to get most of them. We have the MSDE Version 1.3 of Content Server running on a Windows 2000 Server. Our asp.net application is running on a Windows 2003 server.

The records are not special in a way and different records get rejected each time we try a crawl or incremental crawl. We always get some errors regardless of the size of database we are crawling.
 
Posts: 171 | Registered: Tue June 08 2004Reply With QuoteEdit or Delete MessageReport This Post
  Powered by Eve Community  
 

www.Inmagic.com    Inmagic Forums    Inmagic Forums  Hop To Forum Categories  ODBC    ODBC Error - Unable to open table