Limitation of File DSN

[M P]

Is there any limitation on how many file dsn can I use per IIS Server?

 

[Ray at]

Other than the limitation imposed by your disk space, no. Why do you ask?
Instead of a file dsn, how about just using a connection string in a common
include?

Ray at home

 

[Aaron Bertrand [MVP]]

Yes! There is a limitation for client tools on the number of characters
occupied by all DSN names.
http://support.microsoft.com/?kbid=252475

Also, file DSN is easily the least performant choice of database connection
methodology. Please read http://www.aspfaq.com/2126