5.5 Creating a data source
To link to JP1/IT Desktop Management 2 - Manager, you must create a data source in order to connect to the database used in JP1/IT Desktop Management 2 - Manager. You must also re-create the data source if you have changed Login ID or Service name in the Server Setup dialog box after creating the asset management database.
Before creating the data source, you must use the Asset Console's Server Setup dialog box to specify the settings required during creation of the data source. For details about the settings in the Server Setup dialog box, see 5.3 Setting up the asset management server.
- Notes on using a 64-bit OS
-
When installing Asset Console in a 64-bit OS, use the following method to set up the database connection:
From the Windows Start menu, select Run. Specify %windir%\syswow64\odbcad32.exe and execute it.
Notes
-
Before you start creating a data source, stop all Asset Console services, commands, and tasks in the following order:
-
World Wide Web Publishing Service or World Wide Web Publishing
-
Asset Console commands, and tasks
To run Asset Console after having created a data source, start the services in the reverse of the order in which they were stopped.
-
-
If a connection pool is set in an ODBC data source, the connected state will continue after an Asset Console job is stopped until the timeout time set in the connection pool expires. Therefore, wait for the connected state to be released before creating a data source.
To connect to the asset management database and a linked product's database:
-
Click the Start button and select Programs, JP1_IT Desktop Management 2 - Asset Console, and then Setup.
The Setup dialog box appears.
-
Click the Create Data Source icon.
The Create Data Source dialog box appears.
-
From Products for connection, select the name of the database product to be connected and then click the Next button.
A dialog box for creating a data source appears.
-
Enter the required items and then click the OK button.
Details about the settings during data source creation are provided in section 5.5.1.
The data source is created and the asset management database and linked product's database can now be connected.
- Organization of this section