ASP/Access Connections

[d_smiff]

I'm having a bit of trouble connecting to a database i've uploaded. I'ev setup a DSN as 'qzar_stats', and am using the following code to connect:
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = "dsn=qzar_stats;"
Recordset1.Source = "SELECT * FROM Colours"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>
When I view this page - the following error occurs:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' 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.

/test.asp, line 8



Any help would be greatly appreciated!

[Atari]

[Microsoft][ODBC Microsoft Access Driver] '(unknown)' 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

The path to db isn't correct.