Creating a Data Source Name (DSN) in Windows

When you are creating a database table fingerprint or setting up database discovery, you are prompted for DSN name. This is an ODBC term that refers to the name of the database to which you're connecting. If you have not already done so, you can create a DSN for your data source as follows:

1.	Go to the crawler machine that you're using for fingerprinting tasks.

2.	Access the system's ODBC Data Source Administrator.

Windows 2008:

a.	If you'll be scanning a Microsoft SQL Server database, select Start > Administrative Tools > Data Sources (ODBC).

b.	If you'll be scanning other databases, navigate to C:\Windows\SysWOW64\ and run the executable file, odbcad32.exe. Data Security requires a 32-bit driver for all databases except SQL Server, and the Windows 2008 default is 64-bit.

Windows 2003:

a. Select Start > Programs > Administrative Tools.

b. Double-click the ODBC Data Sources icon.

3.	Select the type of DSN to create.

a.	If you will be scanning only Microsoft SQL Server data on Windows 2008 machines, click the User DSN tab and click Add.

User DSNs are the most common type of DSN. They store information about how to connect to a specific data source. They may be used only by the current user on the current machine. To use a User DSN, you must be logged in as the Websense DSS Administrative User on the server running the relevant crawler.

b.	If you'll be scanning other databases, select the System DSN tab and click Add.

Like the User DSN, the System DSN stores information about how to connect to a specific data source, but is available to all users on a particular machine, including NT services. It is local to a computer, rather than dedicated to a user. The system, or any user having privileges, can use a data source set up with a system DSN.

Data Security does not support File DSNs.

4.	From the Create New Data Source dialog box, select the driver for which you want to set up a DSN.

5.	When prompted, enter a data source name and description. Depending on the driver you selected, you can enter more information. For Excel, select a workbook and enter the number of rows to scan. For Access, select the database and the page timeout.

6.	Click Advanced or Options as needed to provide details on the database records you want to fingerprint, then click OK.