Single DSN or Multiple DSN RRS feed

  • Question

  • Hi,

    I am using SQL2005. I have multiple DBs for different projects. All projects are accessed via a common web application(ASP). To connect with the application and databases I used ODBC system DSN.

    Could someone please advise whether I should use single ODBC DSN or different (different for different database) for better performance? Also please let me know the reason/logic or some link for the details.



    Wednesday, July 4, 2012 5:02 PM


  • Hello,

    Personally, I wouldn't use either of those methods. I would use the integrated .net sql server packages and save each connection string in encrypted form in the config file for the web app. This way you don't have exposed connection information, connections can be made or deleted throught he web app which limits access needed to the server (devs shouldn't have access to the server imho), and if the app needs installed at another location or migrated the clunky odbc interface doesn't have to be used (not to mention customized connection strings).


    Sean Gallardy, MCC | Blog

    • Marked as answer by Maggie Luo Wednesday, July 18, 2012 2:43 PM
    Wednesday, July 4, 2012 7:04 PM