472,353 Members | 1,197 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Asp Error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)

16
Please assist in this error i have provided the source code.

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Expand|Select|Wrap|Line Numbers
  1. <%
  2. Set objconn = Server.CreateObject("ADODB.Connection")
  3. objconn.ConnectionString = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath('mypath")
  4. objconn.Open
  5.  
  6. %>
  7. <%
  8. Dim qryDisplayRiskRef__MMColParam
  9. qryDisplayRiskRef__MMColParam = "1"
  10. If (Request.QueryString("RiskRef") <> "") Then 
  11.   qryDisplayRiskRef__MMColParam = Request.QueryString("RiskRef")
  12. End If
  13. %>
  14. <%
  15. Dim qryDisplayRiskRef
  16. Dim qryDisplayRiskRef_numRows
  17.  
  18. Set qryDisplayRiskRef = Server.CreateObject("ADODB.Recordset")
  19. qryDisplayRiskRef.ActiveConnection = objconn
  20. qryDisplayRiskRef.Source = "SELECT * FROM QueryDisplayFields WHERE RiskRef = '" + Replace(qryDisplayRiskRef__MMColParam, "'", "''") + "'"
  21. qryDisplayRiskRef.CursorType = 0
  22. qryDisplayRiskRef.CursorLocation = 2
  23. qryDisplayRiskRef.LockType = 1
  24. qryDisplayRiskRef.Open()
  25.  
  26. qryDisplayRiskRef_numRows = 0
  27. %>
Jul 3 '07 #1
0 2557

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: David Lozzi | last post by:
This happens a lot to my databases. I store them at the root of my developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly, the security...
6
by: Miranda | last post by:
Hello, could somebody please help me figure this error out. I'm at my wits end here. This is my connection & SQL statement: ...
6
by: Oli | last post by:
Hi, Im trying to use a sesson statement within an SQL Statement: sql = "SELECT * FROM tblNumbers WHERE AllocatedTo=" & Session("Company") & ""...
15
by: M P | last post by:
What does this mean? I am accessing an ASP page that queries Access Database thru fileDSN. I'm using IIS 5.0 Win2K SP4 Microsoft OLE DB...
2
by: Maurizio Amoroso | last post by:
.... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:...
5
by: jrefactors | last post by:
My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle are in the same box. I have tried both Oracle OLEDB Provider and Microsoft ODBC For...
2
by: pericpero | last post by:
Hi There seem to be a number of posts already with this error message but none of them have helped me ... I am trying to execute some dynamic...
2
by: emvy681 | last post by:
I have a problem on programming, i am not that good but i can read and implement some programs. I just wanna ask help on this code Error Type:...
3
by: kokilatejas | last post by:
Executed as user: SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from dist_up.dbf to dbo.dist_up Step DTSRun...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
0
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...
0
Oralloy
by: Oralloy | last post by:
Hello Folks, I am trying to hook up a CPU which I designed using SystemC to I/O pins on an FPGA. My problem (spelled failure) is with the...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.