System DSN connection

[micksterbooty]

Hello I think this is probably a simple question but im having trouble connecting to by database when it on line. On my personal computer everything works fine I had a system DSN set up called boards:

Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "boards"

now Ive got a site and they said create a directory to put the database in I called it "database"
They said my system DSN name is mick

So now I have a connection looking like:
Set OBJdbConn = Server.CreateObject("ADODB.Connection")
OBJdbConn.Open "mick"

I get the following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I'm sure I need another line of code somewhere linking to the database directory or something check tutorials and cant find the answers and the hosts arent getting back to me. If anyone can help much appreciated.

I am a newbie I guess thats pretty obivious

cheers mick

try changing your last line

OBJdbConn.Open "mick"

to this...

OBJdbConn.Open "database\mick"

specify the "path" ..