A trappable error (C0000006) occurred in an external object.

Discussion in 'ASP General' started by Hocke, Dec 15, 2004.

  1. Hocke

    Hocke Guest

    I got these error when I try to open an excel file on a Windows 2003 server,
    It works perfect on XP, 2000 and on my Windows 2003 server (test server) but
    not on my online Windows 2003 server. I have tried "on error resume next" but
    I got the same error!

    Any suggestions?

    Here is the code:
    Code (Text):

    adSearchForward = 1
    count = 0
    Set rs= server.CreateObject("Adodb.Recordset")
    Set conn2 = server.CreateObject("ADODB.Connection")
    connstr= "Provider=MSDASQL.1;Persist Security Info=False;Extended
    Properties=""DBQ=" & server.MapPath(MapPath) & ";Driver={Microsoft Excel
    Driver (*.xls)};DriverId=790;FIL=excel
    8.0;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=5;ReadOnly=1;SafeTransactions=0;Threads=3;UID=admin;UserCommitSync=Yes;"";User Id=admin;"

    conn2.Open connstr
    rs.Open "SELECT email FROM emailrange", conn2, adOpenStatic,
    adLockReadOnly, adCmdText
    Hocke, Dec 15, 2004
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.