skip to main content
Configuring the OpenAccess SDK SQL Engine : Configuring Services and Data Sources : Configuring Attributes for an IP Written in .NET
 

Configuring Attributes for an IP Written in .NET

OpenAccess SDK installation creates a service based on the Service for .NET template to support accessing a SQL data source using an IP written in .NET. The following table describes the service attributes that are mandatory in setting up the service and the associated data source, and where applicable, provides the setting group in the OpenAccess SDK Management Console. See OpenAccess SDK Service Attributes for more information about these attributes.
Table 7. Service Attributes Used for an IP Written in .NET
Setting Group
Attribute Name
Description
Advanced
Sets the connection model. The default is Thread/Connection.
Environment
Specifies a list of variables that will be set before the OpenAccess SDK service is started. The syntax for valid values is varname=value. This attribute should contain any settings that are required by the IP pertaining to configuration or the library path.
IP Parameters
Specifies the OpenAccess SQL engine configuration file. This file must be located in the path specified by the ServiceIPPath attribute. Set to oasql.ini by the installer.
IP Parameters
Specifies the name of the OpenAccess SDK module for interfacing the OpenAccess SDK service with an IP written in .NET. Must be set to oadamipnet.dll.
IP Parameters
Specifies the OpenAccess SDK SQL engine module. Must be set to oadssqlip.{lib}.
The following table describes the data source attributes that are required in setting up the data source for the service.
Table 8. Data Source Attributes Used for an IP Written in .NET
Display Group
Attribute Name
Description
IP Parameters
Name of the class implementing the IP for the SQL data source. Each data source under a Service for .NET can have its own IP class. The class must be located in the path specified by ServiceIPPath. For example:oasqlip/oadotnet/net
IP Parameters
Path where the schema files are located. For example:C:\Program Files\Progress\DataDirect \oaserver81\ip\schema\example1
IP Parameters
Determines how the OpenAccess SDK SQL engine handles access to this data source.All user-written IPs must set this attribute to DAMIP.
User Security
Set to Anonymous if you do not want the IP code to authenticate the user.
Workarounds
Set to 8192 to enable Microsoft Access to correctly use the data provider.