[h2] Re: Status of PostgreSQL ODBC support

[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.

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/f40b486b-e7b3-41b2-9b8a-d222e8bc79dd%40googlegroups.com.

[h2] Re: Status of PostgreSQL ODBC support

[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_, 11_01_, 11_00_ 
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:



[image: add_dsn.png]


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

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

Eduard


Am Donnerstag, 21. November 2019 09:52:41 UTC+1 schrieb 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
>
>
>
>
>
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/h2-database/52588256-f671-455e-8444-fc51c9e52e07%40googlegroups.com.