'ADODB.Connection' cannot be created

**joopdog** · Jul 13th, 2005, 02:25 PM

For the life of me, I cannot get this code run.

Here's my code

Code:

<%@ LANGUAGE="VBScript" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%
'http://support.alentus.com/databases_conn_odbc.asp?Node=R&sNode=6&Exp=Y
dim cs ' Connect string
dim db ' Database object
dim rs ' Recordset object

    cs = "DSN=prodlgo; UID=Sharon; PWD=sms999;"

    db = Server.CreateObject("ADODB.Connection")
    db.Open (cs)

    'rs = db.Execute(" & chr(34) & "SELECT * FROM employee" & chr(34) & ")" & vbcrlf & vbcrlf
    rs = db.Execute("SELECT * FROM employee")
    if (rs.EOF = True) or (rs.BOF = True) then
        Response.Write ("No records were found!")
    else
        rs.MoveFirst
        while (rs.EOF = False)
        'access table colums here in this manner
            Response.Write (rs("ee_emp_name"))
            Response.Write ("<BR>")
            rs.MoveNext
        End While

        Response.Write ("No more data!")
    end if

    db.Close

%>

<html>
  <head>
    <title>WebForm5</title>
  </head>
  <body MS_POSITIONING="GridLayout">

    <form id="Form1" method="post" runat="server">

    </form>

  </body>
</html>

I keep getting this error:

Code:

The component 'ADODB.Connection' cannot be created. Apartment threaded components can only be created on pages with an <%@ Page aspcompat=true %> page directive. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Web.HttpException: The component 'ADODB.Connection' cannot be created. Apartment threaded components can only be created on pages with an <%@ Page aspcompat=true %> page directive.

Source Error: 

Line 11:     cs = "DSN=prodlgo; UID=Sharon; PWD=sms999;"
Line 12: 
Line 13:     db = Server.CreateObject("ADODB.Connection")
Line 14:     db.Open (cs)
Line 15:

I'd like to use this code, however I keep getting the above error. What is <%@ Page aspcompat=true %>? Can I use this code for my version of VB.NET STD 2003?

Any help would be appreciated
Thanks

**veryjonny** · Jul 14th, 2005, 01:30 PM

Recordsets no longer exists. Now with ADO.NET you have to use Datasets.

Since you want to use something which is in ASP and not in ASP.NET, the frmaekwork needs to be TOLD that you are using some ASP code and so the Page directive, <%@ Page aspcompat=true %> - Implying that the page needs to be compatible with ASP and ASP.NEt as well.

**joopdog** · Jul 14th, 2005, 03:15 PM

Thanks John (veryjonny)

**mendhak** · Jul 15th, 2005, 01:20 AM

In case you wanted that to work, you'd have to set the aspcompat attribute in your page directive, and make sure that ADO's DLLs are present on the machine and registered.

Although ADO.NET is what you should be using

**Anjari** · Jul 15th, 2005, 01:39 AM

I hope you didnt post the actual Username and Passwords

you plan to use...

Anjari

Thread: 'ADODB.Connection' cannot be created

Thread Tools

Display

'ADODB.Connection' cannot be created

Re: 'ADODB.Connection' cannot be created

Re: 'ADODB.Connection' cannot be created

Re: 'ADODB.Connection' cannot be created

Re: 'ADODB.Connection' cannot be created

Posting Permissions