Download Versata Logic Suite Library

SETTING UP AN ODBC SYSTEM DATA SOURCE NAME (DSN)
Setting up an ODBC System Data Source Name
(DSN)
The DSN stores information about how to connect to your database from another source. It
allows you to connect the database to Versata Logic Studio, and hence deploy your repository
data model. Whenever you deploy your data model to the database, Versata Logic Studio will
ask you for this DSN. A user data source is visible only to you and can be used only on the
current machine. A system data source is visible to all users on the machine, including
Windows NT services.
You will need to set up a DSN for the Versata Logic Studio, Versata Logic Studio applications,
or the Versata Logic Server to use for connection to the database server. You may want to set
up a DSN with a meaningful name, for example SampDSN to connect to the sample database.
To create the system DSN:
1.
Choose Start à Settings à Control Panel.
2.
Double-click the ODBC Data Sources icon.
3.
In the ODBC Data Source Administrator, click the System DSN tab.
4.
Click the Add button.
5.
In the Create New Data Source dialog, choose the SQL Server driver and click Finish.
6.
In the Create a New Data Source to SQL Server dialog, do the following:
n
Enter a name for the data source, for example, OrdersDB_dsn. Make a note of this
name because Versata will prompt you for it whenever you deploy to the database.
n
Optionally enter a description for the DSN.
n
In the Server drop-down list, choose (local), or
If you want the DSN to connect to a SQL Server on another machine, choose the
machine from the Server drop-down list.
Note: If the Create New Data Source dialog does not list a supported driver for your database
server, you may need to install a new driver. For information about supported drivers,
see the Getting Started Guide.
30
7.
Click Next.
8.
In the next dialog, for the prompt, “How should Windows verify the authenticity of the
login?”, select the radio button labelled “With Windows NT authentication using the
network ID”.
9.
Click Next.
10.
In the next dialog, set the default database to the one you created earlier for the Versata
data model.
11.
Accept the defaults for the remaining prompts, and click Next.