[Oledb-dev] Error while altering/inserting records in DB

[Andrew Wiens]

  Hello.  First off, thanks for creating this Driver.  I'm hoping that it'll
allow me to move an application from Sybase ASA to Postgresql 8.1.  However,
I'm running into a problem after making the switch, but am not completely
sure that it's the driver.  I can view data from the DB, but am unable to
save data.  Most likely, whatever's happening is basic and I'm just not
recognizing it.  Unfortunately, I'm at a loss for what to try next.  If you
have an extra second or two, please take a look at the exception and log
and, if it's something easy, point me in the right direction?  Thanks for
any help you can offer!

  The error follows immediately and the tail of the log file directly after
that:

  ************* Exception Text **************
  System.Data.OleDb.OleDbExcepti
on: 'PostgreSQL' failed with no error message available, result code:
DB_E_BADTYPENAME(0x80040E30).
     at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs
rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
     at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs
rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount)
     at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows,
DataTableMapping tableMapping)
     at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable
dataTable, DataTableMapping tableMapping)
     at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String
srcTable)
     at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)



  ********** Log file *******************
  CPgRowset::~CPgRowset
  IObjectWithSiteImpl::GetSite
  CATLCOLUMNINFO delete 0x03CA5710 pwszName=0x03CA5108
  CATLCOLUMNINFO delete 0x03CA5744 pwszName=0x03CA4E48
  CATLCOLUMNINFO delete 0x03CA5778 pwszName=0x03CA5020
  CATLCOLUMNINFO delete 0x03CA57AC pwszName=0x03CA4E30
  CPgVirtualArray::~CPgVirtualArray
  CPgMultipleResults::GetResult no more rowsets
  IDBPropertiesImpl::SetProperties
  IDBInitializeImpl::Initialize
  IDBCreateSessionImpl::CreateSession
  IDBPropertiesImpl::GetProperties
  CErrorLookupService::ClearErrorCPgSession::PQexec 0, "SET client_encoding
TO "Unicode""
  CPgSession::PQexec 0, "select oid from pg_type where typname='utinyint'"
  CPgSession::PQexec 0, "select oid from pg_type where typname='varcharci'"
  CPgSession::PQexec 0, "SELECT oid, typalign FROM pg_type"
  IDBCreateCommandImpl::CreateCommand
  IObjectWithSiteImpl::SetSite
  ICommandPropertiesImpl::SetProperties
  CPgCommand::SetParameterInfo
  CErrorLookupService::ClearErrorIObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  IObjectWithSiteImpl::GetSite
  CPgCommand::SetParameterInfo DBTYPE name lookup failed
  IDBPropertiesImpl::GetProperties

  Thanks again,
 --Andy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/oledb-devel/attachments/20060616/efa47a05/attachment.html