Hi, I have had a ASP Website working for the 5 years and have had no problems until at the weekend I replace my database server with a newer one. Database server (old): Postgres 9.4 64bit Database server (new): Postgres 12.6 64bit The Website connect to PostgreSQL 9.4 64bit with psqlodbc_10_03_0000-x86(32bit). Since the upgrade I have been getting the following error message. Number: -2147217887 Description: Multiple-step OLE DB operation generated errors. I found that the problem occurred in the third step: Step 1. Starts a new transaction with the BeginTrans method. Step 2. Creates an OraDynaset object from the specified SQL SELECT statement SQL-A. Step 3. Creates an OraDynaset object from the specified SQL SELECT statement SQL-B. Step 4. Ends the current transaction with the CommitTrans method. I have changed a newer version of odbc driver with psqlodbc_11_00_0000-x86(32bit) on my site and everything appears to be working fine now. psqlODBC 11.00.0000 Release notes Changes:
1.Remove obsolete maps pointed out. POWER -> pow, CONCAT -> textcat, LEFT -> ltrunc, RIGHT -> rtrunc Patch by Daniel Cory. 2.Remove connSettings option and/or pqopt option from the OutConnectionString parameter of SQLDriverConnect() when each option doesn't exist in InConnectionString parameter. 3.The parameters should be cast because parameters of concat() function are variadic "any". 4.Unbuffered-IO in Windows is incredibly slow. Instead call fflush() after fprintf(). 5.Add an alias DX of *Database* keyword for connection strings to aviod the use of "database" keyword which has a special meaning in some apps or middlewares. 6.numeric items without precision are unlimited and there's no natural map between SQL Data types. Add an option *Numeric(without precision) as*. 7.Fix a bug that SQLSpecialColumns() returns oid/xmin incorrectly when a table does not exist. Patch by Quan Zongliang. I want to know which change of the psqlODBC solves the error? Regards, -- gzh
