Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# Creating the ODBC Data Source

## Status

If you are... | This task is...
Installing a new iProcess Engine | Optional
Upgrading from any Version 10, or 11 iProcess Engine | N/A

## Database

SQL Server

## Description

TIBCO iProcess Engine uses an ODBC data source to connect to the SQL Server.

The installer can automatically create an ODBC data source for you. However, you can use the following procedure to manually create it before you run `setup.exe`.

If you are installing the iProcess Engine into a Microsoft Windows Cluster, the `mscluster`command automatically creates an ODBC data source with the same name and details on each secondary machine in the cluster.

## Procedure

To manually create an ODBC data source, perform the following steps:

| 1. | Open the ODBC Data Source Administrator dialog box on Windows. Run the following utility:

`\windows\system32\odbcad32.exe`

Note | For detailed configuration information in the SQL/ODBC Details dialog box, see SQL/ODBC Details.

| 2. | Click the Add button under the System DSN tab. The Create New Data Source dialog box appears.

| 3. | Select SQL Native Client as the driver for which you want to set up a data source.

Note | If SQL Native Client is not shown in the list of available drivers, you will need to download it from the Microsoft Download Center at: http://www.microsoft.com/downloads/details.aspx?FamilyId=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&DisplayLang=en

| 4. | Click the Finish button. The Create A New Data Source To SQL Server wizard appears.

| 5. | Specify the information listed in the Create A New Data Source To SQL Server wizard to complete the operation. For detailed information about the Create a New Data Source to SQL Server wizard, see Microsoft documentation.

Note | The layout of this wizard depends on the version of the SQL Server driver installed on the computer. The required information may be on different pages.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine

Copyright © 1994-2024. Cloud Software Group, Inc. All Rights Reserved.