FW: Using Postgres to Host MS Project 2003

FW: Using Postgres to Host MS Project 2003

am 09.05.2008 06:28:59 von mkondragunta

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
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
=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 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


Using Postgres to Host MS Project 2003
charset=3Dus-ascii">


size=3D2> class=3D602341404-09052008>Hi All,

size=3D2> class=3D602341404-09052008> 

size=3D2> class=3D602341404-09052008>After a long investigation and enabling =
tracing odbc=20
driver on windows got the following error.

size=3D2> class=3D602341404-09052008> color=3D#0000ff=20
size=3D2>
 

size=3D2> class=3D602341404-09052008>WINPROJ      &nb=
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

 

size=3D2> class=3D602341404-09052008>  DIAG [S1003] [Microsoft][ODBC =
Driver=20
Manager] Driver does not support this parameter (0)

 

color=3D#0000ff=20
size=3D2>does psqlodbc driver support SQL_C_GUID=20
type...?

color=3D#0000ff=20
size=3D2>
 

color=3D#0000ff size=3D2>and=20
often i am getting the following error...

color=3D#0000ff=20
size=3D2>
 

color=3D#0000ff=20
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

 

color=3D#0000ff=20
size=3D2>  DIAG [S1011] [Microsoft][ODBC Driver Manager] =
Operation=20
invalid at this time (0).

color=3D#0000ff=20
size=3D2>
 

color=3D#0000ff size=3D2>what=20
is the cause of the error? any help would be greatly=20
appreciated.

size=3D1>Thanks &=20
Regards,


size=3D1>Madhusudhana Rao.=20
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




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. 


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]


------_=_NextPart_001_01C8B18D.34F2AC60--