Hi

 

I have an ASP application on internet server and using sql server 2000
installed at the same machine.

Now i want to get some data from another SQL server 2000 that is owned by an
intranet domain and is behind firewalls.

 

Can any one help me how I get connected with this sql server. Any sample
connection string for such scenario.

 

It will be a great help. Thanks in advance.

 

Aftab

Hi 

 

I have an ASP application on internet server and using sql server 2000
installed at the same machine.

Now i want to get some data from another SQL server 2000 that is owned by an
intranet domain and is behind firewalls. 

 

Can any one help me how I get connected with this sql server. Any sample
connection string for such scenario. 

 

It will be a great help. Thanks in advance.

 

 

Aftab

 

Take a look at this:
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDB
ProviderForSQLServer

-Kim

> -----Original Message-----
> From: Aftab Ahmad [mailto:aftab.ahmad@k...]
> Sent: 15. november 2002 08:31
> To: ASP Databases
> Subject: [asp_databases] Connection string
>
>
> Hi
>
>
>
> I have an ASP application on internet server and using sql server 2000
> installed at the same machine.
>
> Now i want to get some data from another SQL server 2000 that is
> owned by an
> intranet domain and is behind firewalls.
>
>
>
> Can any one help me how I get connected with this sql server. Any sample
> connection string for such scenario.
>
>
>
> It will be a great help. Thanks in advance.
>
>
>
>
>
> Aftab
>
>
>
>
>
>

Try the following

Dim adoDataConn, selectSQL, RecSet 
Set adoDataConn = CreateObject ("ADODB.Connection")
adoDataConn.Open "DSN=Website; User Id = <user id>; Password=<password>"