Looking for good JDBC ODBC Derivers for MS Access

Greenhorn

Posts: 15

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am using JDBC ODBC Driver which is bundled with Java 1.4 . But some SQL functions are not run on Access like NVL. Instead of NVL Access have Nz function. Through this driver I cant execute that function.
Is there a place that I can see all the functions and all commands (SQL) that I can run on MS Access through JDBC ODBC Driver? There should be a separete function that fills the gap of NVL, but run on MS Access through JDBC ODBC Driver. But I am seeking that function or a documentation.
Regards,
Ranjith
ranjith at dmsswt dot com

Barry Gaunt

Ranch Hand

Posts: 7729

posted 21 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm moving this to JDBC too.Here you go...
[ January 13, 2004: Message edited by: Barry Gaunt ]

Ask a Meaningful Question and HowToAskQuestionsOnJavaRanch
Getting someone to think and try something out is much more useful than just telling them the answer.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.