How to create DSN in Window XP?

Asked By peterrsulliva 10 points N/A Posted on - 07/29/2011

Hi,

How to create DSN in Window XP?  Please tell me its complete detail.

Regards,

Peterrsulliva  

• Status: Open
• Question Views: 2010
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Windows XP

Best Answer by James20

Go To Solution

Best Answer

Best Answer

Answered By James20 5 points N/A #95737

How to create DSN in Window XP?

Procedure to create DSN (Data Source Name):

1) Open the control panel and click the Administrative Tools

Now click Data Sources (ODBC).

2) Select System DSN, if there are no DSN created then it will be empty and will not display any DSN.

After selecting System DSN, now click Add to add new DSN.

3) After clicking Add, it will display the list of drivers.

Select the Microsoft Access Driver as shown in figure below and click Finish button.

4) Now click Select button to add a Microsoft database file.

5) Select database file from the required directory and click OK button.

6) Now you have to give the name of the DSN as in the figure below and click OK button.

7) The following figure shows the name of DSN along with driver name.

Now you can use this DSN in your Java program.

About James20

Questions
0

Answers
104

Best Answers
69

• Vote Up 0 Vote Down

• Posted on - 07/29/2011
• Question Category: Windows XP

Answered By shikdar_hasan 0 points N/A #95738

How to create DSN in Window XP?

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.

Step by Steps are given below:

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.

About shikdar_hasan

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/31/2011
• Question Category: Windows XP