I'm trying to open an SqlConnection to a named instance of sql server 2000. I've tried several variations of the connection string at the end of my post, all to no avail.
Can someone please post an example of opening such a connection to a named instance of sql server?
SqlConnection conn = new SqlConnection("Initial Catalog=trslive;Data Source=MyServer\\MyInstanceName;user id=stew;password=beer");
I need a speedy soloution so am awarding 200 pts. Please note that I MUST open the connection in the manner shown above as I'm working with a core framework that I cannot change..... and also I MUST connect to a NAMED instance.... grr....