|
| |
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
and13345
Posts: 100
Joined: 10/7/2003
Status: offline
 |
[Microsoft][ODBC Microsoft Access Driver] Too few param... - 10/12/2004 18:27:25
I have a page that looks at a DB file and gathers some data from a MDB that is in on the website. This MDB is periodically changed with a new file that has updated information. I have an upload page that copies the file from my PC to the webserver, replacing the existing file. I then have a page that looks at this file and compares it to my primary DB and adds or updates from the uploaded DB to the primary DB based on the existence of the record in the primary DB. If it exists it updates, if it doesn't it Inserts the record. This was all working fine and I decide to upload the file again just to be sure. Now I get an error when it tries to load the page.
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/internal/oem_support_priorities/hp/fpdb/update_from_import_file.asp, line 34
The following is the code from the update_from_import_file.asp file. The last line is line 34. Again, I did not change this code, just the DB file.
Set MyImportConnection = Server.CreateObject("ADODB.Connection")
MyImportConnection.Open "current_issues_import"
MyImportQuery = "Select * from current_issues_import ORDER BY Observation_ID ASC"
Set MyImportRS = MyImportConnection.Execute(MyImportQuery)
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 