Connection Error

Im using a dsn less connection (my first time, used to using ODBC)

and im getting the following error..

Microsoft JET Database Engine error '80004005'

'C:\WINNT\system32\whathappenedwhen.co.uk\htdocs\Database\photolibary.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/photos2.asp, line 9

Hers is the code..

<!--#include file="Top.asp" -->

<%

Dim Conn, dbPath
  dbPath = "whathappenedwhen.co.uk/htdocs/Database/photolibary.mdb"
  Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE=" & dbPath

Set UserRecordset = Server.CreateObject("ADODB.Recordset")
sqlstring = "select * from Photo where Catergory = 'Florida'"

UserRecordset.Open sqlstring, DatabaseConnection

Set objid = UserRecordset("ID")
set objLargeImage = UserRecordset("LargeImage")
Set objSmallImage = UserRecordSet("SmallImage")

While NOT UserRecordset.EOF

%>

<a href="">1</a><p>
<a href="">2</a><p>
<a href="">3</a><p>
<a href="">4</a>

<%
UserRecordset.MoveNext
wend
%>
<!--#include file="bottom.asp" -->

Any ideas?

thanx for your help that solved the problem, but ive now got this error..

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name too long

/photos2.asp, line 16

<!--#include file="Top.asp" -->

<%

Dim Conn, dbPath
  dbPath = Server.MapPath("/Database/photolibary.mdb")
  Set Conn = Server.CreateObject("ADODB.Connection")
  Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0; DATA SOURCE=" & dbPath

Set UserRecordset = Server.CreateObject("ADODB.Recordset")
sqlstring = "select * from Photo where Catergory = 'Florida'"

UserRecordset.Open sqlstring, dbpath

Set objid = UserRecordset("ID")
set objLargeImage = UserRecordset("LargeImage")
Set objSmallImage = UserRecordSet("SmallImage")

While NOT UserRecordset.EOF

%>

<a href="">1</a><p>
<a href="">2</a><p>
<a href="">3</a><p>
<a href="">4</a>

<%
UserRecordset.MoveNext
wend
%>
<!--#include file="bottom.asp" -->

any ideas?