quote:Originally posted by bekim
I heard about MSDE, what is this and how will this help the situation?
Microsoft SQL Server 2000 Desktop Engine.
I tried "Data Source=(local);Initial Catalog=myDatabaseName;User ID=myUsername;Password=myPassword"
and it is suppose to work but it doesn't.
There is no UI for MSDE so how do I restore the database file?
I haven't been able to get the connection string resolved yet either. I did use sql 2k, so I was able to restore the database. My connection string in web.config looks like this:
sqlConnectionString="data source=(local);Initial Catalog=ThePhile;user Id=sa;password=Timebox7"
port 1039 because that's what sql2k uses instead of 1433
also there are other connection strings under the config directory. Several files in there have connection strings. Mine look like this:
I was able to open the studio solution file. I am using vs.net 2003 enterprise architect. It asked if I wanted to convert the solution to the new vs.net format. (hope that is helpful to you bekim)
I am completely at a loss for my connection string problem. the error that I am getting is:
An unexpected error has occurred on this page.The system administrators have been notified.
The error occurred in:
SQL Server does not exist or access denied.
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction)
at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter parameters, Int32& rowsAffected) in C:\wrox\ThePhileVB\WebModules\Core\DBObject.vb
:lin e 53
at Wrox.WebModules.Polls.Data.Questions.GetCurrentId( ) in C:\wrox\ThePhileVB\WebModules\Polls\Polls.Data\Que stions.vb
at Wrox.WebModules.Polls.Business.Question.GetCurrent Id() in C:\wrox\ThePhileVB\WebModules\Polls\Polls.Business \Question.vb
at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataB ind() in C:\wrox\ThePhileVB\WebModules\Polls\Poll.ascx.vb
:l ine 260
at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_ Load(Object sender, EventArgs e) in C:\wrox\ThePhileVB\WebModules\Polls\Poll.ascx.vb
:l ine 62
at System.Web.UI.Control.OnLoad(EventArgs e)
I can telnet to localhost 1039. I reset my sa password. I've logged into query analyzer using the credentials in my connection string. What else can I do?
thanks for any help you can offer! I really like this framework if I can get it to work. I am comming from a fusebox (www.fusebox.org
) framework/methodology, which is a lot like this, so if I can get this working I will be one happy man.