procedure CreateDBODBC(Name : String; Driver : String; Server : String; Database : String; Username : String; Password : String; ConnCount : Integer);
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: