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 ?