Solved SQLB-2493: SQLBaseOLEDB not fully functional

Report SqlBase bugs and possible workarounds.
giscon

SQLB-2493: SQLBaseOLEDB not fully functional

Post by giscon » 20 Apr 2016, 12:32

Hi,
the SqlBase 12 SQLBaseOLEDB.dll doesn’t seem to be fully functional as it was with 11.7 or earlier versions.
Unfortunately, after upgrading to SqlBase 12 for some customers, some vbs-scripts for managing purposes (e.g. install/deinstall a database, backup etc.) didn’t work anymore as they did before and still do with e.g. SQLBaseOLEDB of SqlBase 11.6 or 11.7. Generally, the 32-bit SQLBaseOLEDB driver has been used, only with 11.7 SQLBaseOLEDB I tested also with the x64-dll.

Select’s etc. are still possible with the 12.0 OLEDB, but elements of the SQLBASEOLEDBServer class do not work, although they are still somehow defined in the DLL. Try for example MS Excel with VBA. Incude the SQLBaseOLEDB Type Library and look into the Object Catalog for the SQLBASEOLEDBServer Class and it’s functions/properties. They are listed, but do not work.

To reproduce the problem in a simple way, the following testcase contains two vb-scripts, their names are self-explaining.
SQLBaseOLEDB-Test.zip
The scripts will prompt whether to use the 32-bit or 64-bit environment (and this determines also the corresponding SQLBaseOLEDB Driver, either the 32-bit one or the x64-version).
The first vb-script does a simple select in the island database and that works also with the OLE of SqlBase 12.0.
The second script will ask for the SQLBase-servername (default is server1). Then it will use the SQLBASEOLEDBServer class to connect to that server and to show again that servername and also the clientname. This second script works well for at least SQLBaseOLEDB.dll 11.7 and 11.6 (and presumably older ones), but not with the one from 12.0 or 12.0 SP1.

Regards
Günter
Giscon Systems GmbH
You do not have the required permissions to view the files attached to this post.
Last edited by giscon on 07 Feb 2017, 13:38, edited 2 times in total.

giscon

Fixed in SP2: SQLB-2493: SQLBaseOLEDB not fully functional

Post by giscon » 23 Aug 2016, 10:36

Any news about when this fix with 12.0 SP2 will be released?

Best Regards
Günter
Giscon Systems GmbH

giscon

Fixed in SP2: SQLB-2493: SQLBaseOLEDB not fully functional

Post by giscon » 07 Feb 2017, 13:38

FYI:
This is fixed in SP2.

Kind regards
Günter
Giscon Systems GmbH

Return to “Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests