bb.donnay-software.com

Donnay Software Web Forums
It is currently Wed Oct 16, 2019 11:45 pm

All times are UTC - 7 hours




Post new topic Reply to topic  [ 15 posts ]  Go to page Previous  1, 2
Author Message
PostPosted: Fri Aug 02, 2019 7:24 pm 
Offline
User avatar

Joined: Wed Feb 24, 2010 3:44 pm
Posts: 1150
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


Top
 Profile  
 
PostPosted: Sat Aug 03, 2019 1:02 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 3988
Location: Boise, Idaho USA
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.

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Sat Aug 03, 2019 2:35 pm 
Offline
User avatar

Joined: Wed Feb 24, 2010 3:44 pm
Posts: 1150
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 558 times ]


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

greetings by OHR
Jimmy

_________________
greetings by OHR
Jimmy


Top
 Profile  
 
PostPosted: Sat Aug 03, 2019 2:46 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 3988
Location: Boise, Idaho USA
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.


Top
 Profile  
 
PostPosted: Sat Aug 03, 2019 3:55 pm 
Offline
User avatar

Joined: Wed Feb 24, 2010 3:44 pm
Posts: 1150
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


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 15 posts ]  Go to page Previous  1, 2

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group