OK, so now I'm a little (more) confused, because doesn't the PG Server start automatically? At least it's showing up as running in Terminal...
Web Console server running at http://192.168.23.17:8082 (others can connect) TCP server running at tcp://192.168.23.17:9092 (others can connect) PG server running at pg://192.168.23.17:5435 (others can connect) I stepped back to 1.3.169 (last stable) version of H2 to see if that would help -- it didn't. Here is my process. DB I'm trying to connect with is regapp.h2.db in the ~/RegApp/dbhome directory: I'm using the h2.sh shell script to start the H2 Server. $ cat h2.sh #!/bin/sh dir=$(dirname "$0") java -cp "$dir/h2-1.3.169.jar:$H2DRIVERS:$CLASSPATH" org.h2.tools.Console "$@" $ ./h2.sh -pgAllowOthers -tcpAllowOthers -webAllowOthers -baseDir ~/RegApp/dbhome -trace >RegApp.log The PostgreSQL ODBC is configured on the Windows machine, and [ Test ] returns a "Connection Successful" message. Start Access, open local mdb, then go to Insert > Tables > Link... Select ODBC as the Datasource, then point to the PostgreSQL System DSN. A list of tables will come up (this looks correct to me). Select one, then it returns an ODBC connection failed due to a "Error while executing the query (#7)" Here is the last bit of the log. If it helps to include more, please let me know. Connect Init StartupMessage version 196608 (3.0) param database=~/RegApp/dbhome/regapp param user=sa param DateStyle=ISO param extra_float_digits=2 param geqo=on param client_encoding=UTF8 PasswordMessage Query select oid, typbasetype from pg_type where typname = 'lo'; Query SELECT Config, nValue FROM MSysConf; Query select relname, nspname, relkind from pg_catalog.pg_class c, pg_catalog.pg_namespace n where relkind in ('r', 'v') and n.oid = relnamespace order by nspname, relname; Query select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'Event' and u.nspname = E'PUBLIC'; Query select n.nspname, c.relname, a.attname, a.atttypid, t.typname, a.attnum, a.attlen, a.atttypmod, a.attnotnull, c.relhasrules, c.relkind, c.oid, pg_get_expr(d.adbin, d.adrelid), case t.typtype when 'd' then t.typbasetype else 0 end, t.typtypmod, c.relhasoids from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like E'Event' and n.nspname like E'PUBLIC') inner join pg_catalog.pg_attribute a on (not a.attisdropped) and a.attnum > 0 and a.attrelid = c.oid) inner join pg_catalog.pg_type t on t.oid = a.atttypid) left outer join pg_attrdef d on a.atthasdef and d.adrelid = a.attrelid and d.adnum = a.attnum order by n.nspname, c.relname, attnum; Terminate Close Disconnect Close When I put any of these queries in the Console, it returns an error: select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'Event' and u.nspname = E'PUBLIC'; Schema "PG_CATALOG" not found; SQL statement: select c.relhasrules, c.relkind, c.relhasoids from pg_catalog.pg_namespace u, pg_catalog.pg_class c where u.oid = c.relnamespace and c.relname = E'Event' and u.nspname = E'PUBLIC' [90079-169] 90079/90079 (Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90079> and apparently, the error message above links to this: at org.h2.message.DbException.getJdbcSQLException(DbException.java:329<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=329&build=169> ) at org.h2.message.DbException.get(DbException.java:169<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=169&build=169> ) at org.h2.message.DbException.get(DbException.java:146<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=146&build=169> ) at org.h2.command.Parser.getSchema(Parser.java:613<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=613&build=169> ) at org.h2.command.Parser.getSchema(Parser.java:620<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=620&build=169> ) at org.h2.command.Parser.readTableFilter(Parser.java:1059<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1059&build=169> ) at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1690<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1690&build=169> ) at org.h2.command.Parser.parseSelectSimple(Parser.java:1797<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1797&build=169> ) at org.h2.command.Parser.parseSelectSub(Parser.java:1684<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1684&build=169> ) at org.h2.command.Parser.parseSelectUnion(Parser.java:1527<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1527&build=169> ) at org.h2.command.Parser.parseSelect(Parser.java:1515<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=1515&build=169> ) at org.h2.command.Parser.parsePrepared(Parser.java:405<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=405&build=169> ) at org.h2.command.Parser.parse(Parser.java:279<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=279&build=169> ) at org.h2.command.Parser.parse(Parser.java:251<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=251&build=169> ) at org.h2.command.Parser.prepareCommand(Parser.java:217<http://h2database.com/html/source.html?file=org/h2/command/Parser.java&line=217&build=169> ) at org.h2.engine.Session.prepareLocal(Session.java:415<http://h2database.com/html/source.html?file=org/h2/engine/Session.java&line=415&build=169> ) at org.h2.server.TcpServerThread.process(TcpServerThread.java:253<http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.java&line=253&build=169> ) at org.h2.server.TcpServerThread.run(TcpServerThread.java:149<http://h2database.com/html/source.html?file=org/h2/server/TcpServerThread.java&line=149&build=169> ) at java.lang.Thread.run(Thread.java:680) at org.h2.engine.SessionRemote.done(SessionRemote.java:567<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=567&build=169> ) at org.h2.command.CommandRemote.prepare(CommandRemote.java:67<http://h2database.com/html/source.html?file=org/h2/command/CommandRemote.java&line=67&build=169> ) at org.h2.command.CommandRemote.<init>(CommandRemote.java:46<http://h2database.com/html/source.html?file=org/h2/command/CommandRemote.java&line=46&build=169> ) at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:439<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=439&build=169> ) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1114<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=1114&build=169> ) at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:164<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=164&build=169> ) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcStatement.java&line=152&build=169> ) at org.h2.server.web.WebApp.getResult(WebApp.java:1311<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1311&build=169> ) at org.h2.server.web.WebApp.query(WebApp.java:1001<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=1001&build=169> ) at org.h2.server.web.WebApp$1.next(WebApp.java:964<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=964&build=169> ) at org.h2.server.web.WebApp$1.next(WebApp.java:953<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=953&build=169> ) at org.h2.server.web.WebThread.process(WebThread.java:166<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=166&build=169> ) at org.h2.server.web.WebThread.run(WebThread.java:93<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=169> ) at java.lang.Thread.run(Thread.java:680) Any thoughts? Thanks. Drew -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
