|
|
|
|
|
| | |
| |
Active Server Pages ASP programs help tutorial tutorials routine routines jobs listserve mailinglist bulletin board bulletin boards programming snippet snippets CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
ODBC Error |
|
From: |
Paul Debenedittis |
|
Date: |
3/7/1999 12:03:14 PM |
|
IP: |
209.131.171.31 |
I received this error when trying to read information from a database.
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.
The code used is
SQL="SELECT Table.* FROM Table ORDER BY Table.num"
Set ConnObj = Server.CreateObject("ADODB.Connection")
ConnObj.Open "databasename"
Set objCommand=Server.CreateObject("ADODB.Command")
Set objRS = Server.CreateObject("ADODB.Recordset")
objCommand.CommandText=SQL
objCommand.CommandType=adCmdText
Set objCommand.ActiveConnection=ConnObj
objRS.Open objCommand,,adOpenKeySet
I have received this many times and ususally I just go copy code from another page and change variables and get it to work. But I never have discovered what the error message is telling me and what I should be looking for. The line referrenced in the error message is always that last line of code above. Any information would be greatly appreciated such as: when that happens look for "this" or the parameter that the error message refers to are the _____parameters. Or just direction to a site that would tell me this stuff.
I am using Using Active Server Pages as my reference.
Thanks in advance.
Paul
|
Follow Up - Re: ODBC Error - Pete 3/8/1999 5:50:19 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
