![]() ![]() I found this solution through this Stack Overflow thread: C:\Windows\SysWOW64 for 32-bit applications.C:\Windows\System32 for 64-bit applications.Using symbolic links, you can therefore create a path that points differently for 64-bit applications and 32-bit applications. The Windows system folder will be in different locations depending on 64-bit or 32-bit mode. The trick is to use Windows symbolic links. How can you make them co-exist? Side-by-side installation However, installing any of the drivers (32-bit or 64-bit) disables the other driver. You can also use ODAC XCopy to install the Oracle Instant Client which supports ODBC. Using ODAC XCopy you can install 64-bit or 32-bit OLE DB drivers for Oracle. If you need 32-bit drivers, you will have to use the command-line ODAC XCopy. The ODAC OUI gives you a graphical user interface for installation, but it only provides you with 64-bit version of the drivers. Oracle provides ODAC Runtime Downloads, which contains drivers for Windows. Here is how we solved it! Installing Oracle OLE DB drivers on Windows So we needed to have Oracle OLE DB 32-bit and 64-bit drivers side-by-side. The problem was that the SSIS development environment uses 32-bit OLE DB drivers, but the SSIS runtime uses 64-bit drivers (this could be changed to 32-bit, but it was not a good solution). When you have verified that everything works fine, you are safe to remove any older versions that you should have.Last year I was working on a Data Warehouse project where we were going to use SSIS (SQL Server Integration Services) to read data from an Oracle Database. You can check the version under Help -> About. Might be handy to keep your connections and stuff! If you have any previous installations of SQL Developer installed, the new version should now show them and you will be given the possibility to import an old configuration. This is the Java 6 JDK that you installed in step 1. Browse to C:\Program Files\Java\jdk1.6.0_34\bin\java.exe. It will now ask for the path to your 64-bit java.exe. Now start SQL Developer for the first time by right-clicking on “sqldeveloper.exe” inside the “sqldeveloper” folder. This is where Windows 7 by default installs its 64-bit programs and I prefer to keep it that way. You need the “Windows 64-bit” version.Īfter the download, extract the “sqldeveloper64-3.2.09.30-no-jre.zip” ZIP file to a temporary folder and then copy/move the folder “sqldeveloper64-3.2.09.30-no-jre” to C:\Program Files. If you have any previous versions of SQL Developer installed, do not remove them! You should only remove them after the new installation has finished successfully. ![]() ![]() I downloaded and installed jdk-6u34-windows-圆4.exe, the 64-bit version of Java 6 Update 34 for Windows 64-bit.Ģ) Download and install 64-bit SQL Developer If you don’t already have one on your system, you can download one here. The 64-bit version of SQL Developer does not include a Java Development Kit, but you need a Java 6 JDK to run it. I will explain here how you can install the 64-bit version on Windows 7 64-bit.ġ) Download and install 64-bit Java 6 JDK There are both 32-bit and 64-bit versions of the software. To read more about the new features, check this page. This new version has some interesting new features, like the possibility to administer the APEX Listener, the option to connect to databases in the cloud, and an improved DB Diff wizard. Oracle recently released version 3.2 of SQL Developer. Environment: Oracle SQL Developer 3.2.09 64-bit, Java 1.6.0_34 64-bit, Windows 7 64-bit ![]()
0 Comments
Leave a Reply. |