locked
w7+iis+mdb -> error date format RRS feed

  • Question

  • help!

     

    os - w7 6.1 7601 sp1 v.721

    iis - 7.5 7600 16385

    code at ASP classic:

     

    code1:

    --skip--

     

    accessdb = "C:\db.mdb" 

    sql = "select * from aaa;" 

    cn = "DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & accessdb

    set rs = server.createobject("ADODB.Recordset")

    --skip--

     

    <%=rs(0).name%>/<%=rs(0).type%>

    <%=rs(1).name%>/<%=rs(1).type%>

    <%=rs(2).name%>/<%=rs(2).type%>

    --skip--

     

    answer1:

    id/3
    ssupdate/135
    bbb/3


    no error...

     

    code2:

    --skip--


    <%=rs(0).name%>/<%=rs(0)%>

    <%=rs(1).name%>/<%=rs(1)%>

    <%=rs(2).name%>/<%=rs(2)%>

    --skip--


     

     

    answer2:

    id/3
    ssupdate/

    Îáúåêò Response ошибка 'ASP 0101 : 80004005'

    Íåïðåäâèäåííàÿ îøèáêà

    /test.asp, line 0

    Ôóíêöèÿ âåðíóëà |.

     

    when reading the values ​​of data type date / time  - error ...

    insert and update all types of data, including date / time is nominally...

    cn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & accessdb 

    changes only data type in the answer 135 to 7 ... mistake that the same ...

    type mdb tried everything - 97\2000 ... 2010...

    as soon as the need to return the values ​​of data type Date / Time ASP 0101 : 80004005

    tried everything

    The same script on other machines working fine ...

    it does not work on my machine ...

    help ...

    ---

    moo

     

     

     

    Thursday, March 17, 2011 6:34 PM