Re: SQL Server and Client Access

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Gary,

It sounds like CA installed some down level data access components. I would
try installing the latest MDAC from MS.


John Taylor
Canada

----- Original Message -----
From: "Holliday, Gary" <Gary.Holliday@Smedleys.co.uk>
To: <MIDRANGE-L@midrange.com>
Sent: Friday, October 27, 2000 07:07
Subject: SQL Server and Client Access


> We have recently upgraded to OS/400 V4R4M0 and Client Access V3R2M0. Since
> running the CA update on our SQL Server 7.0 box we have had problems with
> some parts of the SQL server. We cannot design or execute DTS packages,
> getting a 'class not registered' error, and trying to open a table in
> Enterprise Manager returns an 'ADO could not find the specified provider'
> error.
>
> Before I updated the server our overnight DTS package took 50% longer that
> before the OS/400 upgrade, 9 hours instead of 6 hours.
>
> This has also affected two SQL clients that I have updated. A reinstall of
> the SQL client fixed the problem, but I am reluctant to reinstall the
server
> if I don't have to.
>
> Has anyone encountered problems like this?
>
> Many thanks
>
> Gary Holliday
> ----------------------------
> Gary.Holliday@Smedleys.co.uk
> Smedleys Foods
> Wardentree Lane
> Pinchbeck, Spalding
> Lincs. PE11 3UY
>


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---