The following steps provide the process of building the IP and configuring the OpenAccessSDK810_C service.
1. Build the IP module:
Open the Visual Studio project under install_dir\ip\oasqlip\oaodbc and build the IP module. The projects are configured to place the oasqlipodbc.dll IP module in the install_dir\ip\bin subdirectory.
2 Use the ODBC Administrator to create a system DSN for your ODBC-compliant data source. For example, you can configure a DSN using the Microsoft SQL Server ODBC driver.
3 Run the OpenAccess SDK Management Console and modify the OpenAccessSDK810_C_SQL service to specify the IP module and logon option.
a. Start the OpenAccess SDK Management Console.
b. Double-click the OpenAccessSDK810_C_SQL node to expand it.
c. Double-click the Service Settings node.
d. Double-click the IP Parameters node.
e. Set the value of ServiceIPModule to oasqlipodbc.dll.
f. Double-click the Data Source Settings node.
g. Double-click the Default node.
h. Select the IP Parameters folder.
i. Modify DataSourceIPProperties to the name of the ODBC DSN you created in Step 2. The oaodbc IP will use this DSN for accessing the SQL data source.
j. Double-click the User Security node. Set DataSourceLogonMethod to DBMSLogon(UID,PWD).
k. Save the settings and restart the OpenAccessSDK810_C_SQL service.
4 From an OpenAccess SDK client, use the data source Default of the OpenAccessSDK810_C_SQL service to connect to the oaodbc IP module you have just built and configured. Connections to this data source result in a connection to the ODBC DSN configured in the DataSourceIPProperties attribute.
