Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

HELP !!!! error 'ASP 0185 : 8002000e'

I have the following sql statement in my code:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Inetpubwwwroototi-poleitai1data
ews.mdb"
PathToDatabase = "C:Inetpubwwwroototi-poleitai1data
ews.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")

erotisi = "SELECT * FROM Article"
Set RS5 = Conn.Execute(erotisi)


The database is not empty and the path is corect, when i try to loop for printing all the data that has been selected the last one did not printed.
I printed the recordcount and it was -1.

Then i tried to print the errors property of the connection object and i got the following message:

Response object error 'ASP 0185 : 8002000e'

Missing Default Property

/oti-poleitai1/update_categories.asp, line 0

A default property was not found for the object.


Did i do anything wrong? Can anybody help me????
Thanx!!!!!

Comments

  • FlakesFlakes Member Posts: 642
    : I have the following sql statement in my code:
    :
    : strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Inetpubwwwroototi-poleitai1data
    ews.mdb"
    : PathToDatabase = "C:Inetpubwwwroototi-poleitai1data
    ews.mdb"
    : Set Conn = Server.CreateObject("ADODB.Connection")
    :
    : erotisi = "SELECT * FROM Article"
    : Set RS5 = Conn.Execute(erotisi)
    :
    :
    : The database is not empty and the path is corect, when i try to loop for printing all the data that has been selected the last one did not printed.
    : I printed the recordcount and it was -1.
    :
    : Then i tried to print the errors property of the connection object and i got the following message:
    :
    : Response object error 'ASP 0185 : 8002000e'
    :
    : Missing Default Property
    :
    : /oti-poleitai1/update_categories.asp, line 0
    :
    : A default property was not found for the object.
    :
    :
    : Did i do anything wrong? Can anybody help me????
    : Thanx!!!!!
    :
    :


    You have to open the connection before using it,Like:
    [code]
    strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Inetpubwwwroototi-poleitai1data
    ews.mdb"
    PathToDatabase = "C:Inetpubwwwroototi-poleitai1data
    ews.mdb"
    Set Conn = Server.CreateObject("ADODB.Connection")
    [red]Conn.Open strConn[/red]
    erotisi = "SELECT * FROM Article"
    Set RS5 = Conn.Execute(erotisi)
    [/code]

    But your error refers to the response object ?Mybe you should show a bit more code ?


Sign In or Register to comment.