Postgres Pro
Downloads
Home   >   mailing lists

Error with psqlodbc-7.2.3 - Mailing list pgsql-odbc

From Nuno Pimenta, Eng.
Subject Error with psqlodbc-7.2.3
Date
Msg-id 71F4CF1F0CCADE488C1DC39B8676FBDB077B6589@TMNSEDEX06.tmn.corppt.com
Whole thread Raw
List pgsql-odbc
Tree view

Hello all,

 

I’m using psqlodbc-7.2.3 to access the (PostgreSQL) 7.2.3.

 

I’m doing  the following command: SELECT "userinfo"."date", "userinfo"."login", "userinfo"."passwdhaschanged", "userinfo"."registrycompleteness", "userinfo"."weblastaccessdate", "userinfo"."lastupdatedate", "userinfo"."username", "userinfo"."userstatus", "userinfo"."firstweblogin", "userinfo"."ispersonalized" FROM "userinfo";

 

And the error returning was:

 

ODBCTestUserInfo1..Transformer_0: |ODBCTestUserInfo1..ODBC_2.DSLink3: DSD.BCIOpenR call to SQLExecDirect failed.

Statement was:SELECT "userinfo"."date", "userinfo"."login", "userinfo"."passwdhaschanged", "userinfo"."registrycompleteness", "userinfo"."weblastaccessdate", "userinfo"."lastupdatedate", "userinfo"."username", "userinfo"."userstatus", "userinfo"."firstweblogin", "userinfo"."ispersonalized" FROM "userinfo"

SQLSTATE=S1010, DBMS.CODE=3

[DataStage][SQL Client][ODBC]No query has been executed with that handle;

Unexpected protocol character from backend (send_query)|

 

Anyone can help me with this error?

 

Thanks in advance.

 

 

Nuno Pimenta

 

pgsql-odbc by date:

Previous
From: "Hamlen, Peter"
Date:
Subject: Can I get Postgresql ODBC to accept ODBC Timestamp escape sequences?
Next
From: Zaw Win Aung
Date:
Subject: Unsubscribe