Page 2 of 2

Re: Installation program for SqlQuery and Xdot

Posted: Fri Aug 02, 2019 7:24 pm
by 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 ?

Re: Installation program for SqlQuery and Xdot

Posted: Sat Aug 03, 2019 1:02 pm
by 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.

Re: Installation program for SqlQuery and Xdot

Posted: Sat Aug 03, 2019 2:35 pm
by Auge_Ohr
Hi Roger,
rdonnay wrote:

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. :clap:

... 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
CTID.jpg (287.45 KiB) Viewed 11212 times
Error talk about Column »ctid« ... where does it come from :?:

greetings by OHR
Jimmy

Re: Installation program for SqlQuery and Xdot

Posted: Sat Aug 03, 2019 2:46 pm
by 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.

Re: Installation program for SqlQuery and Xdot

Posted: Sat Aug 03, 2019 3:55 pm
by Auge_Ohr
rdonnay wrote:I will send them an email about this and see if they can help.
ok, let see if we get an Answer from Alaska.