>What I was trying to do is run the asp code on the server. I do not know what the path is on the server. I just wanted it to use the local directory.
>

In ASP code you may use Server.MapPath() to get the path to tables.
Anyway you have to define full path to your tables in connection string, because
if you just use '...;SourceDB=\;...' ODBC driver looks for files in WinNT\System32 folder.