XP SP2 IE ADO Problem

[Bhaskar Prasad Thamma]

Hi

I am writing a HTML file ,using Vbscript i am accessing Excel sheet 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!!!

[Mark L. Ferguson]

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" > wrote in message
...
> Hi
>
> I am writing a HTML file ,using Vbscript i am accessing Excel sheet 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!!!
>
>