Question
Configuring SQL
Hi,
I had posted this in general may have been the wrong forum but I need someone to at least tell me something on this even if its impossible to move from one enviroment to another.
Can anyone help me switch an already set up SQL Server Database into DreamWeaver.
DreamWeaver asks these questions for Data configuration
Connection String
Persist Security Info=False;
Data Source=[serverName];
Initial Catalog=[databaseName];
I have this config info from my Visual Studio 2005 Web Developer Web.Config file.
<appSettings/>
<connectionStrings>
<add name="MyDataBaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Documents and Settings\Barbara Hollowell\My Documents\Visual Studio Codename Orcas\Projects\MyDatabase\MyDatabase\MyDataBase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDataBase.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
Please HELP!!!
I had posted this in general may have been the wrong forum but I need someone to at least tell me something on this even if its impossible to move from one enviroment to another.
Can anyone help me switch an already set up SQL Server Database into DreamWeaver.
DreamWeaver asks these questions for Data configuration
Connection String
Persist Security Info=False;
Data Source=[serverName];
Initial Catalog=[databaseName];
I have this config info from my Visual Studio 2005 Web Developer Web.Config file.
<appSettings/>
<connectionStrings>
<add name="MyDataBaseConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="D:\Documents and Settings\Barbara Hollowell\My Documents\Visual Studio Codename Orcas\Projects\MyDatabase\MyDatabase\MyDataBase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDataBase.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
Please HELP!!!
AdChoices