Accessing H2 via PostgreSQL ODBC driver

[Victor Wong]

I am able to connect to the H2 server using the ODBC driver, but
cannot see my tables on the server. I'm using H2 1.1.114 and
psqlodbc_08_03_0400. I can see the tables in the INFORMATION_SCHEMA,
but not the tables I created when opening a connection from Excel via
MS Query. Is anyone else having similar problems?

Thanks in advance,
Victor

[Thomas Mueller]

Hi,

How did you start the PG server? Did you use the baseDir option? See
also: http://www.h2database.com/html/advanced.html#odbc_driver

Regards,
Thomas

[Victor Wong]

Thanks, Thomas. I realized that the server was creating a new
database and not opening the one I had accessed from the console. The
-baseDir and -ifExists options fixed that.

Victor

On Jun 22, 8:43 pm, Thomas Mueller <thomas.tom.muel...@gmail.com>
wrote:

[syed usman]

Hi Victor,

Can you please list me the steps you use to connect h2 server via postgresql odbc driver.

I am actually trying to connect Ruby with h2 database. One of the solution i read was we can do it via postgresql odbc driver. thanks

syed

[Thomas Mueller]

Hi,

This should be documented under http://h2database.com/html/advanced.html#odbc_driver

Regards,

Thomas

--
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...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.

[kenlo]

I am actually trying to connect Ruby with h2 database. One of the solution i read was we can do it via postgresql odbc driver. thanks

I use Lua with luapgsql module compiled against the postgresql-9.3.5-1-windows-binaries.  There is no need to go through the odbc driver.  Ruby should have similar interfaces to postgresql.