| Author |
Cant use NVL of Nz functions on MSAccess through JDBC ODBC
|
Ranjith Kodikara
Greenhorn
Joined: Sep 03, 2002
Posts: 15
|
|
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
|
 |
Barry Gaunt
Ranch Hand
Joined: Aug 03, 2002
Posts: 7729
|
|
I just used Google to search for "access function nz odbc" and it came up with a few possibilities. One of them (from a M$ developer) said "if Nz is a VBA function, then you cannot uses it through ODBC". So that could be the reason for Tomcat's error message.
Don't take my word for it though, I'm just telling you what Google turned up 
Try writing a simple standalone test program with whatever JDBC-ODBC bridge you are using.
|
Ask a Meaningful Question and HowToAskQuestionsOnJavaRanch
Getting someone to think and try something out is much more useful than just telling them the answer.
|
|
Ranjith Kodikara
Greenhorn
Joined: Sep 03, 2002
Posts: 15
|
|
Dear friends,
I want to use NVL function of SQL with my query. HOw can I use that function with access through JDBC ODBC driver. NVL returns a specified value if the column value is null. There should be a function to use for this purpose. But I dont know that. If you know it pls write me.
Thanks and best regards,
Ranjith
|
|
 |
|
|
subject: Cant use NVL of Nz functions on MSAccess through JDBC ODBC
|
|
|
0
