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. On Thu, Mar 18, 2010 at 5:26 AM, Michael Peters <[email protected]> wrote: > 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 > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<h2-database%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
