Gday to all. Can anyone help with the following?

I have been trying to creata a connection string and have had a few probles. I have uploaded my database to the ISP and now trying to create a DSN-Less connection string.

I belevie that to do this I must reate a MapPath to find out where my database sits.

The code I created was this.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath ("Database" & "db1.mdb;User Id=admin;Password="

The responce I received was this.

Could not find the file \\samba\clientweb\t\i\tamseek.com.au\\www\_mmServerScripts\Databasedb1.mdb'.

Can anyone suggest what I have done wrong or what I have missed.

Thanks.

Mal.

Try
"PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("/myFolderName/myDatabase.mdb"
www.codefixer.com/tutorials/connection_strings.asp

Live the life you love
Love the life you live
~ ~ ~ ~ ~ ~ ~
<b>Simon Martin</b> - <i>DMXzone Manager</i>
<font size=1>[ Dreamweaver MX/MX2004 | ASP | SQL | XHTML/CSS | Web Accessibility ] </font id=size1>