Last post Mar 15, 2012 02:13 AM by Decker Dong - MSFT
Mar 13, 2012 05:48 AM|Rudy91|LINK
Dim conn As SqlConnection = New SqlConnection( _
Line 19: ConfigurationManager.ConnectionStrings("connectionstring").ConnectionString)
Line 20: conn.Open() Line 21: Dim SelectCommand As SqlCommand = New SqlCommand( _
Line 22: " insert into discussion (Creator, Discussion, Topic, Date) values (@Creator, @Discussion, @Topic, @Date)", conn)
can somebody help me, what actually the problem is?
Mar 13, 2012 06:01 AM|aspnet2sams|LINK
Is the SQL server client tools installed? if so, please try opening a connection with Query analyzer.
I mean, App_Data access could be code error but the connection to SQL is what not troubling to get access.
Let us know about your try.
Mar 13, 2012 06:05 AM|Sandeep Shenoy|LINK
there may be a database with the same name in the backup folder of microsoft server ...check it...
Mar 13, 2012 06:43 AM|Rudy91|LINK
how do i check it? please provide me a step, cause I am kind of new user here...
Please provide me a step, how to check whether I have a backup folder of the microsof server or not...
Mar 13, 2012 07:03 AM|aspnet2sams|LINK
please provide me a step,
Click on Start Menu->Navigate to MS SQL Server on the Srat menu->Locate Query analyser->A dialog box of query analyzer opens with Sql server instance name By clicking this dialog box if you get connected to query analyser it will show the list of databases
on top in a dropdown list.
alternatively, following the steps do not get opend query analyzer then, probably the installation of SQL server client tools is not done. Sorry for that. hence first need to have a sql server (any version) installed. But installation of any component need
to have a consent with Administrator.
please ask your administrator for troubleshooting to make your SQL server installation available to work with.
Mar 15, 2012 02:13 AM|decker dong - msft|LINK
An attempt to attach an auto-named database for file C:\Users\user\Documents\YEAR 3\DOUBLE MODULE\FinalProject\App_Data\Database1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
It's clear that I suspect whether you have the same db hung up in your Server——So plz remove that and then restart your app after building it and have a try with that。