January 17, 2005 at 11:03 pm
we have migrated databases from SQL 7.0 TO SQL2000 .
Before installing pcAnywhere all the DTS Packages are Working fine.
After installing pcAnywhere we are getting following message while opening DTS Packages
DTS Designer Error -Caption
"There was a problem retrieving the list of OLE DB Providers" - Message
Version Details
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.2 (Build 3790: )
Please guide us to sort out this issue
Thanks in Advance
January 19, 2005 at 6:49 am
Hi,
pcanywhere is remote (desktop) accessing tool, I don't think pcanywhere nothing to do with this... I also had coulpe of DTS package on my test DB server and after I installed PCanywhere on tht box. All are fine....
Plz cross check once again...
Thanks - venkat
January 23, 2005 at 4:34 am
It sounds like you used to run your DTS packages from enterprise manager and now you have got PC Anywhere on the server perhaps you are running them from enterprise manager on the server by remote controlling it. One thing with DTS is despite looking like it is bound to the server as it shows in Enterprise manager the packages are acutally run at the client - so if above scenario is correct you would have changed your client from your PC to the server so OLE DB settings may be different - see if they still run at your PC and diagnose from there
James Horsley
Workflow Consulting Limited
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply