Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2006-07-21
3
Medium Priority
?
591 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 26

Accepted Solution

by:
DireOrbAnt earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
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…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

721 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