File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Oracle/OAS and the fly likes ORacle 11gXE 32 bit  installation issue with Windows 7 x64? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "ORacle 11gXE 32 bit  installation issue with Windows 7 x64?" Watch "ORacle 11gXE 32 bit  installation issue with Windows 7 x64?" New topic
Author

ORacle 11gXE 32 bit installation issue with Windows 7 x64?

Yuta Lolap
Ranch Hand

Joined: Jun 03, 2012
Posts: 80

Hi,
I installed Oracle 11g Express Edition 32 bit on my 64 bit machine running Windows 7 Home Premium. I went to Control Panel - Administrative Tools-ODBC-USER DSN- ADD.

When i click on ADD i cant see oracle XE in the drivers list.

Please can you tell me how to move ahead and resolve this issue?


Also i heard that Windows 7 home editions do not support the ORacle 9i/10g and 11g fully.

I need to use eclipse with oracle to work on my project. Please help me!
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

If you have successfully installed Oracle, and can connect to the database from SqlPlus, that's all you need.

Don't use ODBC to connect to Oracle. Oracle provides JDBC thin drivers, which are far better than ODBC and don't require additional setup beyond the connection string. Our Oracle FAQ contains links to JDBC drivers and also some info on the format of the connect string.
chris webster
Bartender

Joined: Mar 01, 2009
Posts: 1617
    
  13

There have been a lot of problems with Oracle 11g XE on Windows 7, as the 32-bit version doesn't always install or work properly and there is (still!) no 64-bit version. Check in your Windows services to see if the database (OracleServiceXE) and TNS listener services are running (OracleXETNSListener). Then use JDBC to connect to the database using the Oracle thin drivers.

If you can't get XE working, you can still try installing the Windows 64-bit version of the standard Oracle 11g database instead, which runs fine on Windows 7 (you'll need lots of RAM for this, especially as you want to use Eclipse as well!). The download site is here, and there are some introductory tutorials here.

Incidentally, for your database work I strongly recommend you download the free SQLDeveloper tool from Oracle, which gives you lots of Oracle functionality independently of your Eclipse DB plugins etc.


No more Blub for me, thank you, Vicar.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ORacle 11gXE 32 bit installation issue with Windows 7 x64?
 
Similar Threads
Wrapper.Createfile failed with error 1224
Can't load IA 32-bit .dll on a AMD 64-bit platform
netbeans tomcat webapp directory location
java.lang.UnsatisfiedLinkError: \bin\ocijdbc11.dll: %1 is not a valid Win32 application
Oracle client removel?