This is a multi-part message in MIME format.
------_=_NextPart_001_01C8B18D.34F2AC60
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
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.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/msg0000 6.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]
------_=_NextPart_001_01C8B18D.34F2AC60
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Using Postgres to Host MS Project 2003</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.3314" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana color=3D#0000ff =
size=3D2><SPAN
class=3D602341404-09052008>Hi All,</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana color=3D#0000ff =
size=3D2><SPAN
class=3D602341404-09052008></SPAN></FONT> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana color=3D#0000ff =
size=3D2><SPAN
class=3D602341404-09052008>After a long investigation and enabling =
tracing odbc
driver on windows got the following error.</SPAN></FONT></DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana color=3D#0000ff =
size=3D2><SPAN
class=3D602341404-09052008></SPAN></FONT><FONT face=3DVerdana =
color=3D#0000ff
size=3D2><SPAN class=3D602341404-09052008></SPAN></FONT> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana color=3D#0000ff =
size=3D2><SPAN
class=3D602341404-09052008>WINPROJ &nb=
sp;
1680-938 EXIT SQLBindCol with return code -1
(SQL_ERROR)<BR> HSTMT =
;
086B37F0<BR> UWORD &n=
bsp; &nb=
sp;
52
<BR> SWORD &nbs=
p; =
;
-11
<SQL_C_GUID><BR> PTR =
0x08AD7663<BR> SQLLEN =
; =
16<BR> SQLLEN
*
0x08AD7DEB</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV dir=3Dltr align=3Dleft><FONT face=3DVerdana color=3D#0000ff =
size=3D2><SPAN
class=3D602341404-09052008> DIAG [S1003] [Microsoft][ODBC =
Driver
Manager] Driver does not support this parameter (0) </SPAN></FONT></DIV>
<DIV><FONT face=3DVerdana color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff
size=3D2><STRONG>does psqlodbc driver support SQL_C_GUID
type...?</STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff size=3D2>and
often i am getting the following error...</FONT></SPAN></DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff
size=3D2>WINPROJ
16dc-27c EXIT SQLSetStmtOption with return code -1
(SQL_ERROR)<BR> HSTMT =
;
08682208<BR> UWORD &n=
bsp; &nb=
sp;
7
<SQL_CONCURRENCY><BR> SQLPOINTER =
0x00000001</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff
size=3D2> DIAG [S1011] [Microsoft][ODBC Driver Manager] =
Operation
invalid at this time (0).</FONT></SPAN></DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D602341404-09052008><FONT face=3DVerdana =
color=3D#0000ff size=3D2>what
is the cause of the error? any help would be greatly
appreciated.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><B><SPAN lang=3Den-gb><FONT face=3DVerdana color=3D#000066 =
size=3D1>Thanks &
Regards,</FONT></SPAN></B> </P>
<P><B><SPAN lang=3Den-gb><FONT face=3DVerdana color=3D#000066 =
size=3D1>Madhusudhana Rao.
K</FONT></SPAN></B>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Kondragunta, Madhusudhana Rao =
(US -
Hyderabad) <BR><B>Sent:</B> Wednesday, May 07, 2008 8:07 =
PM<BR><B>To:</B>
pgsql-odbc [at] postgresql.org<BR><B>Subject:</B> Using Postgres to Host MS =
Project
2003<BR></FONT><BR></P>
<DIV></DIV>
<DIV><FONT face=3DVerdana size=3D2><!-- Converted from text/rtf format =
-->
<P><FONT face=3DVerdana size=3D2>Hi, </FONT></P>
<P><FONT face=3DVerdana size=3D2>I am trying to setup Postgres to host =
MS Project
2003, </FONT></P>
<P><FONT face=3DVerdana size=3D2>I am using: postgresql 8.2</FONT> =
<BR><FONT
face=3DVerdana size=3D2>Pgodbc driver 8.03.02 -Ansi mode</FONT> =
<BR><FONT
face=3DVerdana size=3D2>MS Project 2003</FONT> <BR><FONT face=3DVerdana
size=3D2> </FONT> <BR><FONT face=3DVerdana size=3D2>I =
followed </FONT><A
href=3D"http://archives.postgresql.org/pgsql-patches/2001-02 /msg00006.php=
"><U><FONT
face=3DVerdana color=3D#0000ff
size=3D2>http://archives.postgresql.org/pgsql-patches/2001-0 2/msg00006.ph=
p</FONT></U></A><FONT
face=3DVerdana size=3D2> </FONT></P>
<P><FONT face=3DVerdana size=3D2>And added the extra tables and columns =
to the
db.</FONT> </P>
<P><FONT face=3DVerdana size=3D2>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.</FONT></P>
<P><FONT face=3DVerdana size=3D2>Still the project is added in the =
database.</FONT>
</P>
<P><FONT face=3DVerdana size=3D2>But, I am unable to open the project =
from DB,
getting an error : Driver does not support this parameter.</FONT> </P>
<P><FONT face=3DVerdana size=3D2>I tried with both bytea and lo (given =
in the
contrib directory of 8.2). </FONT></P>
<P><FONT face=3DVerdana size=3D2>Any help is greatly appreciated.</FONT> =
</P>
<P><B><SPAN lang=3Den-gb><FONT face=3DVerdana color=3D#000066 =
size=3D1>Thanks &
Regards,</FONT></SPAN></B> </P>
<P><B><SPAN lang=3Den-gb><FONT face=3DVerdana color=3D#000066 =
size=3D1>Madhusudhana Rao.
K</FONT></SPAN></B> </P><BR><BR></FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>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. <BR><BR></FONT></DIV>
<DIV><FONT face=3DVerdana size=3D2>Any disclosure, copying, or =
distribution of this
message, or the taking of any action based on it, is strictly =
prohibited.
[v.E.1]<BR></FONT></DIV></BODY></HTML>
------_=_NextPart_001_01C8B18D.34F2AC60--
