Connecting to SQL Server from ASP.NET

[Chip]

Hi,

Hi I have SQL Server Instances running on same machine.
How do i connect to the "SecondInstance" of SQL Server on
a machine from ASP.NET?

Thanks for the Help

Chip

[Manohar Kamath [MVP]]

Where you specify the server in your connection string, mention a
ServerName\InstanceName.

E.g.

ConnectString = "Server=MyServer\SecondInstance;Database=MyDB;UID; PWD="


--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Chip" <anonymous@discussions.microsoft.com> wrote in message
news:39cf01c3fe17$acdea080$a401280a@phx.gbl...

> Hi,
>
> Hi I have SQL Server Instances running on same machine.
> How do i connect to the "SecondInstance" of SQL Server on
> a machine from ASP.NET?
>
> Thanks for the Help
>
> Chip

[Bullschmidt]

microsoft.public.dotnet.framework.aspnet

SitePoint .NET Forum
[url]http://www.sitepointforums.com/forumdisplay.php?s=&daysprune=1000&forumi[/url]
d=141

ASP Messageboard - ASP.NET Forum
[url]http://www.aspmessageboard.com/forum/aspplus.asp[/url]

Extreme .NET Forums - .NET - ASP.NET
[url]http://www.dotnetforums.net/f62[/url]

Microsoft ASP.net
[url]http://www.asp.net[/url]
A Microsoft site.

Best regards,
J. Paul Schmidt, Freelance ASP Web Developer
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!