Ann: Devart ODBC driver for NexusDB (public beta)

Good news, everyone!

We have partnered up with Devart to produce an up to date ODBC driver,
to provide you with the benefit of their long experience in producing
first class drivers. Their new driver for NexusDB should solve all
known problems that existed in our driver. Here's the good news we
received this morning from Devart:

"We've released public beta of ODBC Driver for NexusDB today"

https://www.devart.com/odbc/nexusdb/

Give their public beta a spin, and report any problems directly to
Devart.


Please note, there is likely to be an upgrade offer for existing
NexusDB customers; we are working out the details of this and will make
a full announcement once finalized.

--
Eivind Bakkestuen [NDD]

[Piko]

The big difference is If I have a license for your ODBC driver and own "NexusDB Developer SRC" license, according to the connectors license on your web suite then is allowed to distribute your ODBC driver with my product.

But DevArt ODBC has only a desktop or suite license.

I have been testing the devart odbc driver from php 7.4, there are some
differences between the nexus and the devart odbc driver, you need to
make some changes to your code before everything works. i ho this wil
help you

1 - select statement
in the nexusdb odbc driver
in the query
$rs = odbc_exec($conn, “select username from nawtable”);
$arr = odbc_fetch_array($rs);

will return the variable username as $arr['username']; where the casing
is equal to the casing in the query.

In devart $arr['username']; will return an error if the field username
in the database is defined as eg ‘Username’ so you need to use the
casing equal to the casing in the database.

2- odbc_prepare
in the nexusdb odbc the following code will work :
$query_string = ‘INSERT INTO students ( studentID, lastName, firstName)
VALUES ( ?,?,? )’
$res = odbc_prepare($db_conn, $query_string);
$exc = odbc_execute($res, array(12, “smith”,”john”));

The integer values are interpreted as integer in the query.
In the devart however they are interpreted as strings. To make it work
the query has to be changed
$query_string = ‘INSERT INTO students ( studentID, lastName, firstName)
VALUES (cast( ? as int) ,?,? )’

3 - odbc_num_rows
In the nexusdb odbc driver odbc_num_rows will return the amount of
records after a select statement, in the devart odbc driver it will
return -1

Henry

> 3 - odbc_num_rows
> In the nexusdb odbc driver odbc_num_rows will return the amount of
> records after a select statement, in the devart odbc driver it will
> return -1

Not sure about the first two, but the above should be reported to
Devart. The information is available and they should implement the
return of that information.

--

Eivind [NX]