aspose file tools
The moose likes JDBC and the fly likes Looking for good JDBC ODBC Derivers for MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Looking for good JDBC ODBC Derivers for MS Access" Watch "Looking for good JDBC ODBC Derivers for MS Access" New topic
Author

Looking for good JDBC ODBC Derivers for MS Access

Ranjith Kodikara
Greenhorn

Joined: Sep 03, 2002
Posts: 15
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
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Looking for good JDBC ODBC Derivers for MS Access
 
Similar Threads
JDBC supported SQL functions
Server stops automatically with EXCEPTION_ACCESS_VIOLATION
Looking for good JDBC ODBC Derivers for MS Access
Cant use NVL of Nz functions on MSAccess through JDBC ODBC
JDBC Connection to MS Access DB without ODBC