error '80004005' of access connection

Discussion in 'Classic ASP' started by stan, Feb 13, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. I meet the problem of 80004005

    codes as below:
    *****************
    Set conn = Server.CreateObject("ADODB.Connection")

    connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=x:\web\username\htdocs\_database\databasename.mdb"

    Conn.Open connStr
    set rs=server.createobject("adodb.recordset")
    sql="select * fromtablename where field1="&yy&" order by field_name"

    rs.open sql,conn,1,1
    ***********************
    at the last line, I meet the problem error '80004005

    What's the error? I didnt have this problem before I move the web to discountasp.net
    Anybody can help me?
     
  2. anyone here?
    if I use the following code, it meets another error, damn...simple problem but waste me too much time on it.

    ***************************
    db="_database/dbname.mdb"
    Set conn = Server.CreateObject("ADODB.Connection")
    connstr="driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath(db)
    conn.Open connstr
    set rs=server.createobject("adodb.recordset")
    sql="select * from catalog where [type]="&trade&" order by catalog_name"

    rs.open sql,conn,1,1
    ************************************
    At the last line, there is another error:

    Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
    ODBC driver does not support the requested properties.
    /left.asp, line 68

    Any tech support here?????????????? It was fine before I move here.
     
  3. I found the problem is your hosting server operation system doesnt support multilanguage. Please read this link to make some change otherwise I can't use your hosting service.
    http://support.microsoft.com/default.aspx?kbid=184988
    Then it cause the 80004005 error. When I change my database to English General Database Sort Order and export an new MDB file. Porblem fixed. But still have other similar problems because some records in database are Chinses because we have Chinese customers.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page