Database

Re: Can not connect to my database from asp .net application

5-Jul-14 0:15

I have a named instance of 2008 r2 located on my windows 7 professional local machine. I have tried to get my connect string to work but I just cant. I am using machine name "HOLDORF-PC" SQL instance name "SQL_2008_R2" and the rest of the connection string. Here is my connection string:

"Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel" providerName="System.Data.SqlClient" />

Please help

Steve Holdorf

Eddy Vluggen5-Jul-14 1:23

Eddy Vluggen

5-Jul-14 1:23

The CS does not say whether you want to use mixed mode or windows authentication. There's examples here[^].

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Can not connect to my database from asp .net application

Stephen Holdorf5-Jul-14 2:03

Re: Can not connect to my database from asp .net application

5-Jul-14 2:03

I tried this:

"Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=SSPI" providerName="System.Data.SqlClient"

and it still does not work?

Stephen Holdorf5-Jul-14 2:08

Re: Can not connect to my database from asp .net application

5-Jul-14 2:08

Sorry, I tried this:

"Data Source=HOLDORF-PC\\SQL_2008_R2;Initial Catalog=EFDataModel; Integrated Security=True"

and it still doesn't work. One point is that this is the connection string that coexists with my Entity Framework model.

Stephen Holdorf5-Jul-14 2:26

Re: Can not connect to my database from asp .net application

5-Jul-14 2:26

OK. I think you were right on the DB connection string. Now, I'm getting this error:

An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.

Here is my Entity Framework connection string:

<add name="EFDataModelEntities2" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=HOLDORF-PC\SQL_2008_R2;initial catalog=EFDataModel;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />

And here is my Model connections:

<EntityContainer Name="EFDataModelEntities2" annotation:LazyLoadingEnabled="true">

<EntityContainerMapping StorageEntityContainer="EFDataModelModelStoreContainer" CdmEntityContainer="EFDataModelEntities2">

Eddy Vluggen5-Jul-14 22:46

Eddy Vluggen

5-Jul-14 22:46

I don't use EF; I've no idea what it epects beyond a normal SQL-server connection string. According to MSDN[^] your string looks correct.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Re: Can not connect to my database from asp .net application

Jörgen Andersson6-Jul-14 11:23

Jörgen Andersson

6-Jul-14 11:23

lholdorf wrote:
Check the inner exceptions for details and ensure that the connection string is correct.

This is a good time to post the inner exceptions.

Wrong is evil and must be defeated. - Jeff Ello[^]

Re: Can not connect to my database from asp .net application

Bernhard Hiller6-Jul-14 21:01

Bernhard Hiller

6-Jul-14 21:01

Where does your asp.net application run - on the same machine? If not, configure the SQL Server to accept connections from other machines.
And what about the account the IIS is running with? Does that account have sufficient access rights to the database? I suggest SQL Server authentication instead of WIndows authentication - do not forget to configure your SQL Server to allow that.

Re: Can not connect to my database from asp .net application

Richard Deeming7-Jul-14 3:14

Richard Deeming

7-Jul-14 3:14

lholdorf wrote:
HOLDORF-PC\\SQL_2008_R2

Is the double back-slash between the machine name and the instance name a typo in your question, or a mistake in copying the connection string from a C# source file to the web.config file?

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: Can not connect to my database from asp .net application

Hemant Singh Rautela7-Jul-14 3:31

Hemant Singh Rautela

7-Jul-14 3:31

I think you have to provide user name and password also...!

I used As : Database Connection[^]

Complex SQL queries

data modeling guy3-Jul-14 5:14

3-Jul-14 5:14

Hello- can you give me any example scenarios/questions for writing a complex SELECT statements? My intention is to improve my SQL skills.

Richard MacCutchan3-Jul-14 5:22

Richard MacCutchan

3-Jul-14 5:22

Start at http://www.w3schools.com/sql/[^].

data modeling guy3-Jul-14 20:02

3-Jul-14 20:02

Thanks

PIEBALDconsult3-Jul-14 5:53

PIEBALDconsult

3-Jul-14 5:53

Sure, try implementing a Turing Machine in SQL.

You'll never get very far if all you do is follow instructions.

data modeling guy3-Jul-14 20:03

3-Jul-14 20:03

Thanks

Eddy Vluggen3-Jul-14 11:24

Eddy Vluggen

3-Jul-14 11:24

data modeling guy wrote:

Hello- can you give me any example
scenarios/questions for writing a complex SELECT statements? My intention is to
improve my SQL skills.

Calculate reputation points of a user.
Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
Fetch the ten members from the database that answered most questions last month.
Fetch the voting-percentages for the straw-poll result for all possible answers.
Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]

Mycroft Holmes3-Jul-14 14:20

Mycroft Holmes

3-Jul-14 14:20

No no no these suggestions expect him to do the work and write the queries, it sounds like he wants YOU to write the queries and he will study them.

Good luck getting CM to lend out the database and schema Laugh | :laugh:

Never underestimate the power of human stupidity
RAH

data modeling guy3-Jul-14 20:05

3-Jul-14 20:05

Thanks Eddy. I Did some more google search and found some more. Cheers!