Configuring Attributes for an IP Written in .NET
- Last Updated: May 12, 2026
- 2 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
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.
Service Attributes Used for an IP Written in .NET
| Setting Group | Attribute Name | Description |
| Advanced | ServiceConnectionModel | Sets the connection model. The default is Thread/Connection. |
| Environment | ServiceEnvironmentVariable | 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 | ServiceIPConfigFile | 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 | ServiceIPModule | 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 | ServiceIPSqlEngineModule | 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.
Data Source Attributes Used for an IP Written in .NET
| Display Group | Attribute Name | Description |
| IP Parameters | DataSourceIPClass | 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 | DataSourceIPSchemaPath | Path where the schema files are located. For example:C:\Program Files\Progress\DataDirect \oaserver90\ip\schema\example1 |
| IP Parameters | DataSourceIPType | 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 | DataSourceLogonMethod | Set to Anonymous if you do not want the IP code to authenticate the user. |
| Workarounds | DataSourceWorkarounds2 | Set to 8192 to enable Microsoft Access to correctly use the data provider. |