HOW SHOULD I CONNECT TO A DATABASE RESIDING ON ANOTHER SERVER THAN MY ASP FILE.
From what I've seen, it's not possible. Security issues and all that good stuff.
I alwasy have a diff IIS and a different Db server. Please tell me why it is not possible??
Create a DSN which points to the Db on the different server. then call that DSN on your ASP page.
I was assuming that he wanted to use a database on someone else's machine. Of course you can do it if you know the database name.