ADO security settings

[mark erickson]

Hi,

I am getting an ADO recordset in client-side
script as follows:

*******************
dim oconn
dim rs

set oconn= createobject("adodb.connection")
oconn.open "provider=sqloledb; data source=localhost; initial catalog=northwind;
user id=sa; password="

set rs= createobject("adodb.recordset")
rs.activeconnection=oconn
rs.open "select top 1 * from categories"
*******************

It works fine, but I'm always presented with this message
in a window titled "Microsoft ADO/RDS":

"This page is accessing a data source on another domain.
Do you want to allow this?"

The datasource is actually SQL server on the client's
machine.

Which security settings do I need to set so that this
message no longer is presented to the user?

Thanks, Mark

[Sergey]

In IE go to Tools->Internet Options->Security Tab
Select a zone
Scroll dow to Miscelaneous and Enable Access data source across domains.

Sergey.

"mark erickson" <mark@cjotech.com> wrote in message
news:3a5ca277$1@news.devx.com...
>
> Hi,
>
> I am getting an ADO recordset in client-side
> script as follows:
>
> *******************
> dim oconn
> dim rs
>
> set oconn= createobject("adodb.connection")
> oconn.open "provider=sqloledb; data source=localhost; initial
catalog=northwind;
> user id=sa; password="
>
> set rs= createobject("adodb.recordset")
> rs.activeconnection=oconn
> rs.open "select top 1 * from categories"
> *******************
>
> It works fine, but I'm always presented with this message
> in a window titled "Microsoft ADO/RDS":
>
> "This page is accessing a data source on another domain.
> Do you want to allow this?"
>
> The datasource is actually SQL server on the client's
> machine.
>
> Which security settings do I need to set so that this
> message no longer is presented to the user?
>
> Thanks, Mark
>

[mark erickson]

Thanks Surgey, that did the trick!



"Sergey" <skats@sequoianet.com> wrote:
>In IE go to Tools->Internet Options->Security Tab
>Select a zone
>Scroll dow to Miscelaneous and Enable Access data source across domains.
>
>Sergey.
>
>"mark erickson" <mark@cjotech.com> wrote in message
>news:3a5ca277$1@news.devx.com...
>>
>> Hi,
>>
>> I am getting an ADO recordset in client-side
>> script as follows:
>>
>> *******************
>> dim oconn
>> dim rs
>>
>> set oconn= createobject("adodb.connection")
>> oconn.open "provider=sqloledb; data source=localhost; initial
>catalog=northwind;
>> user id=sa; password="
>>
>> set rs= createobject("adodb.recordset")
>> rs.activeconnection=oconn
>> rs.open "select top 1 * from categories"
>> *******************
>>
>> It works fine, but I'm always presented with this message
>> in a window titled "Microsoft ADO/RDS":
>>
>> "This page is accessing a data source on another domain.
>> Do you want to allow this?"
>>
>> The datasource is actually SQL server on the client's
>> machine.
>>
>> Which security settings do I need to set so that this
>> message no longer is presented to the user?
>>
>> Thanks, Mark
>>
>
>