February 22, 2011 at 7:26 am
hi
this sounds a bit strange...but i have connection working fine in my SSIS package, but i want to figure out what provider i have working...
i open it up and it's native OLE DB\Oracle Provider for OLE DB
now...i have a few versions of Oracle installed 10 and 11 and 32 and 64 bit, how do i check which one the provider is from??
February 22, 2011 at 11:52 am
Check the properties of the connection manager. There is a property ConnectionString. Look into that one, it normally has the provider listed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 23, 2011 at 2:52 am
yep
Provider=OraOLEDB.Oracle.1
how do i know if that's Oracle 10,11 - 32 or 64 bit?
how do i go from the provider name to the DLL path?
February 23, 2011 at 5:22 am
darth_vodka (2/23/2011)
yepProvider=OraOLEDB.Oracle.1
how do i know if that's Oracle 10,11 - 32 or 64 bit?
how do i go from the provider name to the DLL path?
Doesn't the provider work on all the versions of Oracle? So it doesn't really matter if it is 10 or 11, 32 or 64 bit?
Here is more information about the provider:
http://msdn.microsoft.com/en-us/library/ms190618.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply