ODBC driver for jBASE with T24 support

Greetings,
we kindly invite you to test our new ODBC driver for jBASE. Please, feel free to download it at www.vultar.md/index_files/download.htm
There you will also find the installation instructions page.

The overview and short video demos (preparing a connection and making
a query with MS Excel) are located here:
www.vultar.md/index_files/odbc.htm

Highlights:
- OS and versions:
Win32 : jBase 3.4, jBase 4.0, jbase 4.1, jbase 5.0
AIX 5.3 : jBase 4.1, jBase 5.0
RH Linux: jBase 4.1
- three-tier architecture
- easy setup; immediate access to all tables (VOC source);
or T24 tables by company mnemonic
- multiple sessions on jBASE for creating and sending the result SET
a fast mechanism to export the jBASE data.
- I-Descriptors, field joins/links (like T24 J-Descriptors), EVAL
function
- User Defined Function calls, stored procedures
(examples included in the installation kit)
- Easy ways to access the multi/sub values, expanding values/
subvalues
into separate records, etc.
- Limited SUM and COUNT support
- T24: fast queries based on concat/index files
(examples included in the installation kit)
- T24: data access restrictions based on user's company code;
field types auto-detection (based on STANDARD.SELECTION)
- T24: Local fields support
- T24: Implemented full SMS support ('S'ee function)

- successfully tested with MS Excel, MS Access, MS SQL Server (Linked
Servers), Crystal Reports, BDE, ADO and other database tools.

Limitations:
- only SELECT statements so far
- no ANSI-SQL support (jQL engine is used)

To do:
- INSERT, UPDATE, DELETE, GROUP BY, UNION
- Multiple queries per request (scripts); passing the ID lists.

Version 0.7 of the driver is now available for download.

Highlights:
- New: Unicode / local ANSI character sets support
www.vultar.md/index_files/unicode.htm
- Data throughput speed improvement (5-50% depending on the number of
selected fields)
- Query latency time speed improvement by around 30%
- Small bug fixes (handling of errors)

NOTE: Version 0.7 require a new license key. Please update it.

You cand send any question or suggestion to This email address is being protected from spambots. You need JavaScript enabled to view it.

Kind regards,
Vultar Systems.

Version 0.8 of our driver is now available for download.

Highlights:
- New feature: jQL BY-EXP clause is now supported
- New feature: Enhancements for better multivalue support
- Change: All multivalued fields have character data type by default
- Fix: EXECUTE statement does not return dataset
- Other small bug fixes

All features and changes are documented in our Knowledgebase section.

Kind Regards,
Vultar Systems.

Version 0.9 is now available for download.

Highlights:
- Stored procedures are now fully supported by the driver. INPUT, OUTPUT, IN/OUT, RTNVALUE parameters, adCmdStoredProc command type functionality implemented (ADODB.Command class in C#, VBA, etc...). Stored procedures tab in Administrator tool enhanced/redesigned.
- FIX: Multivalued local fields are properly mapped (VM instead of SM)
- Now any jBC subroutine (including T24 code base) can be declared as a stored procedure in Administrator tool and reused in
custom Win32/.NET application. Example:

cmdJB.CommandType = adCmdStoredProc
cmdJB.CommandText = "OFS.GLOBUS.MANAGER"
cmdJB.Parameters.Refresh
cmdJB.Parameters(0).Value = "OFS.SOURCE.1"
cmdJB.Parameters(1).Value = "FUNDS.TRANSFER,/I/,,,TRANSACTION.TYPE=AC,DEBIT.ACCT.NO=XXXX,CRE..."
cmdJB.Execute

An example can be found here: www.vultar.md/forum?func=view&catid=10&id=17

- FIX: MS Access data import
- Other minor fixes.