Installation program for SqlQuery and Xdot

SqlQuery is a library and utility program that utilizes the best features of Xbase++ and eXpress++ for SQL browsing of data via ADSDBE, PGDBE and ODBCDBE.
Message
Author
User avatar
Auge_Ohr
Posts: 1405
Joined: Wed Feb 24, 2010 3:44 pm

Re: Installation program for SqlQuery and Xdot

#11 Post 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 ?
greetings by OHR
Jimmy

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Installation program for SqlQuery and Xdot

#12 Post 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.
The eXpress train is coming - and it has more cars.

User avatar
Auge_Ohr
Posts: 1405
Joined: Wed Feb 24, 2010 3:44 pm

Re: Installation program for SqlQuery and Xdot

#13 Post 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 11222 times
Error talk about Column »ctid« ... where does it come from :?:

greetings by OHR
Jimmy
greetings by OHR
Jimmy

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Installation program for SqlQuery and Xdot

#14 Post 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.
The eXpress train is coming - and it has more cars.

User avatar
Auge_Ohr
Posts: 1405
Joined: Wed Feb 24, 2010 3:44 pm

Re: Installation program for SqlQuery and Xdot

#15 Post 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.
greetings by OHR
Jimmy

Post Reply