
SQL7 and MDAC 2.1 SP1 Bug
Hi,
I have a problem with MDAC 2.1 SP1 (I got it as part of VB SP3).
I have a DTS package in SQL Server 7 created to import data from an Access
database into my SQL Server database. After installing MDAC 2.1 SP1 and VB
SP3, when I goto to DTS package and double click the Access data source I
get the following error:
Package Error
Error Source : Microsoft JET Database Engine
Error Description : Errors Occurred
It appears that SQL 7 is not compatible with version 4 of the ODBC Jet
Driver installed by MDAC 2.1 SP1.
Can anybody help.
Derek Smith
BCT Business Systems Ltd