FW: Using Postgres to Host MS Project 2003
am 09.05.2008 06:28:59 von mkondraguntaThis is a multi-part message in MIME format.
size=3D1>Thanks &=20
size=3D1>Madhusudhana Rao.=20
------_=_NextPart_001_01C8B18D.34F2AC60
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi All,
=20
After a long investigation and enabling tracing odbc driver on windows
got the following error.
=20
WINPROJ 1680-938 EXIT SQLBindCol with return code -1
(SQL_ERROR)
HSTMT 086B37F0
UWORD 52=20
SWORD -11
PTR 0x08AD7663
SQLLEN 16
SQLLEN * 0x08AD7DEB
=20
DIAG [S1003] [Microsoft][ODBC Driver Manager] Driver does not support
this parameter (0)=20
=20
does psqlodbc driver support SQL_C_GUID type...?
=20
and often i am getting the following error...
=20
WINPROJ 16dc-27c EXIT SQLSetStmtOption with return code -1
(SQL_ERROR)
HSTMT 08682208
UWORD 7
SQLPOINTER 0x00000001
=20
DIAG [S1011] [Microsoft][ODBC Driver Manager] Operation invalid at
this time (0).
=20
what is the cause of the error? any help would be greatly appreciated.
Thanks & Regards,=20
Madhusudhana Rao. K=20
________________________________
From: Kondragunta, Madhusudhana Rao (US - Hyderabad)=20
Sent: Wednesday, May 07, 2008 8:07 PM
To: pgsql-odbc@postgresql.org
Subject: Using Postgres to Host MS Project 2003
Hi,=20
I am trying to setup Postgres to host MS Project 2003,=20
I am using: postgresql 8.2=20
Pgodbc driver 8.03.02 -Ansi mode=20
MS Project 2003=20
=20
I followed
http://archives.postgresql.org/pgsql-patches/2001-02/msg0000 6.php
And added the extra tables and columns to the db.=20
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.=20
But, I am unable to open the project from DB, getting an error : Driver
does not support this parameter.=20
I tried with both bytea and lo (given in the contrib directory of 8.2).=20
Any help is greatly appreciated.=20
Thanks & Regards,=20
Madhusudhana Rao. K=20
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.=20
Any disclosure, copying, or distribution of this message, or the taking
of any action based on it, is strictly prohibited. [v.E.1]
------_=_NextPart_001_01C8B18D.34F2AC60
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
charset=3Dus-ascii">
tracing odbc=20
driver on windows got the following error.
size=3D2>
sp; =20
1680-938 EXIT SQLBindCol with return code -1=20
(SQL_ERROR)
HSTMT  =
; =20
086B37F0
UWORD &n=
bsp; &nb=
sp; =20
52=20
SWORD &nbs=
p;  =
;=20
-11=20
<SQL_C_GUID>
PTR =
=20
0x08AD7663
SQLLEN  =
; =
=20
16
SQLLEN=20
* =20
0x08AD7DEB
Driver=20
Manager] Driver does not support this parameter (0)
size=3D2>does psqlodbc driver support SQL_C_GUID=20
type...?
size=3D2>
often i am getting the following error...
size=3D2>
size=3D2>WINPROJ =20
16dc-27c EXIT SQLSetStmtOption with return code -1=20
(SQL_ERROR)
HSTMT  =
; =20
08682208
UWORD &n=
bsp; &nb=
sp; =20
7=20
<SQL_CONCURRENCY>
SQLPOINTER =
=20
0x00000001
size=3D2> DIAG [S1011] [Microsoft][ODBC Driver Manager] =
Operation=20
invalid at this time (0).
size=3D2>
is the cause of the error? any help would be greatly=20
appreciated.
Regards,
K=20
From: Kondragunta, Madhusudhana Rao =
(US -=20
Hyderabad)
Sent: Wednesday, May 07, 2008 8:07 =
PM
To:=20
pgsql-odbc@postgresql.org
Subject: Using Postgres to Host MS =
Project=20
2003
Hi,
I am trying to setup Postgres to host =
MS Project=20
2003,
I am using: postgresql 8.2 =
face=3DVerdana size=3D2>Pgodbc driver 8.03.02 -Ansi mode
face=3DVerdana size=3D2>MS Project 2003
size=3D2>
I =
followed href=3D"http://archives.postgresql.org/pgsql-patches/2001-02 /msg00006.php=
"> face=3DVerdana color=3D#0000ff=20
size=3D2>http://archives.postgresql.org/pgsql-patches/2001-0 2/msg00006.ph=
p face=3DVerdana size=3D2>
And added the extra tables and columns =
to the=20
db.
When I tried to add a project, It is =
giving an=20
error An unexpected error occurred : verify all arguments names and =
values are=20
correct . And may be out of memory.
Still the project is added in the =
database.=20
But, I am unable to open the project =
from DB,=20
getting an error : Driver does not support this parameter.
I tried with both bytea and lo (given =
in the=20
contrib directory of 8.2).
Any help is greatly appreciated. =
size=3D1>Thanks &=20
Regards,
size=3D1>Madhusudhana Rao.=20
K
attachments) contains=20
confidential information intended for a specific individual and purpose, =
and is=20
protected by law. If you are not the intended recipient, you =
should delete=20
this message.
distribution of this=20
message, or the taking of any action based on it, is strictly =
prohibited.=20
[v.E.1]
------_=_NextPart_001_01C8B18D.34F2AC60--