Connect to ODBC data source (AnyDAC)

From RemObjects Software

Jump to: navigation, search

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.


Contents

Supported versions

The AnyDAC/ODBC bridge driver supports ODBC Level 3 drivers.

Client software

AnyDAC requires that ODBC driver must be installed according to ODBC specification. You can find:

  • the portional list of ODBC drivers here.
  • the ODBC programming guide here.

Connection definition parameters

DriverID=ODBC

Each ODBC driver has own set of connection parameters. AnyDAC/ODBC bridge driver allows to specify them in ODBCAdvanced parameter. There are two simple ways to connect to ODBC data source:

  • configure DSN using ODBC Administrator control panel, then specify DSN name in DataSource parameter.
  • set the ODBCDriver parameter value, then call Wizard, using ADExplorer or ADAdministrator.

Parameter

Description

Example value

ODBCDriver

The name of ODBC driver to use in connection. If specified, then other connection parameters must be specified in ODBCAdvanced parameter.

SQL SERVER

ODBCAdvanced

Allows to specify any other additional ODBC connection parameter values. They must be separated by ';'.

DataSource

The name of existing DSN to use in connection.

MySAPDB

LoginTimeout

Controls the amount of time in seconds an application waits for a connection attempt to timeout while waiting to establish a connection (0 specifies an infinite wait).

30

MetaDefCatalog

Specifies default catalog for application. The design time code will omit catalog name in object names, if it is equal to MetaDefCatalog.

Northwind

MetaDefSchema

Specifies default schema for application. The design time code will omit schema name in object names, if it is equal to MetaDefSchema.

dbo

Usage cases

  • Connect to PostgreSQL DBMS: 

[My_PGSQL]
DriverID=ODBC
User_Name=postgres
Password=marlboro
ODBCDriver=PostgreSQL ANSI
ODBCAdvanced=SERVER=localhost;PORT=5432;DATABASE=addemo

See Also

Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues

Retrieved from "http://wiki.remobjects.com/wiki/Connect_to_ODBC_data_source_%28AnyDAC%29"
Personal tools