FW: Using Postgres to Host MS Project 2003

["Kondragunta, Madhusudhana Rao (US - Hyderabad)" <mkondragunta(at)deloitte(dot)com>]

Title: 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

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]