what is DSN and ASP SChema option while creating sqlserver database?
tahir_niazi said 1 year, 4 months ago:
what is DSN and ASP SChema option while creating sqlserver database?
timb said 1 year, 4 months ago:
@tahir_niazi
The purpose of the Windows file DSN (data source name) is to centrally store your database connection information. If you have many web pages that require database access, this feature enables you to simply reference the path of the file DSN instead of having to provide the database connection details on every page.
To take full advantage of ASP.NET’s architecture and performance capabilities, you should install the ASP.NET database schema. The .NET Framework defines a set of elements that implement configuration settings, and the ASP.NET configuration schema contains elements that control how ASP.NET Web applications behave.
Tim B
igomzie said 1 year ago:
Which one should I choose, DSN or ASP Schema Option ?
I want to use web.config file for getting my MSSQL connection details.
timb said 1 year ago:
@igomzie
In this case you would want to select ASP Schema. Let us know if you run into any other questions.
Tim B
dhruv02 said 11 months, 2 weeks ago:
Hi I read the above conversation and wanted to ask if I have a class file where I have database connection string and all the web pages access that class file then will it save my statements?
timb said 11 months, 1 week ago:
@dhruv02
Yes, if you are going to have multiple pages access the file and create multiple database connections, I would suggest enabling MARS to reduce the number of connections that need to be made:
What is MARS and how do I use it?
Tim B
7 min expected wait time