Re: XP SP2 IE ADO Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Mark L. Ferguson (marfer_mvpREMOVE_at_hotmail.com)
Date: 12/08/04 

Date: Wed, 8 Dec 2004 07:32:44 -0600

To disable the SP2 warning for running activeX on a local computer page, go
to : IE, Tools menu, Options, Advanced Tab, -- scroll down to the Security
area, check the box for, "Allow active content to run in files on My
Computer" 

-- 
Mark L. Ferguson (NOT an MS-MVP)
marfers notes for windows xp 
http://www.geocities.com/marfer_mvp/chatNotes.htm
.
"Bhaskar Prasad Thamma" <tbprasad@vermar.com> wrote in message 
news:eRSWWd72EHA.2804@TK2MSFTNGP15.phx.gbl...
> Hi
>
> I am writing a HTML file ,using Vbscript i am accessing  Excel *** data
> and Dbase file data using ADO and displaying them in HTML Table format.
>
> It worked fine on windows 2000 Pro with  a warning message saying "This
> program is using a Data source accross domains". so, I enabled this 
> feature
> in IE properties -->Security->Access Data source accross Domain  to 
> ENABLED.
>
> Then It works fine in Windows 2000 Pro.
>
>
> I am not able to run the same file in Windows XP sp2.
>
> The problem running the file in XP sp2 OS.
>
> 1. Warning messages:"ADO security warning: This website is using your
> identity to access a datasource. If you trust this website click ok to
> continue otherwise cancel". And after this the application hangs.
> 2. Error message: "Unexpected error from External Datbase Driver 15877".
>
> Sample Code
> -----------
>
> sub window_onload()
>
> Set cn = CreateObject("adodb.connection")
> set rsExcel = CreateObject("adodb.Recordset")
> Dim Filstr
> FilStr="v:\gold\template\Goals.xls"
>
> ConStr ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Filstr 
> &";Extended
> Properties='Excel 8.0;HDR=Yes;IMEX=1'"
>
>
> cn.Open ConStr
> cn.CursorLocation=3
>
> sqlq="Select * from [Sheet2$]"
> rsExcel.Open sqlq,cn,2,3
> --------------------------------------
>
>
> Please help!!!
>
>
Quantcast