Configuring SQL

[Stardust-1]

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=&quot;D:\Documents and Settings\Barbara Hollowell\My Documents\Visual Studio Codename Orcas\Projects\MyDatabase\MyDatabase\MyDataBase.mdf&quot;;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!!!

[Newsgroup_User]

my mssql connection string (in the connection folder) for my local
testing server looks like this

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_cbsgcs_STRING
MM_cbsgcs_STRING = "Driver={SQL
Server};Server=cbsg;Database=MSSQL_DB_138870;Uid=Primdb;Pwd=labor$Spent;
"
%>

so your might look like

= "Driver={SQL
Server};Server=youServerNameHere;Database=MSSQL_DB_138870;Uid=TheDataBas
eJere;Pwd=ThePasswordHere;"

where you would copy paste

Driver={SQL
Server};Server=youServerNameHere;Database=MSSQL_DB_138870;Uid=TheDataBas
eJere;Pwd=ThePasswordHere

to the custom connection string dialog

[Newsgroup_User]

Based on what you've supplied below, my best guess is
Persist Security Info=False;
Data Source=.\SQLEXPRESS;
Initial Catalog=MyDataBase;
Integrated Security=SSPI;
Trusted Connection=True


"Stardust-1" <webforumsuser@macromedia.com> wrote in message
news:f7ej85$34o$1@forums.macromedia.com...
> <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>

[Newsgroup_User]

Also, www.connectionstrings.com has more information.

"Stardust-1" <webforumsuser@macromedia.com> wrote in message
news:f7ej85$34o$1@forums.macromedia.com...
> Can anyone help me switch an already set up SQL Server Database into
> DreamWeaver.