Hello,

I just purchased the ASP.NET 2.0 instantResults book. I'm trying to run the Appointment Booking System. When I run it, I can log in fine, but then when I try and go to "Conference Rooms", I get the error message below. Once last thing... I'm not running any instance of SQL server, I'm just running SQL server without the SQLExporess instance. I think the app is hard coding the connection string somewhere... Any help would be appreciated.

PS: I change my connection string to look like the following in my Web.Config file:

 <add name="AppointmentBooking" connectionString="server=BRIAN-LPS;AttachDbFileName=|DataDirectory|aspnetdb.mdf;I ntegrated Security=true;User Instance=true" />


Thanks,

Brian.


A user instance was requested in the connection string but the server specified does not support this option.
Changed database context to 'master'.
Changed language setting to us_english.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: A user instance was requested in the connection string but the server specified does not support this option.
Changed database context to 'master'.
Changed language setting to us_english.

Source Error:


Line 37: Catch ex As Exception
Line 38: ' Pass up the error; it will be caught by the code in the Global.asax and the generic error page set up in web.config.
Line 39: Throw
Line 40: End Try
Line 41: End Function


Source File: C:\Documents and Settings\Brian Eskra\my documents\visual studio 2005\WebSites\Book2\App_Code\DataAccess\BookingObj ectManagerDB.vb Line: 39

Hi Brian,

The connection string is not hard coded in the application; the only place where you'll find the connection string is in the web.config (and in the AppConfiguration.vb file in the App_Code folder as a fall back mechanism in case the original connection string is missing).

I am not sure I understand what version of SQL Server you are using: What does this mean? Are you using a normal version of SQL Server (e.g. Standard or Enterprise?) If so, you cannot use the User Instance setting, nor the AttachDbFileName. You'll need a normal connection string.

If you let me know what SQL Server you are using, I can help you further.

BTW, if I were you, I'd install SQL Express as well. It makes local development (and following along with the book) much easier.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004

I got the same error as following:
A user instance was requested in the connection string but the server specified does not support this option.
Changed database context to 'master'.
Changed language setting to us_english.

On my computer, I don't have SQL Server Express version because I installed the SQL Server 2005 (SQL Server 8.0.194)
Please help me how to fix connection string in web.config using Windows Authentication in the following code.

<connectionStrings>
    <add name="SqlServerConnectionString" connectionString="server=AVT2K6;AttachDbFileName=| DataDirectory|PhotoDB.mdf;Integrated Security=true;User Instance=true"
      providerName="System.Data.SqlClient" />
    <add name="ConnectionStringComments" connectionString="Data Source=localhost;AttachDbFilename=|DataDirectory|\ PhotoDB.mdf;Integrated Security=True;User Instance=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

Thanks.

Hi there,

As the error message suggest you are trying to use user instances (User Instance=true) which is not supported on the version of SQL Server you are using.

For connection strings for SQL 2005, take a look here:
http://www.connectionstrings.com/?carrier=sqlserver2005

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.