[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression
I am having a problem with some of my code. I have a site where you enter your zipcode and it would give you all the drop-off locations with your area. If you enter a zip code that is not in the Cincinnati area it lets you know that it is not a valid zip code. When you enter the zipcode...45219 (which is a good zipcode) it gives me the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression
The odd thing about this is if you hit the back button and then the forward button on the wb browser it works correctly. Odd
Here is the code that it is referring too in the error message:
Here is the active website so that you can see what I am talking about when you hit the back button and then the forward button. You can use 45219 as the zipcode.
I am guessing that no one knows where to start with this one. Do you think that it could have been an update with the IIS server that is conflicting with this? I had this running smoothly for several months before it messed up. I am trying to see what changes are IT department has done in the last few months. I didn't know if anyone else has run into this problems while updating.
i don't get the error when i try it. it just works. though u do hve a javascript error on that page... trying to call isValidate() function that doesn't exist...
i don't get the error when i try it. it just works. though u do hve a javascript error on that page... trying to call isValidate() function that doesn't exist...
What browser version are you using? I have tried this on several different computers on different internet connections and still to not get it to work. It still comes up with the error code. Plus, I found out that some times I could not use the back button to even view it correctly. Thanks for looking into this for me. I am completely stumped on this one.
I am running the exact samething. Where is it located under the tools - internet options menu. I couldn't find one that said enable/disable javascript.
yeah I found it. It is enabled. I don't know what the problem is. I change the way the webpage connects to the db hoping that would do something and I received a new error with the same line.
Old connection:
dim Databasestring : Databasestring="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("\_private\sw\recyclefinder.mdb")
dim Conn : set Conn = server.CreateObject("ADODB.Connection")
Conn.open Databasestring
New connection:
Dim Conn, dbPath
dbPath = Server.Mappath("\_private\sw\recyclefinder.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath
NEW ERROR:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/sw(new)/recyclefinder/recyclefinderresults3.asp, line 120
I am going to include the entire code for the error page hopefully you will be able to see what the problem is. I still can't believe that it is working on your machine. If anyone else is reading this thread if you could take a look at the page and let me know if it works for you. Again, the web address is:
I am guessing that no one has an answer for this problem? I have included a .zip file with the .asp files and database file.
Could this be a server update problem? Like I said in a previous post... this was working great for months and now it is not. I have run out of ideas and things to try.
Last edited by tagriffith; 09-27-2006 at 10:19 AM.
Reply With Quote
Bookmarks