When you upload your database to server to give path to establish the 

connection do you just give the url path and database name or is there a 

command like Java has GetBaseUrl. 



Data Source=" ??????"  What goes next.

> When you upload your database to server to give path to establish the 

> connection do you just give the url path and database name or is there a 

> command like Java has GetBaseUrl. 

> 

> Data Source=" ??????"  What goes next.

> 

Set MyConn=Server.CreateObject("ADODB.Connection")

Set RS=Server.CreateObject("ADODB.RecordSet")

MyConn.Open "Provider=SQLOLEDB;Data Source=SQLSERVER;User 

Id=;Password=;Initial Catalog="





or



Set Myconn = Server.CreateObject("ADODB.Connection")

Myconn.Open MusicDSN

> > When you upload your database to server to give path to establish the 

> > connection do you just give the url path and database name or is there 

a 

> > command like Java has GetBaseUrl. 

> > 

> > Data Source=" ??????"  What goes next.

> > 

> Set MyConn=Server.CreateObject("ADODB.Connection")

> Set RS=Server.CreateObject("ADODB.RecordSet")

> MyConn.Open "Provider=SQLOLEDB;Data Source=SQLSERVER;User 

> Id=;Password=;Initial Catalog="

> 

> 

> or

> 

> Set Myconn = Server.CreateObject("ADODB.Connection")

> Myconn.Open MusicDSN





Sorry I wasn't clear on my message. My bad. I am loading to comcast at 

home server on web space that is provided for customers. I was having 

trouble figuring out how to map the database; what path I should give it.

I got another response on a different forum that I could use a call like 

this

Dim myfilename myfilename = Server.MapPath ("mydatabase.mdb")



This would map it to my root on the server and it would be able to find 

the database. I appreciate your help. If this is not accurate let me know.