ODBC doesn't connect

[Michael Peters]

please post a PostgreSQL ODBC driver that works with H2 and Windows,
and detailed instructions how to use it.

I installed Railo (Resin version 3.1.9) for Windows - I want to make a
CD version of a database driven app that in the online version uses
ColdFusion and a MSAccess database. The database version that I need
for the CD is very simple and only needs one table (that could change
of course).

I installed a PostgreSQL driver, and added a PostgreSQL datasource for
the new H2 database (server=localhost, database=the name I entered in
the Railo Admin, user=the username, password=the password, port=8080
because the Railo webserver uses this port). After clicking the test
button, I wait for several minutes, then there is a message telling me
"unexpected protocol character = H during authentication".

Don't know if the driver is wrong or if I made some mistake. Would
appreciate help.

-Michael

[Kerry Sainsbury]

Does this help: http://www.h2database.com/html/advanced.html#odbc_driver

I think your major problem was giving the ODBC driver the port number of your webserver, rather than the port number you have H2 running on.

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.