Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: error message


Message #1 by "Dai" <david@d...> on Fri, 14 Mar 2003 19:03:27
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/p40167/holiday_review/search.asp, line 43


I'm getting the above error message:
this is line 42 and 43
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open Sql, dbConn
  

any ideas what is wrong and how to fix it.

Message #2 by "Alan" <g_alan_c@p...> on Mon, 17 Mar 2003 04:21:15
Hi,

can you send your code, I'll try to help


> Error Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80040E10)
[> Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
/> p40167/holiday_review/search.asp, line 43

> 
I> 'm getting the above error message:
t> his is line 42 and 43
S> et objRS = Server.CreateObject("ADODB.Recordset")
o> bjRS.Open Sql, dbConn
 >  

> any ideas what is wrong and how to fix it.

Message #3 by "Rodney Majola" <MajolaR@a...> on Mon, 17 Mar 2003 16:58:34 +0200
Don't u wanna try something like this:

objRS.Open Sql, dbConn, 0, 1



-----Original Message-----
From: Dai [mailto:david@d...]
Sent: Friday, March 14, 2003 9:03 PM
To: Access ASP
Subject: [access_asp] error message

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected
2.
/p40167/holiday_review/search.asp, line 43


I'm getting the above error message:
this is line 42 and 43
Set objRS =3D Server.CreateObject("ADODB.Recordset")
objRS.Open Sql, dbConn
 

any ideas what is wrong and how to fix it.


  Return to Index