Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 What's wrong with this statement?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Civ
Starting Member

1 Posts

Posted - 10 May 2001 :  18:43:31  Show Profile
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  Show Profile  Send Aznknight an AOL message  Send Aznknight an ICQ Message
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
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 10 May 2001 :  19:50:32  Show Profile
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
======
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 6.92 seconds. Powered By: Snitz Forums 2000 Version 3.4.07