Hi Harry,

Sorry for my late response. I was on vacation for the past few weeks.

Anyway, if you still have the problem, can you give us a little more information? E.g. how is your server installation called, how does your connection string look like and so on?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: I Remember Nothing by Joy Division (Track 12 from the album: Heart And Soul (CD 1)) What's This?

Imar,

I hope you had a good vaction.

Thanks for getting back. Yes I am still have the problem. I am not sure what you are asking for by "how is your server installation called". I trying to use the Soccor Team example in the book, it will not even open because of the above error. I am using sample code rather than my writing the code. My thought was that I may have something wrong so I went right to theirs. That being said, the connection is exactly by their code, I did not change any thing. Again I appreciate you help with this, I really need to understand the problem. It may happen on some of my future apps since I am using the examples from the book. If you need more specifics let me know.

Harry

Harry Standley

Hi Harry,

Vacation was great; thank you.

I don't have the book, so I can only guess.... That's why I asked how your connection string looked like.

With Server Installation, I meant the name of the SQL Server Instance. By default, the Express Edition is installed as a named instance called \SqlExpress. So, you can access it with .\SqlExpress or (local)\SqlExpress.

However, when you do a custom installation, or install one of the commercial versions of SQL Server, you can change that name.

You need to specify the correct name in the connection string, or you won't be able to access your server....

Cheers,

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

Sorry, I made an assumption that you were familiar with the book. from reading the earlier posts I went back and installed sqlexpress so that is what I am using.

My connection is below:

  <connectionStrings>
    <add name="WroxUnited"
     connectionString=
        "Data Source=.\SQLEXPRESS;
        AttachDbFilename=|DataDirectory|WroxUnited.mdf;
        Integrated Security=True"
     providerName="System.Data.SqlClient" />
  </connectionStrings>

This is my error:
The user instance login flag is not supported on this version of SQL Server. The connection will be closed.

Harry Standley

This is odd; the error you get should come from a full version of SQL Server, when a Express specific attribute is used.

However, in your case, you are using Express, and even without the Express specific attribute.

Are you sure this is all the code? Could there be other code in the web.config file, or another config file altogether causing this error?

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

Imar,

I do have full sql as well. On some forums you can not attach. If possible I will zip up the full code and send it, if you have time. Being new I do not know where to look.

Harry

Indeed, you can't attach file here. But, you can send me a message through my Profile page (click my name). Then I'll reply and you know my e-mail address.

But, "having" sql server is not the same as using it; You can have them installed with Express side by side, but it's the connection string to the database that makes the difference...

Cheers,

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

Hi Harry,

I received your files and got the same problem. The fix is easy though: just add User Instance=true back in the connection string. I think you removed it earlier when you were using a full version of SQL Server (on which this setting causes another error) but you need it in the Express Edition. This worked for me:

<add name="WroxUnited" connectionString="server=.\SQLEXPRESS;AttachDbFile name=|DataDirectory|WroxUnited.mdf;
      Integrated Security=True;User Instance=true"
  providerName="System.Data.SqlClient"
/>

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
While typing this post, I was listening to: The Drawback (RCA Unreleased Album Session - Arrow Studios, Manchester, May 1978) by Joy Division (Track 5 from the album: Heart And Soul (CD 3 - Studio Rarities & Unreleased)) What's This?

OK I did get a connection but then:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)





Harry Standley

Try a Google search for the error message. There are a number of reasons and fixes for it. However, only you can determine whether they apply to your situation...

http://blogs.advantaje.com/blog/kevi...?page=comments

http://forums.microsoft.com/msdn/sho...98346&siteid=1

Cheers,

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