Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQL connection in sample app
Message
From
23/06/2008 08:29:13
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
22/06/2008 21:12:37
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 3.0
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01326050
Message ID:
01326082
Views:
16
Hi Larry,

Did you get the same error Patrick was getting until you changed your connection string?
Tim

>>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
Timothy Bryan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform