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.
| Author |
Topic |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2007-09-18 : 04:43:33
|
| Windows 2003(64bit) server, SQL 2005 Server(64bit), Oracle client 10G rel2 (64bit) is installed. But when I am going to create a datasource to the Oracle database the Oracle OLEDB Provider is missing, the only Providers avaliable is from Microsoft.I have tried to install ODAC (64bit) with no result.Anyone who have come across this problem and how do I do to resolve it?BTW! Is there a way to try communication with the OLEDB provider from the commandprompt? |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-09-18 : 20:19:05
|
| Have you tried "OLE DB Source"? I see "Microsoft OLE DB Provider for Oracle" available. |
 |
|
|
maevr
Posting Yak Master
169 Posts |
Posted - 2007-09-26 : 07:41:49
|
| OLEDB source is the source i am useing and OLEDB Destination as the target. Apparently SSIS does not have support for 64bit Oracle OLEDB Provider driver.I have read in other forum that this is a common error since the two is not compatable. I installed the 32bit Oracle client and that does not work either, but now I can see and choose Oracle OLEDB Provider as the datasource at least, but not get it to work.Any ideas? |
|
|
|
|
|
|
Missing Oracle OLEDB Provider in SSIS