Help ! How to run a downloaded asp.net project

Question

1.00/5 (3 votes)

See more:

I am newbie to asp.net .I am trying to run a asp.net program with sql database using visual studio and finding it very difficult to run the script and changing the connection string.Can anyone help!

Here is link from which i downloaded
http://sourceforge.net/projects/lms-dml/[^]

Posted 30-Aug-13 3:13am

Member 9961335

Add a Solution

Comments

[no name] 30-Aug-13 9:16am

"Can anyone help", no. No one can help. You did not ask a question or describe any kind of a problem.

Member 9961335 30-Aug-13 9:26am

problem is that i cannot connect to updated database..
The source provided me an sql script which i ran using sql server management studio which created a database.
now all i need is to connect the update database to the asp.net project..

[no name] 30-Aug-13 9:50am

Okay so why are you unable to connect to the database? Open up the project, and change the connection string.

Dave963 30-Aug-13 9:17am

Post code snippets...

Member 9961335 30-Aug-13 9:28am

Can't get you..i am very new to programming..

Dave963 30-Aug-13 9:31am

post code snippet of the web.config file...

Member 9961335 30-Aug-13 9:44am

Before

<pre lang="xml"><connectionStrings>
<add name="InnovationManagement_ConnString" connectionString="Data Source=(local);Initial Catalog=LMS;User ID=sa;Password=Password1" providerName="System.Data.SqlClient"/>
</connectionStrings></pre>

After i created a database named CSPproject-v2 using server (localdb)\test so i changed the string into

<pre lang="xml"><connectionStrings>
<add name="InnovationManagement_ConnString" connectionString="Data Source=(localdb)\test;Initial Catalog=CSPproject-v2;" providerName="System.Data.SqlClient"/>
</connectionStrings></pre>

Dave963 30-Aug-13 9:46am

Ok all you need to do now is insert a user and password which is your username and password as you log into ssms

Dave963 30-Aug-13 9:47am

Just look at my solution copy and paste the user and password part and change the typeyourusername and typeyourpassword to your username and password, then let me know if it worked... It's suppose to

Member 9961335 30-Aug-13 9:50am

Actually i don't have password and when i hit run i get

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Member 9961335 30-Aug-13 9:51am

I would be great help if u check whether i project is working
http://sourceforge.net/projects/lms-dml/

Dave963 30-Aug-13 10:20am

Is it still not working? In that case try... changing (localdb)\test to (local)

Member 9961335 30-Aug-13 10:37am

no :(

Dave963 30-Aug-13 10:40am

Whats the error

Member 9961335 30-Aug-13 10:44am

Error: 26 – Error Locating Server/Instance

Dave963 30-Aug-13 11:03am

Did you try changing (localdb)\test to (local)

Member 9961335 30-Aug-13 11:03am

yeah

Dave963 30-Aug-13 11:15am

It works fine on my machine buddy, just send me your connectionstring code in your we.config file again plus the server name on your ssms screen and your username

Member 9961335 30-Aug-13 11:28am

ssms:server name :(localdb)\test ,username =WINCTRL-G28QT7G\Ash
<pre lang="xml">
<connectionstrings>
<add name="InnovationManagement_ConnString" connectionstring="Data Source=(localdb)\test;Initial Catalog=CSPproject-v2;" providername="System.Data.SqlClient">
</pre>

Member 9961335 30-Aug-13 11:30am

i am not able to add connection string :/ and i really must thank u for ur efforts so far

Dave963 30-Aug-13 11:43am

Something is wrong in your web.config file's connection because it works fine on my pc, just follow the solution 1 I posted and its suppose to work. Hope you'll figure it out. Happy coding...

Member 9961335 30-Aug-13 11:49am

Can i know what version of sql server u used ? i used sql server express 2012

Member 9961335 30-Aug-13 11:54am

can u post me ur connection string for reference ?

Member 9961335 30-Aug-13 11:47am

add name="InnovationManagement_ConnString"
connectionString="Data Source=(localdb)\test
Initial Catalog=CSPproject-v2
providerName="System.Data.SqlClient"

Dave963 30-Aug-13 11:56am

you have to specify a user id and a password

Member 9961335 30-Aug-13 11:57am

but i dont have one :/

Dave963 30-Aug-13 11:58am

I used 2008

Dave963 30-Aug-13 12:00pm

then just add your user id and the password but as a empty string

Member 9961335 30-Aug-13 11:29am

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave963 · Accepted Answer · 2013-08-30T03:41:00

Usually in the web.config file you will find a section of code like this...

XML

<connectionStrings>
    <add name="ConnString" connectionString="data source = david-pc; initial catalog=database; user=typeyourusername; password=typeyourpassword;"/>
  </connectionStrings>

setp 1)
where it says data source = david-pc
replace david-pc with the server name displayed on your login screen when you log into sql server management studio

step 2)
replace typeyourusername with the login value when you login to sql server management studio

step 3)
replace typeyourpassword with the password value when you login to sql server management studio

step 4)
replace database with the name of the database you created through the script you ran

Dave963 · Accepted Answer · 2013-08-30T03:52:00

Solution 2

Just replace yourusername and yourpassword

XML

<connectionstrings>
    <add name="InnovationManagement_ConnString" connectionstring="Data Source=(localdb)\test;Initial Catalog=CSPproject-v2;User ID=yourusername;Password=yourpassword" providername="System.Data.SqlClient" />
  </connectionstrings>

Posted 30-Aug-13 3:52am

Dave963