tuzojazz Posted August 7, 2006 Share Posted August 7, 2006 Hi:I'm programming an aspx in visual basic.net code in notepad.From my aspx I'm trying to make a query to a database that is in access but I get aSystem.Data.OleDb.OleDbException saying Nz function is not defined.The query is something like thisSELECT Nz(SUM(Total),0)FROM CargoDWHERE Folio=4224When I try the query in access it works but from my aspx not.What could be wrong?What can I do?Thanks! Link to comment Share on other sites More sharing options...
Reg Edit Posted August 9, 2006 Share Posted August 9, 2006 Not all Access SQL can be used via OLEDB. For a discussion of alternatives to NZ, see for instance www.aspfaq.com/show.asp?id=2394. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now