Linked Table on Access ODBC limited to 62 Characters

[Josef Hopfgartner]

Has anybody already had this error?
I've tried the mentioned SQL-Statements directly via JDBC:ODBC in SQLworkbench and there both simply worked.

Here ist the error documentation:
(select 7890123456789012345678901234567890123456789 from kisten) -> just works... -> 62 Characters (without braces)
(select 78901234567890123456789012345678901234567890 from kisten) -> 63 Characters is the limit

And here comes the error:
Folgender Fehler trat bei der Ausführung:
CREATE LINKED TABLE M3.TKPALETTEN_KISTEN_CHARGEN('', 'jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\server\db$\Kisten.mdb', '',...

[Microsoft][ODBC Microsoft Access Driver]Ungültige Zeichenfolgen- oder Pufferlänge.; SQL statement:
CREATE LINKED TABLE M3.TKPALETTEN_KISTEN_CHARGEN('', 'jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\\server\db$\Kisten.mdb', '', '', '(select 78901234567890123456789012345678901234567890 from kisten)') [84-164] [SQL State=S1090, DB Errorcode=84]

Ausführungszeit: 3.14s

1 Befehl(e) nicht erfolgreich.

[Thomas Mueller]

Hi,

The exception seems to come from Microsoft Access, so I'm afraid there is nothing we could do within the H2 database to solve this problem. I don't know what SQLworkbench does differently to make it work there.

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/6SEl7_fMYJ8J.
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.