VBScript and named instance

microsoft.public.sqlserver.programming

9 Sep 2005 12:31 PM

Silmar

Hi!

How to connect using VBScript to named instance of SQL server?
I used following
SQL.Open "Provider=SQLOLEDB;Integrated Security=SSPI;Data
Source=server_name;Initial Catalog=db_name"
to connect to default DB instance but in what format should be server_name
to connect to named one? I

Regards
Silmar

9 Sep 2005 12:48 PM

Jens Süßmeyer

SQL.Open "Provider=SQLOLEDB;Integrated Security=SSPI;Data
Source=server_name\InstanceName;Initial Catalog=db_name"

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Show quote

"Silmar" <sil***@talex.pl> wrote in message
news:ew6q3pTtFHA.2792@tk2msftngp13.phx.gbl...
> Hi!
>
> How to connect using VBScript to named instance of SQL server?
> I used following
> SQL.Open "Provider=SQLOLEDB;Integrated Security=SSPI;Data
> Source=server_name;Initial Catalog=db_name"
> to connect to default DB instance but in what format should be server_name
> to connect to named one? I
>
> Regards
> Silmar
>
>