After selecting the table from the list Access resp is: ODBC: Chiamata non riuscita ( Call failed ) Error while executing the query ( #7 )
On 22 Feb, 15:39, Ryan How <[email protected]> wrote: > I've never been able to get it to work. I always have access say unknown > error -4744 or something like that, do you get that also? > > fd wrote: > > When i connect a table from Access i see this error in the trace log > > of H2, > > and the operation fails > > > Error: Table "PG_ATTRDEF" not found; SQL statement: > > > I'm using > > >> h2-1.2.129.jar > >> psqlodbc_08_04_0200.zip > >> Access 2007 > > > thanks > > F.D. > > > Trace details ******************************************* > > > Connect > > Init > > StartupMessage > > version 196608 (3.0) > > param database=mimweb > > param user=MIMWEB > > 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; > > org.h2.jdbc.JdbcSQLException: Table "MSYSCONF" not found; SQL > > statement: > > SELECT Config, nValue FROM MSysConf [42102-129] > > at org.h2.message.DbException.getJdbcSQLException(DbException.java: > > 317) > > at org.h2.message.DbException.get(DbException.java:168) > > at org.h2.message.DbException.get(DbException.java:145) > > at org.h2.command.Parser.readTableOrView(Parser.java:4334) > > at org.h2.command.Parser.readTableFilter(Parser.java:1002) > > at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1530) > > at org.h2.command.Parser.parseSelectSimple(Parser.java:1627) > > at org.h2.command.Parser.parseSelectSub(Parser.java:1524) > > at org.h2.command.Parser.parseSelectUnion(Parser.java:1369) > > at org.h2.command.Parser.parseSelect(Parser.java:1357) > > at org.h2.command.Parser.parsePrepared(Parser.java:396) > > at org.h2.command.Parser.parse(Parser.java:279) > > at org.h2.command.Parser.parse(Parser.java:251) > > at org.h2.command.Parser.prepareCommand(Parser.java:223) > > at org.h2.engine.Session.prepareLocal(Session.java:422) > > at org.h2.engine.Session.prepareCommand(Session.java:383) > > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java: > > 1071) > > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:163) > > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151) > > at org.h2.server.pg.PgServerThread.process(PgServerThread.java:340) > > at org.h2.server.pg.PgServerThread.run(PgServerThread.java:76) > > at java.lang.Thread.run(Thread.java:619) > > 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'TMIMAMB' and u.nspname = E'MIMWEB'; > > 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, d.adsrc, case t.typtype when 'd' then t.typbasetype > > else 0 end, t.typtypmod from (((pg_catalog.pg_class c inner join > > pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like > > E'TMIMAMB' and n.nspname like E'MIMWEB') 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; > > org.h2.jdbc.JdbcSQLException: Column "T.TYPTYPMOD" not found; SQL > > statement: > > 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, d.adsrc, case t.typtype when 'd' then t.typbasetype > > else 0 end, t.typtypmod from (((pg_catalog.pg_class c inner join > > pg_catalog.pg_namespace n on n.oid = c.relnamespace and c.relname like > > E'TMIMAMB' and n.nspname like E'MIMWEB') 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 [42122-129] > > at org.h2.message.DbException.getJdbcSQLException(DbException.java: > > 317) > > at org.h2.message.DbException.get(DbException.java:168) > > at org.h2.message.DbException.get(DbException.java:145) > > at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java: > > 126) > > at org.h2.command.dml.Select.prepare(Select.java:714) > > at org.h2.command.Parser.prepareCommand(Parser.java:224) > > at org.h2.engine.Session.prepareLocal(Session.java:422) > > at org.h2.engine.Session.prepareCommand(Session.java:383) > > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java: > > 1071) > > at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:163) > > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151) > > at org.h2.server.pg.PgServerThread.process(PgServerThread.java:340) > > at org.h2.server.pg.PgServerThread.run(PgServerThread.java:76) > > at java.lang.Thread.run(Thread.java:619) > > ^CException in thread "Thread-16" java.lang.AbstractMethodError: > > it.ubi.mimweb.h2.AutoInc.close()V > > at org.h2.schema.TriggerObject.close(TriggerObject.java:373) > > at org.h2.engine.Database.close(Database.java:1031) > > at org.h2.engine.DatabaseCloser.run(DatabaseCloser.java:80) -- 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.
