Installation program for SqlQuery and Xdot

[Auge_Ohr]

hi Roger,

you are right, it seem it use PgDBE while fail when delete libpqex.dll which ist much bigger (205 KB) than original libpq.dll.

it is the same XppFatal that try to load PgDBE. any Chance to load ODBC before PgDBE ?

[rdonnay]

Add a new entry into your SQLQUERY.INI file:

Code: Select all

[ODBC_4]
Name=PostGreSQL ANSI
Driver={PostgreSQL ANSI}
Uid=<your user id>
Pwd=<your password>
Database=<your database>

Then start up SQLQUERY.EXE and connect to that entry in the Treeview window.

[Auge_Ohr]

Hi Roger,

Code: Select all

[ODBC_4]
Name=PostGreSQL ANSI
Driver={PostgreSQL ANSI}
Uid=<your user id>
Pwd=<your password>
Database=<your database>

Then start up SQLQUERY.EXE and connect to that entry in the Treeview window.

YES ... i have change SQLQUERY.INI and now i can double-click in Treeview.

... but i got a Error in SQL-Statment
i have check SQL-Statment with PgAdmin and it work so what does Error Message say

CTID.jpg (287.45 KiB) Viewed 18438 times

Error talk about Column »ctid« ... where does it come from

greetings by OHR
Jimmy

[rdonnay]

I had this same problem when trying to use that PostGreSql ODBC driver.

It appears to be a problem with the ODBCDBE.

I suspect that we are not going to get much help from Alaska Software on this issue because they are always pushing us to use the PGDBE for PostGreSql.

I will send them an email about this and see if they can help.

[Auge_Ohr]

I will send them an email about this and see if they can help.

ok, let see if we get an Answer from Alaska.