Greetings,
we are a young software company and we kindly invite you to test our
new ODBC driver for jBASE. Please, feel free to download it at
http://www.vultar.md/index_files/download.htm There you will also find the installation instructions page.
Highlights:
- three-tier architecture
- easy setup; immediate access to all tables (VOC source); or T24
tables by company mnemonic
- fast queries based on concat/index files (examples included in the
installation kit)
- multiple sessions on jBASE for creating and sending the result set -
a fast mechanism to export the jBASE data.
- I-Descriptors, field joins (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 support: data access restrictions based on user's company code;
field types auto-detection (based on STANDARD.SELECTION)
- successfully tested with MS Excel, MS Access, MS SQL Server (Linked
Servers), Crystal Reports, BDE, ADO.
Limitations:
- only SELECT/EXECUTE statements so far
- no ANSI-SQL support (jQL engine is used)
To do:
- T24 SMS support
- INSERT, UPDATE, DELETE, GROUP BY, UNION
- Multiple queries per request (scripts); passing the ID lists.
A new version (0.4) of the driver has been released. It solves several
incompatibility issues with a number of Database/ODBC tools. Also, the
new version fixes the problem which raise in some cases the error
message "Connection closed gracefully" in the Administrator tool.
The new versions of the modules can be installed over the old ones.
For any questions, bug reports or other issues please write to
supp...@vultar.md
A new version (0.4) of the driver has been released. It solves several
incompatibility issues with a number of Database/ODBC tools. Also, the
new version fixes the problem which raise in some cases the error
message "Connection closed gracefully" in the Administrator tool.
The new versions of the modules can be installed over the old ones.
For any questions, bug reports or other issues please write to
supp...@vultar.md
The new version of the driver (0.5) is now available for download.
Highlights
--------------
- support for jBASE 4.0 (Win32)
- improved jBASE login script (compatibility issues in some reported
setups)
- Administrator: a new tab 'Parameters' implemented for each alias
definition (setting up the negotiation protocol with jBASE). Should be
used in case the jBASE or login scripts use different messages than
the ones defaulted in the driver.
- Administrator: a new field implemented in the 'Activity Monitor' tab
with the following statistics:
TC - number of threads processing the incoming jBASE data
packets
PS - pool size (the number of jBASE data packets in the
queue)
RPS - average number of records per second retrieved from
the jBASE server.
- Administrator: new action added 'Close active sessions' for a given
connection.
- bug fixes related to non-T24 usage of the driver (T24 data access
disabled)
- the application server in GUI mode now shows the full data traffic
('Show log' checkbox). Warning! 'Show log' feature affects the
performance of the driver. Should be used for debug purposes only.
- T24: improved T24 login process (faster; stable)
- T24: NEW! Implemented full SMS support ('S'ee function)
- T24: bug fix related to $HIS files (wrong field type definition for
the @ID)
- T24: Local fields mapping now works much faster (direct reading
instead of using I-Descriptors)
- bug fix: Accessing the fields using *An syntax (SELECT *A1, *A2...
FROM TABLE)
- bug fix: EVAL function works properly in all jBASE versions
- bug fix: proper error handling for ORDER BY clause
- other bug fixes; improved stability and performance.
Notes
--------
- Non-T24 users should disable the checkbox "Enable T24 data access"
- In case of unexpected errors during the usage of the driver, start
the server in GUI mode, switch on the 'Show log' and repeat the
action. Please send us the log ('Save Logs' button) and other relevant
info in order to investigate the problem.
- Please specify a reasonable number of sessions per request. It
should be in line with the performance of the app server's hardware.
- In case of unsuccessful login to jBASE, the driver automatically
disables the alias. Go to the Administrator, set the proper username/
password and enable back the alias.
- The field 'TC/PS/RPS' in "Activity Monitor" tab might be useful in
evaluating the perfomance of the query. For example, the EVAL function
or distributed files may decrease considerably the value of RPS. High
average value of PS indicates weak hardware of the application server.
A new evaluation license key is available on our website.
Version 0.6 of the driver is now available for download.
Highlights:
- Bug fixes of the EVAL function
- Bug fix of ORDER BY [ASC | DESC] clause
- Better support for .NET Framework (via ODBC .NET Data Provider)
- Fixed some compatibility issues with jBASE 4.0
Please update all modules with the new versions.
There is a new Knowledgebase section on our website
http://www.vultar.md/index_files/know.htm It includes some useful information about SELECT statement, concat
files, T24 integration and other features of the driver. The "Code
samples" page contains examples how to access jBASE data from Win32
and .NET development environments.
Version 0.7 of the driver is now available for download.
Highlights:
- New: Unicode / local ANSI character sets support
http://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.
> Version 0.7 of the driver is now available for download.
> Highlights:
> - New: Unicode / local ANSI character sets supporthttp://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.
Server was down due to some technical issues. We are back online with
a new website including support forum.
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.
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: