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