db connection string
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="C:\Docu ments and Settings\Alexi\My Documents\Delivery\web\App_Data\Database2.mdf" ;;Integrated Security=True;Connect Timeout=30;User Instance=True"
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=188.8.131.52 ;Database=alexeyka_yah_1951com_;UID=support;PWD=te st123;");
Would really appreciate any help, perhaps buy a new book from the programmers in gratitude. :)