hi, I'm kind of new to this. Trying to learn asp.net 2.0. Have been designing a website, and, so far so good, I can deploy the files, but I can't get the synthax right for the connection string. in my web.config file the connection string works on the local computer, but I can't figure out how to change the data source part:

  <add name="Database2ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=&quot;C:\Docu ments and Settings\Alexi\My Documents\Delivery\web\App_Data\Database2.mdf&quot ;;Integrated Security=True;Connect Timeout=30;User Instance=True"
   providerName="System.Data.SqlClient" />

the the wrox book says I have to have the|datadirectory|
does it mean I have to write the full http address on the server?
and I can't figure out what to substitute in for the ".\sqlexpress" part...

my host has ms sql server 2000 and my sql. I asked for their support and the gave me a weird looking connection string and claimed that it worked...

<%@ LANGUAGE = JScript %>
<% var oConn;
oConn = Server.CreateObject("ADODB.Connection");
oConn.Mode = 3
oConn.Open("Provider=SQLOLEDB;Server=203.89.181.78 ;Database=alexeyka_yah_1951com_;UID=support;PWD=te st123;");
%>


Would really appreciate any help, perhaps buy a new book from the programmers in gratitude. :)

that's cool. guys at ASP.NET really helped me out. recommend to everyone.
http://forums.asp.net/1383130/ShowThread.aspx#1383130