How To Connect To A Remote Sql DB

Hi all,

myDB is located atX:Program FilesMicrosoft SQL ServerMSSQLDatamyDB.mdf
and my code is located at : C:Inetpubwwwrootapplicationfolder
how do I code my server.mapPath?

 

Btw, can I get VS 2005 to detect the server path when using server solution.Thanks



sub Page_Load
dim dbconn,sql,dbcomm,dbread
dbconn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("X:Program FilesMicrosoft SQL ServerMSSQLDatamyDB.mdf"))
dbconn.Open()
sql = "SELECT * FROM myTable"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
myDB.DataSource = dbread
myDB.DataBind()
dbread.Close()
dbconn.Close()
end sub