FW: Using Postgres to Host MS Project 2003

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

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

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(at)postgresql(dot)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
<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]