Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cant use NVL of Nz functions on MSAccess through JDBC ODBC

843854Jan 12 2004 — edited Jan 13 2004
Dear friends,

I am connectiong to a MS Access database throgh JDBC ODBC bridge and I am running my JSP on Tomcat 4.

This is the query :
SELECT Nz(FIRST_NAME,'')+' '+ Nz(MIDDLE_INITIALS,'')+' '+ Nz(LAST_NAME,'')
AS full_name
FROM PASSENGER_DETAILS

This query runs on MS Access ok without a problem. But Tomcat's console gives this error message and it doesnt work.
SQLException: [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Nz' in expression.

I would be grateful If you can help.

Thanks and regards,
Ranjith
ranjith at dmsswt dot com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2004
Added on Jan 12 2004
#java-database-connectivity-jdbc
3 comments
448 views