procedure CreateDBODBC(Name : String; Driver : String; Server : String; Database : String; Username : String; Password : String; ConnCount : Integer);

Class IHL7ConnectKernel

Create a database connection pool using an ODBC Driver without a DSN (if you want to use a DSN, use CreateDBDSN).

The name you provide must be unique for the instance of HL7Connect. You will need to use the name in a GetDB call to actually use the database. The database will be listed in the internal logging page.

You must specify a driver. Use a valid ODBC Driver Name (check the drivers page of the ODBC Set up dialog). You must specify a valid Server, Database, Username, and Password. If there is a problem with the database access requested, an exception will be raised.

If ConnCount is supplied it is the maximum number of connections that the connection pool will allow.

It is recommended that database connection pools be created in the OnKernelStart event, but you can create them on the fly as required.

This procedure works with the following drivers:

This procedure does not work with the following drivers: If a driver is not listed, it has not been tested. If you cannot get this function to work, try creating a DSN and using CreateDBDSN)


© Kestral Computing P/L 2000 - 2003. HL7Connect v2.00-063 generated on 30-Nov 2015.
Keywords: CreateDBODBC