Thread: Error with psqlodbc-7.2.3
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