Postgres Pro
Downloads
Home   >   mailing lists

psqlOdbc Ansi + BDE issues - Mailing list pgsql-odbc

From Miguel Juan
Subject psqlOdbc Ansi + BDE issues
Date
Msg-id 005801c5e6bf$3f0918f0$07c8a8c0@Miguel
Whole thread Raw
List pgsql-odbc
Tree view
Hi,
 
I'm testing the Ansi version of the psqlodbc-08.01.0100 and I have found a few isues.
 
If you open a table with the BDE SQL explorer, now it shows all the text fields (char, varchar and text), but for the TEXT type it show the contents as MEMO. This behavior could be changed in prior versions  unchecking the "Text as LongVarChar" option and checking the "Longest" option in the "Unknown Sizes" section.
 
Now, it can be fixed only changing the "Max LongVarchar" edit to 254. It looks like the driver it is not using the "longest" option in the configuration.
 
If you open the database schema with the sql explorer it does not show all the tables, and each table that it shows appears 6 times. It is easy to reproduce, because it happens with all the system tables.
 
Regards,
 
Miguel Juan
 
 

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000417 ] odbc_lib_connect() returns "Specified driver could not be loaded due to system error 182 (PostgreSQL ANSI)"
Next
From: "gunawan"
Date:
Subject: How to use this ODBC