Thread: FW: Using Postgres to Host MS Project 2003
FW: Using Postgres to Host MS Project 2003
From
"Kondragunta, Madhusudhana Rao (US - Hyderabad)"
Date:
Hi All,
After a long investigation and enabling tracing odbc driver on windows got the following error.
WINPROJ 1680-938 EXIT SQLBindCol with return code -1 (SQL_ERROR)
HSTMT 086B37F0
UWORD 52
SWORD -11 <SQL_C_GUID>
PTR 0x08AD7663
SQLLEN 16
SQLLEN * 0x08AD7DEB
HSTMT 086B37F0
UWORD 52
SWORD -11 <SQL_C_GUID>
PTR 0x08AD7663
SQLLEN 16
SQLLEN * 0x08AD7DEB
DIAG [S1003] [Microsoft][ODBC Driver Manager] Driver does not support this parameter (0)
does psqlodbc driver support SQL_C_GUID type...?
and often i am getting the following error...
WINPROJ 16dc-27c EXIT SQLSetStmtOption with return code -1 (SQL_ERROR)
HSTMT 08682208
UWORD 7 <SQL_CONCURRENCY>
SQLPOINTER 0x00000001
HSTMT 08682208
UWORD 7 <SQL_CONCURRENCY>
SQLPOINTER 0x00000001
DIAG [S1011] [Microsoft][ODBC Driver Manager] Operation invalid at this time (0).
what is the cause of the error? any help would be greatly appreciated.
Thanks & Regards,
Madhusudhana Rao. K
From: Kondragunta, Madhusudhana Rao (US - Hyderabad)
Sent: Wednesday, May 07, 2008 8:07 PM
To: pgsql-odbc@postgresql.org
Subject: Using Postgres to Host MS Project 2003
Hi,
I am trying to setup Postgres to host MS Project 2003,
I am using: postgresql 8.2
Pgodbc driver 8.03.02 -Ansi mode
MS Project 2003
I followed http://archives.postgresql.org/pgsql-patches/2001-02/msg00006.php
And added the extra tables and columns to the db.
When I tried to add a project, It is giving an error An unexpected error occurred : verify all arguments names and values are correct . And may be out of memory.
Still the project is added in the database.
But, I am unable to open the project from DB, getting an error : Driver does not support this parameter.
I tried with both bytea and lo (given in the contrib directory of 8.2).
Any help is greatly appreciated.
Thanks & Regards,
Madhusudhana Rao. K
This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message.
Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]