January 27, 2017 at 12:55 pm
I have two instances installed on my test server - a SQL Express instance and a SQL Developer instance.
I just installed Oracle Db drivers (for an Oracle Db 11g instance) so that I can link to an Oracle Database using Linked Servers. The new provider (OraOLEDB.Oracle) successfully shows in the SQL Express instance. So I'm able to successfully set up my linked server under that instance.
However, the provider doesn't show under the SQL Developer instance which is where I really wanted to use it.
Since the provider shows under SQL Express, I know the drivers are installed and presumably installed properly (e.g. right bit version, etc...)
How do I the provider to show under SQL Developer as well.
January 27, 2017 at 4:44 pm
More information.... I think that my SQL Developer is a 32-bit installation. I noticed that the instance was installed in my "C:\Program Files (x86)" directory which is the location for 32 bit applications
Could that be the problem?
If so, is there a 64-bit version of SQL Developer?
January 27, 2017 at 5:52 pm
ptownbro - Friday, January 27, 2017 4:44 PMMore information.... I think that my SQL Developer is a 32-bit installation. I noticed that the instance was installed in my "C:\Program Files (x86)" directory which is the location for 32 bit applicationsCould that be the problem?
If so, is there a 64-bit version of SQL Developer?
If the other instance where it's working is 64 bit, the drivers/provider is 64 bit then yes that's likely the problem.
There is a 64 bit SQL 2012 Developer version. You may have to do some hunting for it but it's available.
Sue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply