WhamTech OLE-DB Provider Driver Registration

Windows client applications that need a higher level of interface (Visual Basic, Internet Applications, etc.) can use the WhamTech OLE-DB driver.

WhamTech OLE-DB Driver File Location

The OLE-DB API DLL file (tboledb.dll) is located under 'Client Application Components\bin' folder.

Registering and Unregistering OLE-DB Driver

You must register the OLE-DB driver before it can be used. Open the "Client Application Components" folder from the EIQ Product Suite installation in the Start Menu and select ‘Register OLE-DB Driver’.

You can un-register the driver by using the same path as above but selecting "UnRegister OLE DB Driver".

See Microsoft documentation for help registering and using OLE-DB API.

Using the OLE-DB Driver from Client Applications

Once the OLE DB Driver is registered, use the following connection-string syntax to connect to an ENVI (EIQ Server Non-Virtual Index) or to an EIQ Server Data Source.

To connect to an EIQ Server VDS:

"Provider=WhamTech Thunderbolt OLE DB Provider;Server Name=<IP addr or m/c name>; Data Source= <VDS Name>"

Example: "Provider=WhamTech Thunderbolt OLE DB Provider; Server Name=192.16.10.2;

Data Source= SAMPLEVDS"

To connect to an EIQ Server Data Source using REGDB:

"Provider=WhamTech Thunderbolt OLE DB Provider; Server Name=<IP addr or m/c name>; Data Source= REGDB:<Data Source Name>"

Example: "Provider=WhamTech Thunderbolt OLE DB Provider;Server Name= Station10; Data Source= REGDB:POLICEDS"

To connect to a local index (or EIQ Non-Virtual Indexes (ENVI)):

"Provider=WhamTech Thunderbolt OLE DB Provider; Data Source= <Path to DB>"

Example:

"Provider=WhamTech Thunderbolt OLE DB Provider; Data Source=

C:\Data\SampleDB\SampleDB"

Sample Code

EIQ Product SDK\Samples\ ADO\ folder under the install path contains sample C++ and C# client applications that demonstrate using the OLE-DB driver.