LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Toolkit 2.05 and Microsoft MDAC

I have an application (developed with CVI 6.0) that uses SQL Toolkit 2.05 to access an networked Oracle 8.0 Database, on Windows NT4 SP6.

All works fine until I try install Microsoft MDAC (which is required to run another application developed in MSVC6). Then my CVI application experiments troubles by reading certain fields of my database. For instance integers are read without the last digit (65 instead of 650 !!) or timstamps are incrorrectly read without error code. However, my CVI application does not use the MS ODBC, but Intersolve's.

I can't explain why installing MDAC could interfere a CVI program that absolutely does not use Microsoft ODBC.

I tried with several versions of MDAC (from 2.2 to 2.7), by re-installing Window
s each time; by installing SQL Toolkit and MDAC in a different order, on 2 computers.

Running my CVI application with another ODBC than Intersolve's does not work (crashes). Running my MSVC6 application with another ODBC than Microsoft's does not work (cannot read timestamps at all)

It seems that there is a compatibility problem between MDAC and SQL Toolkit 2.05. Do you have any idea to solve or bypass the problem ?
0 Kudos
Message 1 of 3
(3,437 Views)
Dropping trailing zeros was a problem in certain versions of ADO/MDAC. The problem occurs if the ODBC driver returns a value as type DB_DECIMAL. An error in the way ADO processes the value causes the digits to be dropped. This problem was reported as fixed in ADO 2.5. The SQL toolkit readme file also discusses this problem.

Why can does installing MDAC interfere with a CVI program that does not use a Microsoft ODBC driver? Because MDAC installs ADO and the SQL Toolkit is based on ADO, see the diagram below.

your program
|
SQL Toolkit
|
ADO (Advanced Data Objects)
|
ODBC interface layer
|
ODBC driver
0 Kudos
Message 2 of 3
(3,437 Views)
I would also suggest that you upgrade to the latest version of the SQL toolkit, version 2.0.6, which uses a different set of ODBC drivers. This is a free upgrade that you can request by calling 1-800-258-7019 or by sending an e-mail to orders@ni.com

Regards,
Azucena
0 Kudos
Message 3 of 3
(3,437 Views)