I am having similar problem as you.
Although I used to have mine work. I can't get it to work.
The way I did it before was to go to Windows Explorer and look for Inetpub(I believe). Below is is
and there I created a directory of my asp files.
Then I went to my command line and typed hostname,
got the hostname of my pc and pinged that to get the ip/address.
Finally, I opened up a browser, say internet explorer, without connecting to the internet, I typed say:
ip/address of my hostname)/directoryname/asp file.
So it will be
Since the dsn I created is an alias my database and since that information is on my asp file, I will be connected to the database.
For some reason, since my windows2000 was reinstalled, I am unable to connect to the database anymore.
If you resolve this, please advise me at:
chidiokeh@yahoo.com
thanks,
zik