I do recall that there was a problem with using spaces before/after ';' characters in Connection Strings in an earlier (2.1?) version of MDAC. Could that be it?
Simon -----Original Message----- From: Martin Naughton [mailto:[EMAIL PROTECTED]] Sent: 18 December 2002 12:27 To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] SqlConnection and named SQL Server 2000 instance I have used the following format successfully (watch for word wrap - should all be on one line): "initial catalog=MyDbName;data source=MyServerName\MyNamedInstance;uid=MyUid;pwd=Mypassword;" My example is from VB.NET, so the escaped backslash is not required. >SqlConnection conn = new SqlConnection("user id=jedi;password=yoda;initial >catalog=pubs; data source=hoth\\projectx;"); Following my format, try: "initial catalog=pubs;data source=hoth\\projectx;uid=jedi;pwd=yoda;" Cheers, Martin You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the Advanced DOTNET archive, unsubscribe from Advanced DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
