Re: asp recordset

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bob Barrows (reb01501_at_NOyahoo.SPAMcom)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 09:26:34 -0500

Stephen Cairns wrote:
> Its just when I have that part of the code like that: -
> set dbconn = server.CreateObject("ADODB.Connection")
> '<snip of code to open the connection>
> dbconn.Open Application("connectionString")
> set rs = server.CreateObject("ADODB.Recordset")
> rs.CursorLocation=3 'adUseClient
> dbConn.ByClassPUBCLASS lsDate, rs
> Response.Write "<table border=1 width=""100%"">"
>
> I get the the following error message: -]
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
> [Microsoft][ODBC SQL Server Driver]Optional feature not implemented
> /ByClassPUBCLASS.asp, line 98

Why are you using ODBC? Why not use the native OLEDB provider?

dbConn.open "provider=sqloledb;" & _
"data source=yourserver;" & _
"initial catalog=yourdatabase;" & _
"user id=login_name;" & _
"password=xxxxxxx"

Bob Barrows 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: SQL INJECTION - ORACLE
    ... SQL INJECTION - ORACLE: ... > Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ...
    (Pen-Test)
  • SQL INJECTION - ORACLE
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)
  • Re: SQL issue
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... DB provider instead of ODBC. ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: Drivers SQLSetConnectAttr failed
    ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Amish School Recovery Fund
    ... This is what Christianity is really about: ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (misc.rural)