SQL7 and MDAC 2.1 SP1 Bug 
Author Message
 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



Sun, 11 Nov 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Problem ( Bug ?? ) with ADODB ( 2.1, 2.5, 2.6 SP1 )

2. MDAC 2.6 on the Server and MDAC 2.1 on the Client - Big Problems

3. ODBC Drive returns records using MDAC 2.0 but not MDAC 2.1 SP 2

4. MDAC 2.0 Vs MDAC 2.1 - Compatibility Issues.

5. MDAC 2.6 on the Server and MDAC 2.1 on the Client - Big Problems

6. MDAC 2.1 and Access 97(-) Incompatable

7. MDAC 2.1 & File locking problem

8. VB5/MDAC 2.1 Problem?

9. Service Pack 3 and MDAC 2.1

10. H E L P MDAC 2.1 Driver

11. MDAC 2.1 and Terminal Server

12. HELP!!: MDAC 2.1 appears to corrupt my data

 

 
Powered by phpBB® Forum Software