General information
Category:
The Mere Mortals .NET Framework
Environment versions
Network:
Windows 2003 Server
>I recently installed the new 6/13/2008 release of MM.NET. I changed the App.config files in both the Business object project and the windows forms project and copied the connection string straight from the properties of the Server Explorer | Data Connection in Visual Studio 2008.
>Whenever I try to run the sample app, I get a SQL client error. From the stack (below) it looks to me that there is a problem somewhere in that I am using a named instance of SQL Server. Please note that "Server" line near the top of the call stack shows two backslashes:
>
> Server="DIS-PMCDERMOTT2\\PMCDDEV"
>
>Here's my connection string from the App.config:
>"Data Source=DIS-PMCDERMOTT2\PMCDDEV;Initial Catalog=Northwind;Integrated Security=True" (Only one backslash)
>
>My suspicion is this is an issue with a missing escape character for C# somewhere that is not liking the backslash in a named instance SQL name.
>
>Anyone have any ideas how to fix this? I'm at a loss. TIA.
>Patrick
Hi Patrick,
I'm no expert, they're probably off today <g>, so in the mean time perhaps this will help:
my connection string entry in both app.config files for integrated security is
value="server=Pluto;Integrated Security=True;database=Northwind;"
Pluto being my server running one instance of MS SQL. I also had to ensure the desired user had permissions of course.
-Larry
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only