Author |
Topic  |
|
Civ
Starting Member
1 Posts |
Posted - 10 May 2001 : 18:43:31
|
This is the error I get when I try to run this select statement.
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
and this is the statement I'm using
strSQL2 = "SELECT * FROM MailUsers "_ & " WHERE LastName = '" & strLastName & "' AND "_ & " FirstName = '" & strFirstName & "' AND "_ & " Email = '" & strEmail & "'"_ & " ORDER BY LastName, FirstName "
objRS2.Open strSQL2,objCN2,1,1,1
|
|
Aznknight
Senior Member
   
USA
1373 Posts |
Posted - 10 May 2001 : 18:49:40
|
try it without the 1, 1, 1 at the end of the open statement
objRS2.Open strSQL2, objCN2
- Alan www.iamviet.com www.calvsa.net Snitz Resource |
 |
|
Doug G
Support Moderator
    
USA
6493 Posts |
Posted - 10 May 2001 : 19:50:32
|
I don't remember seeing the 5th argument in older ado recordset documentation. From what I read about IIS5 and asp, you can safely leave off the last argument with the worst thing happening is some loss of performance, or as Alan suggested try opening with only the required arguments.
====== Doug G ====== |
 |
|
|
Topic  |
|