Status of PostgreSQL ODBC support

[testingsolutions]

Hi,

is there any activity on the native PostgreSql implementation?

I am trying to access a H2 db via ODBC. I managed to setup the connection in odbc64.exe using the 09.03.0300 version of the PostgreSQL 64bit-driver.

Any later version will result in an error when trying to test the connection (SET EXTRA_FLOAT_DIGITS[*] TO 2).

The ODBC datasource is usable with Ecxel, however, trying to load data with PowerBi fails (apparently a problem reading the foreign keys of the db -which are empty in my case-, PGAPI_ForeignKeys query error).

Has anybody some hints where to start?

Regards,

Armin

[Eduard G]

Hello Armin,

fighting since 2 days with same problematic.

I have WIn7 x64.

As H2 is a x86 application, installed jdk-8u251-windows-i586.exe

Started H2:

C:\Program Files (x86)\H2\bin>java -cp h2-1.4.200.jar org.h2.tools.Server -pgAllowOthers
TCP server running at tcp://192.168.1.204:9092 (only local connections)
PG server running at pg://192.168.1.204:5435 (others can connect)
Web Console server running at http://192.168.1.204:8082 (others can connect)

Tried first with h2-1.4.200 and psqlodbc_12_01_0000, 11_01_0000, 11_00_0000 and 08_02_0100 (this version has no test button in the ODBC administrator).

Like in the documentation stays, added a DSN (PostgreeSQL Unicode) into System-DSN ODBC Administrator 32-Bit and got always same massage like yours.

Only 09.03.0300 gave me success:

Haven't done any further testing, because it made me so tired :(

What about your problem, have you or anybody any solutions?

Eduard

[Evgenij Ryazanov]

Hello.

I guess only few people really use it.

If some SET commands fail, you can add some dummy implementations for them here:

https://github.com/h2database/h2database/blob/93f51bf336de1ce7af598f890a6557052c1d6dc4/h2/src/main/org/h2/command/Parser.java#L8371

But you may run into some much more serious problem with some drivers / applications; H2 is not the PostgreSQL and can't have all its features.