System DSN

This is a stupid question but I will ask it anyway:

A System DSN is created on my server but the database is not physically located on the server rather I created a SYSTEM DSN to the data source. Will this work for asp pages on my intranet site.



Stevie
IBM Canada

So long as the location in the system DSN is visible from the machine where it's being called from then there shouldn't be a problem, e.g., the DSN is pointing to an IP address for SQL Server on another machine somewhere else on the net.

There's often better ways to connect than using a DSN though ;-)

cheers
Andy