MDAC - VB6 - MS SQL Server
Posted on 2003-03-21
We are about to field an databse application. The front end is written in VB 6 using ADO with MDAC 2.5. The back end is MS SQL Server 7.0.
Until the last week everything worked well in both the development and production environments. When we tested some changes on the Production LAN we started getting some strange results.
Forms with date fields display properly so long as a record exists (even with NULL for the date field). If no record exists then we get 30 Dec 1899 displayed as the date. On several of the forms if a date is in certain fields, the form is locked from changes even though no record exists.
There have been no changes on the development LAN (we control it) and everything is working fine. On the production LAN they recently upgraded to MDAC 2.7.
As a test we rebuilt one our production side machines with an old load (MDAC 2.5) and everything is working fine. The code run was the same as on machines with MDAC 2.7.
Does anybody have any ideas on what we can do?