skip to main content
Setting Up to Implement an IP : Setting up an OpenAccess SDK service and data source for your IP
 

Setting up an OpenAccess SDK service and data source for your IP

A client connects to your data source by connecting to the OpenAccess SDK service that has been configured to access your data source through the IP code you are developing. The OpenAccess SDK installation sets up a service OpenAccessSDK810_C and installs a template OpenAccess SDK 8.1 Service for C/C++. It is recommended that you use the existing service OpenAccessSDK810_C and create a data source entry under it instead of trying to create a new service.
You must configure the following Service and Data Source settings to load your IP code and to make it available when a connection is received by the OpenAccess SDK Server or the OpenAccess SDK Local Server. See the OpenAccess SDK Administrator's Guide for a detailed explanation of all the service and data source attributes that are used to configure an IP for the OpenAccess SDK SQL engine.
*ServiceIPModule - the name of the DLL or shared library created for the IP (for example, template.dll). The file is loaded by the OpenAccess SDK SQL engine when a connection is made to this service.
*DataSourceIPType - DAMIP.
*DataSourceIPSchemaPath - full path of the directory containing the schema for your IP (for example C:\Program Files\DataDirect\oaodbclocal60\ip\schema\yourip. The OpenAccess SDK SQL engine stores the schema for the IP in the files contained in this directory.
*DataSourceLogonMethod - if you want your IP to authenticate based on user name and password passed in from the client, then you set this data source attribute to DBMSLogon(UID,PWD); otherwise, leave it set to Anonymous.
Refer to the OpenAccess SDK Administrator's Guide for information about how to configure a new data source or to set up a new OpenAccess SDK service for your IP based on the provided C/C++ template. Initially, you should use the existing OpenAccessSDK810_C service and add a data source for configuring your IP. Assuming you call this data source yourip, the OpenAccess SDK Client references the yourip data source entry within the OpenAccessSDK810_C service.
Note: If the value of the ServiceIPModule changes, or if the shared library in the ServiceIPModule changes, you must stop and restart the service for configuration changes to take effect.