Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Need help on MSDASQL Provider setting

Author  Topic 

Liew2020
Starting Member

26 Posts

Posted - 2009-02-09 : 22:59:16
Hi guys,
I encounter a connection issue after I migrate my DTS from SQL Server 2000 to SSIS SQL Server 2008.

An error message pop up while I try to edit my Oracle connection.
"The specified provider is not supported. Please choose different provider in connection manager."

Does any one know where can I fix the MSDASQL provider setting in windows?

Thank You.


Best Regards,
Jimmy Liew

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-10 : 01:06:26
Did you also install the Oracle provider on the new machine?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Liew2020
Starting Member

26 Posts

Posted - 2009-02-10 : 01:28:40
quote:
Originally posted by Peso

Did you also install the Oracle provider on the new machine?


E 12°55'05.63"
N 56°04'39.26"




yes. I have.



Regards,
Jimmy Liew
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-02-10 : 02:06:58
See http://support.microsoft.com/default.aspx/kb/915189



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -