Home  ·  Contact Us  ·  Search  ·  Site Map  
 
 

OpenAccess™ SDK Samples 5.0

Download and install any of the following example IPs by downloading the usage note and the associated source code files in the Download column.

For OpenAccess SDK 5.5 Samples click here

IP Samples
Description Usage Note Download
ISAM IP - shows how to access ISAM files using the standard C-ISAM API. This is a reference implementation based on the Informix C-ISAM API that can be customized for accessing Byte Designs ISAM, any Cobol ISAM files, or home grown file formats.

Full documentation is included with the code download. Download the application note below for an overview.

isam_appnote.pdf

isam.zip

 

ODBC IP - shows how to develop a SQL IP. This IP provides access to ODBC compliant databases.

odbcdrv_src.zip
(ASCII)

Uodbcdrv_src.zip (Unicode)

XML IP - shows how to use SQL passthrough mode to execute a query and return results in XML format. Please refer to the IP Example Installation Guide to set up this IP. In the instructions substitute all occurrences of {example} with xml. This IP uses dynamic schema and is of type XML. xmldrv_src.zip
SQL pass-through IP template - shows how to use the passthrough mode against databases capable of executing SQL. This IP walks through the elements of the query and prints them out. Please refer to the IP Example Installation Guide to set up this IP. In the instructions substitute all occurrences of {example} with sqlpass. This IP uses dynamic schema and is of type XXX. sqldrv_src.zip
SQL pass-through ODBC IP - shows how to use passthorugh mode against ODBC databases. This IP walks through the elements of the query and formats the query for backend database. passodbc.pdf passodbc.zip
ISQL - shows how to use DAM API for building interactive command application. damisql.pdf damisql.zip
COM IP - Shows how to develop an IP that can access a COM-based datasource. Com_Example.pdf COMExample.zip
CSV IP - shows how to set up Dynamic Schema based IP to expose CSV data files and enable Block Join support. CSVexample.pdf CSVExample.zip
Customize Error Messages - Shows how to customize SDK error messages on windows. CustomizingErrors.pdf

CustomizingErrors.zip
(ASCII)

UCustomizingErrors.zip
(Unicode)

Table expression pushdown IP - Java IP shows how to use the table expression pushdown feature against databases capable of executing SQL. This IP walks through the elements of the query, build it and then execute it against OpenAccess Local JDBC driver for DB3 IP. PushJdbcSetup.pdf PushJdbcSetup.zip
Table expression pushdown IP(C++) - C++ IP shows how to use the table expression pushdown feature against databases capable of executing SQL. This IP uses ADO for interfacing with a backend ODBC database that is capable of processing expressions. pushodbcSetup.pdf

dbpushadocpp.zip
(ASCII)

udbpushadocpp.zip
(Unicode)

Binary Schema Example - Shows how to speed up access to static schema information by converting schema information into a binary format (generate a binary schema file). Binary Schema.pdf

Binary Schema.zip
(ASCII)

UBinary Schema.zip
(Unicode)

Example2 - Sample C++ IP which can be built to use Dynamic schema or static schema. Please refer to the IP Example Installation Guide to set up this IP.

Example2.zip
(ASCII)

UExample2.zip
(Unicode)

Linking MFC IP - Shows how to link MFC IP with our Local SDK. MFC Linking.pdf Mfc_objs.zip
Building Local ODBC driver with MFC IP - Shows how to build Local ODBC driver with Example2 IP that uses MFC. mfc_local_odbc.pdf

mfc_local_odbc.zip
(ASCII)

umfc_local_odbc.zip
(Unicode)

Building OpenRDA Server driver with MFC IP - Shows how to build OpenRDA Server with Example2 IP that uses MFC mfc_server.pdf

mfc_server.zip
(ASCII)

umfc_server.zip
(Unicode)

Custom DSN Config - Shows how to create a custom DSN configuration dialog box that allows custom properties required by your backend to be supplied to your IP during the CONNECT call. dnsconfig.pdf

dsnconfig_local.zip

dsnconfig_cs.zip

Wrdaadmin - Sample code for customizing OpenAccess Administration Tool (Local and C/S).   wrdaadmin.zip
MBCS IP - shows how MBCS can be used to support Character sets such as Japanese/Chinese for identifier names (Table, column) and Data. Unzip the dbmbcsdrv.zip file under {oa_root}\sdk\damip folder

Please refer to the IP Example Installation Guide to set up this IP. This IP uses dynamic schema and is of type XXX.
dbmbcsdrv.zip


Application Samples - using ODBC/OLE DB from applications
Description Usage Note Download
VB6 and ADO - shows how to use the OpenAccess OLE DB Provider from Visual Basic 6.0.

Download the file and open the project in VB 6.0. The object has been created to connect through one of our OLE DB Providers and run queries on the sample EMP table (the output fields are specific to this table). Detailed comments can be found on the main form.

Download
VB Script and ADO - shows how to use the OpenAccess OLE DB Provider from VB Script within an HTML page. The sample code is set up to connect to test_local database using the Local OLE DB Provider. You can use it in client/server mode by changing the Provider to OpenRDA and the database to your database name on the server. Download
ASP, VB Script and ADO - shows how to use the OpenAccess OLE DB Provider from VB Script within an ASP page. The sample code is set up to connect to test_local database using the Local OLE DB Provider. You can use it in client/server mode by changing the Provider to OpenRDA and the database to your database name on the server. Download
ISQL - shows how to use ODBC API for building interactive command application. odbcisql.pdf odbcisql.zip
.NET and OLE DB Provider SDK - Shows how to use OpenAccess OLE DB SDK to work in the Microsoft supplied OLE DB .NET Data Provider environment. OLE_DB_and_NET.pdf  
.NET Web Service and ODBC - Shows how to use OpenAccess ODBC SDK to work in the Microsoft supplied .NET Web Service environment. Install.pdf Download
.NET Web Service and OLE DB - Shows how to use OpenAccess OLE DB SDK to work in the Microsoft supplied .NET Web Service environment. Install.pdf Download
Data Link Connect Property Page and OLE DB - Shows how to customize Data Link Connect Property Page and use it with OpenAccess OLE DB SDK DataLinkPropSetup.pdf Download

 

Click here to contact us for support issues.


"One measure of a company's commitment to quality is frequently reflected in the importance they place on customer support. At DataDirect Technologies we believe that solid customer support means satisfied customers and a thriving business for both parties..."

Carol Esau
Senior Director
World Wide SupportLink

  Copyright 2007 DataDirect Technologies.