SQL Server Version: 2000
Hi, I am having some ODBC error messages when I try to open up DTS packages on our deveopment and production servers. Nobody has been able to answer this question for me at work, so I'm hoping one of the experts here can!
I'm getting a few variations on this error...
Mind you, all these DTS packages are live and running just fine on the server and they open up properly for the other DBA... so, I'm assuming it has something to do with my computer...
When I double click on some of the objects inside of the DTS package I'm getting errors...they usually occur when the package is connecting to an external data source to pull in data.
The first message is: Access Denied. With just an OK button. I click the OK button and then another error message pops up that says: No provider is selected. To continue, you must select a valid provider. With just an ok button. When you hit ok it does nothing. (This occurs when I double click on the solid black line that is going from one object to the other. If I click on the connection object, it just says access is denied and then brings up the connection window empty.
The second message I get (in a different DTS package): Error Source: Microsoft OLE DB Provicer for ODBC Drivers Error Description: Microsoft ODBC Driver Manager Data source name not found and no default driver specified. This occurs when I click on the solid black line that goes between the connection objects. If I click on the connection object, it just says access denied and brings up the blank connection window as in the first scenerio.
I assume this has something to do with the providers/drivers I have installed on my desktop... but I can't figure out how to fix it. I am running Windows XP and I cannot update the MDAC because it says I don't need to do it as my version of Windows has everything in it already.