#1  
Old 24th January 2020, 09:56 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default 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]
  #2  
Old 6th March 2020, 09:35 AM
Piko Piko is offline
Junior Member
 
Join Date: Nov 2008
Posts: 16
Default

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.
  #3  
Old 14th June 2020, 08:42 AM
Henry
 
Posts: n/a
Default Re: Ann: Devart ODBC driver for NexusDB (public beta)

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
  #4  
Old 14th June 2020, 09:53 AM
Eivind Bakkestuen
 
Posts: n/a
Default Re: Ann: Devart ODBC driver for NexusDB (public beta)

> 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]


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
NexusDB V3 Public Beta 1 available now. Q Correll nexusdb.public.discussions 2 29th January 2009 02:45 AM
ANN: NexusDB V2 ODBC Driver beta 6 Hannes Danzl[NDD] nexusdb.public.support 9 9th April 2005 06:54 PM
ANN: NexusDB v2 Public Beta 7 Eivind Bakkestuen [NDD] nexusdb.public.discussions 0 16th March 2005 03:07 AM
ANN: NexusDB v2 Public Beta 6 Eivind Bakkestuen [NDD] nexusdb.public.support 5 13th March 2005 02:37 PM
ANN: NexusDB v2 Public Beta 5 Eivind Bakkestuen [NDD] nexusdb.public.support 0 18th February 2005 03:25 AM


All times are GMT +11. The time now is 01:12 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.