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: [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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/52588256-f671-455e-8444-fc51c9e52e07%40googlegroups.com.
