| Author: Mohan Kumar 28 Sep 2006 | Member Level: Diamond | Rating:  Points: 2 |
hi,
DSN (DATA Source Name)
A Data Source Name (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the drive and other information that is required to access data. The name is used by Internet Information Services (IIS) for a connection to an ODBC data source, such as a Microsoft SQL Server database. To set this name, use the ODBC tool in Control Panel.
When you use an ODBC DSN entry to externally store the connection string values, simplify the information that is needed in the connection string. When you do this, changes are made to the data source that are completely transparent to the code. This article describes how to create a system data source name in Windows XP.
Create a System DSN in Windows XP
1. Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources(ODBC).
2. Click the System DSN tab, and then click Add.
3. Click the database driver that corresponds with the database type to which you are connecting, and then click Finish.
4. Type the data source name. Make sure that you choose a name that you can remember. You will need to use this name later.
5. Click Select.
6. Click the correct database, and then click OK.
7. Click OK, and then click OK.
-Mohan kumar
|
| Author: Gaurav Sharma 28 Sep 2006 | Member Level: Diamond | Rating: Points: 2 |
hi Check this article
http://www.c-sharpcorner.com/database/Connect/ConnectODBCText.asp
thanks
|
| Author: Gaurav Sharma 28 Sep 2006 | Member Level: Diamond | Rating: Points: 2 |
hi Check this article
http://www.c-sharpcorner.com/database/Connect/ConnectODBCText.asp
thanks
|
| Author: Dharmi 28 Sep 2006 | Member Level: Gold | Rating: Points: 2 |
Hello
Please go through this
http://uda.openlinksw.com/?doc=/FAQ/WhatAreTheDifferencesAmongUserSystemAndFileDSNs
http://whatis.techtarget.com/definition/0,,sid9_gci874018,00.html
http://www.databasejournal.com/features/mssql/article.php/1477421
Hope this helps
|
| Author: Dharmi 28 Sep 2006 | Member Level: Gold | Rating: Points: 2 |
DSN is an acronym for Data Source Name. It's a simple and standard way to describe how to connect to a data source using an ODBC driver. More importantly, using a DSN means you can change the location of your data by updating the DSN, no update to your application required. Keep in mind that DSN's only describe ODBC connections, not OLEDB connections.
There are three types of DSN's; system, user, and file. System and user DSN's are registry based, while File DSN's are stored in the file system. You normally create and administer DSN's through the ODBC Data Source Administrator, found in Control Panel on NT/9x machines, or in Administrative Tools for Win2K machines.
|
| Author: sangeetha hariraman 28 Sep 2006 | Member Level: Gold | Rating: Points: 2 |
A dsn stands for Data source Name.
A Dsn defines the source of a database or better to say the place you put your
access db and also the Name of your database.
When you download an ASP script that works with an access db from internet,
For example in my scripts there is a file called conn.asp that you should edit in order to specify the dsn.
The code structure looks like this:
set objConn=server.createobject("Adodb.connection")
objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\DBName.mdb") & ";"
objConn.open
'If you wish to use DSN then comment out the driver above and uncomment the line below
'objConn.open "dsn=DBNAME"
If you are running IIS on a localhost you don't need to create a dsn you should just place the db in the root directory
of your server.
in this example the db is placed here c:/inetpub/wwwroot/Your DB
Note this part of the code " Server.MapPath("\DBName.mdb") "
The symbol "\" says that the db should be in the root directory.
If you are running the codes on your server on the internet follow the instructions below.
You should refer to the control panel of your site and there should be a section called "ODBC DSN" and specify the DSN name and the database PATH.
|
| Author: sangeetha hariraman 28 Sep 2006 | Member Level: Gold | Rating: Points: 2 |
A dsn stands for Data source Name.
A Dsn defines the source of a database or better to say the place you put your
access db and also the Name of your database.
When you download an ASP script that works with an access db from internet,
For example in my scripts there is a file called conn.asp that you should edit in order to specify the dsn.
The code structure looks like this:
set objConn=server.createobject("Adodb.connection")
objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\DBName.mdb") & ";"
objConn.open
'If you wish to use DSN then comment out the driver above and uncomment the line below
'objConn.open "dsn=DBNAME"
If you are running IIS on a localhost you don't need to create a dsn you should just place the db in the root directory
of your server.
in this example the db is placed here c:/inetpub/wwwroot/Your DB
Note this part of the code " Server.MapPath("\DBName.mdb") "
The symbol "\" says that the db should be in the root directory.
If you are running the codes on your server on the internet follow the instructions below.
You should refer to the control panel of your site and there should be a section called "ODBC DSN" and specify the DSN name and the database PATH.
|
| Author: sangeetha hariraman 28 Sep 2006 | Member Level: Gold | Rating: Points: 2 |
A dsn stands for Data source Name.
A Dsn defines the source of a database or better to say the place you put your
access db and also the Name of your database.
When you download an ASP script that works with an access db from internet,
For example in my scripts there is a file called conn.asp that you should edit in order to specify the dsn.
The code structure looks like this:
set objConn=server.createobject("Adodb.connection")
objConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\DBName.mdb") & ";"
objConn.open
'If you wish to use DSN then comment out the driver above and uncomment the line below
'objConn.open "dsn=DBNAME"
If you are running IIS on a localhost you don't need to create a dsn you should just place the db in the root directory
of your server.
in this example the db is placed here c:/inetpub/wwwroot/Your DB
Note this part of the code " Server.MapPath("\DBName.mdb") "
The symbol "\" says that the db should be in the root directory.
If you are running the codes on your server on the internet follow the instructions below.
You should refer to the control panel of your site and there should be a section called "ODBC DSN" and specify the DSN name and the database PATH.
|