Solved

Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) error message

Posted on 2006-07-21
3
569 Views
Last Modified: 2011-09-20
I am trying to implement the following code...

<%
'Dimension variables
Dim adoCon          'Holds the Database Connection Object
Dim rsRegistrant    'Holds the recordset for the records in the database
Dim strSQL           'Holds the SQL query for the database
Dim count
Dim pstring

'Create an ADO connection object
Set adoCon = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using DSN connection
adoCon.Open "DSN=wnyacccTRD"

'Create an ADO recordset object
Set rsRegistrant= Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT * FROM Contacts order by organization"

'Open the recordset with the SQL query
rsRegistrant.Open strSQL, adoCon
%>

and I get the following output.

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/cdc/wnyaccc_trd/registrationAdmin.asp, line 22

line 22 is:
rsRegistrant.Open strSQL, adoCon

I have implemented the above code many times before without any problem and I have no idea why it isn't working now. Any feedback will be appreciated. Thanks!
0
Comment
Question by:aumandg
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
DireOrbAnt earned 500 total points
ID: 17157979
Make sure you have a column named organization in the table Contacts
0
 

Author Comment

by:aumandg
ID: 17158004
bless you kind sir.
0
 
LVL 26

Expert Comment

by:DireOrbAnt
ID: 17158059
:)
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question