Setting up LS:DO with ODBC

Once you have installed all the necessary software, you can set up ODBC and then configure Notes to support it.

Install your ODBC drivers

The ODBC drivers you need are probably available with your database software; in addition, other products and platforms frequently supply commonly used ODBC drivers.

AIX driver manager

If you are using LS:DO on a Domino server running on AIX, you must enable the driver manager before you run any programs. The Intersolv Driver Pack for AIX (version 3.02) contains an archived version of the driver manager libodbc.a, but LS:DO requires an executable or shared object version of the driver manager. Complete these steps to make sure you are using the executable or shared object version of the driver manager:

In a DOS command window, enter this command:
```
file libodbc.a
```
If the file is an archive version, enter this command to extract the executable or shared object version (odbc.so):
```
ar -x libodbc.a
```
Save the archive version using a new name. For example, enter this command:
```
copy libodbc.a libodbc.archive
```
Enter this command to rename the extracted file so that the driver manager file is an executable or shared object:
```
mv odbc.so libodbc.a
```

Register your data sources

For each type of external database that you'll be accessing, you need to specify which ODBC driver to use for accessing it. For details on registering your data sources, consult the documentation accompanying the ODBC driver manager for your platform.

Configure Domino for multi-threading

By default, Domino runs only one copy of a script at a time, queuing additional requests. If you want to enable multiple users to run your script at the time (called multi-threading), you must use the NOTES.INI statements described below.

DominoAsynchronizeAgents statement

Add this line to NOTES.INI on the Domino server to enable multi-threading:

DominoAsynchronizeAgents=1

If you omit this statement, the value defaults to 0 and multi-threading is disabled.

ODBCThreadSafeDrivers statement

Your ODBC driver manager and drivers must be thread-safe to run in a multi-threaded application. Consult with your ODBC supplier to verify that the driver is thread-safe, particularly if the ODBC package is not up to the ODBC 3.0 standard.

If all the ODBC drivers you are using are thread safe, add this statement to notes.ini on the Domino server:

ODBCThreadSafeDrivers=ALL

If none of the ODBC drivers you are using are thread safe, add this statement to notes.ini on the Domino server:

ODBCThreadSafeDrivers=NONE

If you have a combination of thread-safe and non-thread-safe drivers, you can still set up a multi-threaded environment by identifying which drivers are thread-safe and which are not, using the following two statements:

ODBCThreadSafeDrivers = driver-name [, driver-name]
ODBCNonThreadSafeDrivers = driver-name [, driver-name]

LS:DO uses the appropriate type of threading for each driver, based on these statements. If you do not specify whether a driver is thread-safe or not, LS:DO assumes that it is not thread-safe.

You can also set the thread-safe state at connection time with the ThreadSafeDriver property in ODBCConnection.

Install additional software as needed

Your platform may require additional software for using ODBC. Be sure to consult the documentation for your platform to make sure you have all the necessary software installed.