For the error related to the java command, java was not able to find the h2 jar files. You need to launch the command in the directory where the jar files are or specify their correct location (-cp switch of the command line).
I have no specific idea for the first error. Are you sure you have installed the driver for the good architecture ? On May 10, 6:01 pm, de Milns <[email protected]> wrote: > Thanks for your input - I have tried to follow the instruction given > in the H2 documentation but I have had sevveral problems > I installed PsqlODBC > I ran the c:\windows\syswow64\odbcad32.exe and added the PostgreSQL > following the table given in the documentation. > When I tried a Configure to check the data entered I got the following > errors > > The setup routines for the PostgreSQL ODBC driver could not be found. > Please reinstall the driver > > then > > Errors Found: > > The specified DSN contains an archecture mismatch between the Driver > and Application. > > I also tried the first Java command and this was the response > > I tried to remove the entry and got the same errors as above. > > java -cp h2*.jar org.h2.tools.Server > Exception in thread "main" java.lang.NoClassDefFoundError: org/h2/ > tools/ > Caused by: java.lang.ClassNotFoundException: org.h2.tools.Server > at java.net.URLClassLoader$1.run(Unknown Source) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(Unknown Source) > at java.lang.ClassLoader.loadClass(Unknown Source) > at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) > at java.lang.ClassLoader.loadClass(Unknown Source) > Could not find the main class: org.h2.tools.Server. Program will > exit. > > To recover I had to do a system restore to a point before the first > install of PsqlODBC > > What am I doing wrong. > > On May 10, 1:49 am, Sylvain <[email protected]> wrote: > > > > > Hi, > > > Check out the ODBC section > > herehttp://www.h2database.com/html/advanced.html#odbc_driver. > > > You should be able to connect the H2 database by specifying the > > postgre sql driver. I managed to access a H2 database from a python > > script using python odbc module. > > > Sylvain. > > > On 9 mai, 17:01, de Milns <[email protected]> wrote: > > > > I am new to H2 and would like to do a connect from classic asp to an > > > H2 database > > > can anyone suggest what I need - I have installed PsqlODBC and the H2 > > > drivers fromhttp://www.h2database.com/html/main.html > > > My equivalent statements for a SQLite database are > > > Set conn=Server.CreateObject("ADODB.Connection") > > > connOpen = "Driver={SQLite ODBC Driver};Database=" & DataPath & > > > Database > > > on error resume next > > > conn.Open connOpen > > > I would appreciate to get going > > > Thanks > > > Dennis > > > > -- > > > 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 > > > athttp://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 > > athttp://groups.google.com/group/h2-database?hl=en.-Hide quoted text - > > > - Show quoted text - > > -- > 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 > athttp://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.
