bb.donnay-software.com
http://bb.donnay-software.com/Donnay/

Installation program for SqlQuery and Xdot
http://bb.donnay-software.com/Donnay/viewtopic.php?f=19&t=2623
Page 2 of 2

Author:  Auge_Ohr [ Fri Aug 02, 2019 7:24 pm ]
Post subject:  Re: Installation program for SqlQuery and Xdot

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 ?

Author:  rdonnay [ Sat Aug 03, 2019 1:02 pm ]
Post subject:  Re: Installation program for SqlQuery and Xdot

Add a new entry into your SQLQUERY.INI file:
Code:
[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.

Author:  Auge_Ohr [ Sat Aug 03, 2019 2:35 pm ]
Post subject:  Re: Installation program for SqlQuery and Xdot

Hi Roger,

rdonnay wrote:
Code:
[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 :?:

Attachment:
CTID.jpg
CTID.jpg [ 287.45 KiB | Viewed 3314 times ]


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

greetings by OHR
Jimmy

Author:  rdonnay [ Sat Aug 03, 2019 2:46 pm ]
Post subject:  Re: Installation program for SqlQuery and Xdot

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.

Author:  Auge_Ohr [ Sat Aug 03, 2019 3:55 pm ]
Post subject:  Re: Installation program for SqlQuery and Xdot

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.

Page 2 of 2 All times are UTC - 7 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/