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:
    adOpenStatic=3
    adLockReadOnly=1
    adCmdText=1
    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
    1. Advertising

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.

Share This Page