How To Connect Vb To Oracle 11g


















































dll this extension set path in envirnment. This is the snippet Connect to an Oracle DB Using ADO on FreeVBCode. Using SQL*Plus in Oracle 11g. 0 If this is your first visit, be sure to check out the FAQ by clicking the link above. View ORACLE DBA’S profile on LinkedIn, the world's largest professional community. We have now new branch opening in other location now we are goin to set up 2 server, can someone guide us how to connect ERP on both the location via any means. Can someone point me in the right direction. I have three questions. Create a new project in Visual Studio 2010 using VB. I'm new to this so I juste copied what I found on this website. Introduction to Oracle 11g SQL Programming Contributing Authors : Danielle Hopkins, John McAlister, and Rob Roselius Published by ITCourseware, LLC, 7245 South Havana Street, Suite 100, Centennial, CO 80112. Enable to Connect Oracle 11g from Sql. How can I connect to Oracle 11g 64bit database using Visual Basic 6. In the New/Select Database Connection dialog box, provide the information for your DB instance: For Connection Name, type a name that describes the connection, such as Oracle-RDS. When we try to run our Classic ASP web page that connects to Oracle we receive the following error. Adding a Reference. The issue is resolved by using the Oracle 10g Driver. In the list of data sources for the linked tables, the only reference to Oracle that I saw was the ODBC Connection for Oracle. Connection") set rs = CreateObject("ADODB. I'm developing an application using Oracle 11g, VB. Select Local Net Service Name Configuration, and then click Next. we have installed the Oracle 11. Datasource configuration file names end with the suffix -ds. open notepad. How to install Oracle 11G database client on Windows 10. To create books in Oracle 11g Release 2:. I have goggled about and cannot find a piece of code that works. Many examples can be found how to access an Oracle 11g Database from VBA in MS Excel. Learn how to connect to a Teradata. Components:ERwin Data Modeler: 7. I believe that the connection is no longer happen [SOLVED] Oracle database connection string in VB file not working?. 1000 (64 Bit) on X64 bit desktop. This Program explains how you connect ORACLE with VB. So, I tried with all in Upper case User name and Password,. In order to connect to EPM, users must add lines permitting an encrypted connection. NET Content provided by Microsoft For a Microsoft Visual C#. Adding a Reference. We can do connection with Oracle either by giving SID (Oracle S ystem ID) or Service Name. In addition, the servicename should be something like "database. These components are supplied by Oracle Corporation and are part of Oracle version 7. Should have a value of the installation path up to the client_X folder. Step 1: Prepare the MS-Access. This start of the code looks like this: '. It allows the number of connections to be scaled as web site usage grows. Verify that the user name that connects to the Oracle database has the authority and privileges to perform the actions of the job. I'm developing an application using Oracle 11g, VB. When the Add Connection window appears, determine if the Data source says Oracle Database (Oracle ODP. 0 in a SQL Server. With the above installations can we connect to SAP from VB. For this, I have created data source name by following steps : Control P. An ODBC Data Source window will open as shown in the below image. But the problem is Oracle ODBC driver is not visible from MS ODBC admin. NET client connecting to an Oracle database server. I found on a website that it's possible to use ADO, so this is why I tried to do. But i am unabpe to do so. 2 and PHP Version 5. One method is to call a stored procedure in Oracle PL/SQL and return a ref cursor. With the new initialization parameter SEC_CASE_SENTITIVE_LOGON, it’s possible to enable or disable password case sensitivity in the database. How To Query Oracle From ExcelAdo Excel Vba Sql Connecting To Base Exle RosAdo Excel Vba Sql Connecting To Base Exle RosConnect To Oracle Base ExcelSql Developer S And UsageHow To Query Oracle From ExcelFix […]. Download the Oracle Express Edition 11g R2 and install. I am trying to connect to an oracle database with no success If I use an SQL tool (Rapid) I have to add the server name. Hi All, In my application i want to connect oracle database to QTP. To interact with Oracle Database XE, you must typically connect to the database as a database user. Enable to Connect Oracle 11g from Sql. Can someone point me in the right direction. Net, and an Oracle Database connection to demonstrate some of the functionality, reproducing a date selector control format that I originally created for use in Visual Basic 6. It works fine with Access. Specify the OID10g hostname and port number details in its corresponding textbox. If your database is running on the windows machine and you are trying to connect to the database using cmd then. When you qualify a column with this operator, Oracle returns the column value using data from the root row. This is an example using ADO:. We don't use SQLServer. We also a have direct SQL mechanism for non first-normal form SQL display. com", or you can try using SID and specifying ORCL. I have been searching for the right code to make the connection without effecting the TSN file. In the code, I also add "OraOLEDB11. I get the message, ora7nt. Select Add Connection. This example uses a connection called jbevans-lx-PS5. Within the Solution Explorer, select the project name, right click and select Add Reference. The following standalone program demonstrates Oracle database connectivity using JDBC API. OracleClient also known as Microsoft OracleClient. Choose the data source, making sure to use the Oracle Database as the data source, and Oracle Data Provider for. Apache NetBeans is free and open source and is governed by the Apache Software Foundation. Net How to Connect Access Database to VB. How to Connect to an Oracle Database in Java on PC or Mac. Creating the Sample Database in Oracle 11g Release 2. Hi all I created some code (which has been used without issue time and again) to create linked tables to an Oracle 10g Database. When we test the connection it fails. ora from database folder to config folder from Oracle Middleware. I connected to my Oracle DB in a simple VB6 app using no ODBC data source. iBasskung 26,346,481 views. Last week, I wrote about how to use bash arrays and the MySQL database to create unit and integration test scripts. I first assumed that I needed to install the 11g version of cx_Oracle. NET? Oracle 11g Oracle Database. Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. MS-Access 2003 and Oracle 10g Release 1 are used to illustrate the concepts. ' List the data. This is how any application will connect to a pluggable database, as well as administrative connections. Devart ODBC Driver for Oracle provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, macOS, Linux, both 32-bit and 64-bit. Using SQL*Plus, connect to Oracle Database as a user with the ALTER USER system privilege. Use SQL*Plus or your favorite SQL command line tool to log in to the target database; log in. I have added the ojdbc5. I am developing an Excel VBA program that I want to connect to a remote Oracle 11g database, run a query, and return the data to Excel. However, this procedure should work with Oracle 8i, 9i, 10g, 11g and 12c databases, as well as various versions of MS-Access. open notepad. Quickly and easily develop desktop, mobile, and web applications with Java, JavaScript, HTML5, PHP, C/C++ and more. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). I have three questions. How to connect remote oracle database in vb. How to connect a oracle 11g database using Visual Studio 2017? I am not able to access or connect oracle database using VS2017. Install the Oracle client for Oracle 11g database, add the tnsnames. Depending on how you choose to define the connection to the Oracle database, confirm that these Oracle environment variables are set correctly: TNS_ADMIN, ORACLE_HOME, ORACLE_SID, TWO_TASK, and LOCAL. Note: no cable commention is feasible since it few KMs away from the current location. 6 and Oracle client 11g on my system. Can Oracle 11g client 64bit connect to Oracle 9i database i would like to ask whether oracle 11g 64bit client runtime can connect back to oracle 9i 32bit database? if can, how are the ways to make the connection works?. Setting up a connection to Oracle Database from SQL Server is fairly easy, but the opposite is not so true. 3 64bit client and the TNSNames. ora files when connecting to an Oracle database across a TCP/IP network. How to add oracle DB connection in Eclipse Sheng Wang 9:22 PM Database , Eclipse , Oracle 13 Comments Have a DB connection in Eclipse will be very helpful if you need use persistence frameworks like Hibernate or JPA. (Caution: This action loads all screenshots simultaneously, so response time may be slow. i have oracle 11g installed on 64 bits laptop running with windows 7. That pulls up another window for provider-specific connection settings. Navigate to Oracle BI EE tab. NET Tutorials. I am developing an Excel VBA program that I want to connect to a remote Oracle 11g database, run a query, and return the data to Excel. IP" '"ServerName" ' Server hosting the Oracle db. The Symantec Connect community allows customers and users of Symantec to network and learn more about creative and innovative ways to use Symantec products and technologies. NET Framework that provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. NET as the data provider. However, this procedure should work with Oracle 8i, 9i, 10g, 11g and 12c databases, as well as various versions of MS-Access. Red Pill Analytics is a unique Analytics and Business Intelligence Delivery firm, combining the best elements of cloud, Agile development, continuous integration, as-a-service, and outsourcing into a service called Capacity Analytics. Oracle 32 bit client is used for SSIS connection manager. We can do connection with Oracle either by giving SID (Oracle S ystem ID) or Service Name. MS Access 2003: Connect to Oracle using VBA code This MSAccess tutorial explains how to connect to Oracle using VBA code in Access 2003 (with screenshots and step-by-step instructions). I have goggled about and cannot find a piece of code that works. OracleClient) The Microsoft. How To Access an Oracle Database by Using the OleDbDataReader and Visual Basic. I'm developing an application using Oracle 11g, VB. Some time long back this was achieved but I do not remember where I could find the source. Join to Connect. 1 64 Bit OS; MS office -2013 32 Bit. So there you go, that’s how to connect to Oracle when you forgot your password. Net - Duration: 19:11. I have a VB 6 application to connect to a Oracle database using ADO Connection. for both MS-EXCEL and MS-ACCESS process is same in establishing connection with ODI. You can connect any Oracle version to VB with the help o. Visual Basic for Applications connecting visual studio 2013 with oracle 11g data base. please help me to connect to oracle database 10 points Badges:. My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts. Install the Oracle client for Oracle 11g database, add the tnsnames. 1 box everithing worked well and, after reboot, I was able to see a driver and connect to my Oracle server. To migrate Oracle databases to SQL Server, you must connect to the Oracle database that you want to migrate. inc file remove semicolan extension=php_oci8_12c. 1 and creating virtual server for that in router as well but didn't work. 7 or greater on your computer. And followed the process to download and tried to install, but instead of 11g, did 12c - is this a problem? One change, instead of 11g, downloaded 12_2 ODBC driver, these 2 files: 1. Download the Oracle Express Edition 11g R2 and install. Oracle 11g introduces case-sensitive passwords for databases created with the default Oracle Database 11g enhanced security. NET application -> open a new project -> From your Windows Program m. pyodbc does not do any conversion between Unicode encoding schemes. Using pyodbc with a UCS4 Python Build Python can be built as either UCS2 or UCS4, which defines Python’s internal storage format for Unicode strings. NET on FreeVBCode. When the connection to an instance is lost, SESSION failover results only in the establishment of a new connection to another Oracle RAC node; any work in progress is lost. The idea would be to press a button in a Word report and validate username and pass Word connecting to Oracle - VBA Visual Basic for Applications (Microsoft) - Tek-Tips. I need to connect to an Oracle database using VB. Connection") set rs = CreateObject("ADODB. 06/08/2017; 2 minutes to read; In this article. After you add a View Composer database to an Oracle 11g or 10g instance, you must configure an ODBC connection to the new database to make this data source visible to the View Composer service. In addition, the servicename should be something like "database. The issue is resolved by using the Oracle 10g Driver. 1) ODBC driver on my Excel. for both MS-EXCEL and MS-ACCESS process is same in establishing connection with ODI. com", or you can try using SID and specifying ORCL. Database Resident Connection Pooling is a new feature of Oracle Database 11g. Adding a Reference. ORACLE DBA - Ahmedabad - Ahmedabad, GJ XDuce Infotech Pvt. I created a sample project using C#, ASP. net without tnsnames. This article demonstrates in a step by step fashion the easiest, and frankly fastest way to connect to an Oracle database using C#. The Emergency Monitoring feature of Enterprise Manager Cloud Control 12c is an evolution of Memory Access Mode from Grid Control 11g, allowing you to access in-memory statistics. I have done many Oracle projects with VB. QTP11 can't connect to Oracle 11g on Win7(64bit) If this is your first visit, be sure to check out the FAQ by clicking the link above. Connecting to Oracle Database (OracleToSQL) 01/19/2017; 4 minutes to read +3; In this article. oracle 11g client on each machine no, you do not need to - the 9i clients can connect to an 11g database just fine. I'm a BCA student. Hi all I created some code (which has been used without issue time and again) to create linked tables to an Oracle 10g Database. Oracle Database - Connect Descriptor (TNS Connect String) Oracle Database - Connect Identifier; Oracle Database - Connect String (Client Connection Initiation) Oracle Database - Oracle Connection Manager; Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID) Oracle Database - Connection Pool. Within the Solution Explorer, select the project name, right click and select Add Reference. Adding a Reference To connect the project to an Oracle database, you must add a reference to the Oracle. Yes, you can connect to Oracle with installing the client. How to connect as SYS and create user in Oracle 11g. Oracle ODBC x86 and x84 on Excel 32bits. My application is developed in visual basic 6 and oracle 11g express is its database. Hope you are well with the grace of Almighty Allah (swt). We can do connection with Oracle either by giving SID (Oracle S ystem ID) or Service Name. 7 or greater on your computer. 0 running on Windows 10 64bit machine? Since this forum is for ADO. 1provider but still we are not able to connect to Oracle 11g 64 Bit using OraOLEDB. Within the Solution Explorer, select the project name, right click and select Add Reference. If you’re here because you downloaded a copy of Oracle SQL Developer and now you need help connecting to a database, then you’re in the right place. Programming in Visual Basic. Oracle to Microsoft SQL Server Migration. When we try to run our Classic ASP web page that connects to Oracle we receive the following error. I have also tried using 127. 0 Library", > wich both I and my clients has installed. When we try to run our Classic ASP web page that connects to Oracle we receive the following error. Because our project must connect to an Oracle database, it is necessary to add a reference to the Odp. This may help with your issue in zenon VBA. ora, entries in the file follow a rigid format. NET programming solution, you must use the Add Adapter Service Reference Visual Studio Plug-in. 1 box everithing worked well and, after reboot, I was able to see a driver and connect to my Oracle server. I am able to access 9i and 10g Oracle DBs from other clients on my pc - sqlplus, PLSQL Developer, etc. The Symantec Connect community allows customers and users of Symantec to network and learn more about creative and innovative ways to use Symantec products and technologies. Job Automation and reporting. This Program explains how you connect ORACLE with VB. 0) for Microsoft Windows (x64) ‘. NET on October 16, 2012 Tags: Database Connectivity , Oracle 10g , VB. I'm a BCA student. I'm not sure if Oracle document the protocol, or if you would have to reverse engineer it. I'm looking for a way of connecting Word with an Oracle database. The docs/example/jca directory contains sample files for a wide selection of databases and it is a good idea to use one of these as a starting point. net (C#)? what is the connection string for it? when i was trying to connect i got the below error: ORA-12154: TNS:could not resolve the conne. Connecting to a Oracle Database using VB. Change the cmd. How to change the connection string of the Oracle Enterprise Manager Grid Control 11g repository September 1, 2011 by Laurent Schneider If you moved your repository to a new host and want to change the connection string, no need to drop it, no need to messup in the properties or xml files, simply read the doc. Net Framework using C#. These components are supplied by Oracle Corporation and are part of the Oracle Version 7. inc file remove semicolan extension=php_oci8_12c. I'm developing an application using Oracle 11g, VB. net I last porgrammend in VB 6 need help to connect to oracle 11g Database. \Bentley\MicroStation\MicroStation\config\database\oracle. How can I connect to Oracle 11g 64bit database using Visual Basic 6. ? Report message to a moderator Re: connecting to an oracle database without odbc by excel vba [ message #626127 is a reply to message #626124 ]. Datasource configuration file names end with the suffix -ds. In an attempt to bypass the need for Oracle on all computers, I have modified the VBA to open a new website - which is connected to the Oracle database - run the query there, and copy the results back into the Excel file, and this gives them the new report. Oracle Corporation also makes the following edition available: Oracle Database Express Edition (XE), a free-to-use entry-level version of Oracle Database available for Windows and Linux platforms limited to using only one CPU, up to 1 GB of RAM and storing up to 11 GB of user data. I am developing an Excel VBA program that I want to connect to a remote Oracle 11g database, run a query, and return the data to Excel. If a table contains hierarchical data, then you can select rows in a hierarchical order using the hierarchical query clause (START WITH condition1) CONNECT BY condition2. Net - Duration: 19:11. However today we discovered that on a Linux machine connected to a remote database, we had to setup the Apache environment variables in order to get our tnsnames. I am using Ms Excel version 2013. NET Framework 1. we have installed the Oracle 11. Creating the Sample Database in Oracle 11g Release 2. 06/08/2017; 2 minutes to read; In this article. Oracle Dataprovider for NET Windows Forms sample My sample demonstrates reading access to a Oracle database 11g and how to use the Oracle data provider for NET in a Windows Forms application. Data Imports System. How to connect a oracle 11g database using Visual Studio 2017? I am not able to access or connect oracle database using VS2017. When you configure an ODBC DSN for View Composer, secure the underlying database connection to an appropriate level for your environment. Toad can connect to Oracle without any issue. The goal is to not have to install the huge Oracle Client either on the development machine nor the target machine the code will run on. We've installed the Oracle 11g client. net DLL containing the data provider of our choice. Connection strings and drivers are all OK as far as I know. ora files when connecting to an Oracle database across a TCP/IP network. Scroll down the to list of platforms and click the 'See All' link next to your operating system. I want to know how to connect a database from Oracle to VB 6. 1) Oracle 11g Database express edition (OracleXE112_Win64) - We need this because when. The string that will be converted to a date. I did the installation on Window 7 64-bit, and did run into a problem with the Windows Registry on a fresh installation (posted earlier on the blog). ora file? The trick is to put the tnsnames information into the ODBC connection string directly, using the Data Source= option. we have installed the Oracle 11. NET application that uses an Oracle database. Many examples can be found how to access an Oracle 11g Database from VBA in MS Excel. If you wish to create project in Visual Basic, select Visual Basic Projects in Project Types instead, and enter HR_Connect_VB under Name. Omiting tnsnames. Read top stories published by Red Pill Analytics. I am trying to access oracle via toad. Quickly and easily develop desktop, mobile, and web applications with Java, JavaScript, HTML5, PHP, C/C++ and more. ORA driver support for Oracle 11g features. Hi all, I could not connect to oracle database using excel macro. – For backup/recovery procedure you should be using RMAN instead — that’s what it’s for — backup/recovery. Access Database connection string is different for Access 2003 (*. Any help would be appreciated. Empty TNS dropdown. dll" as Reference. I hit New Connection>Change > Change Data Source and then select Oracle Database. A value between 0-49 will return a 20xx year. Bing's Knowledge Base. 3 64bit client and the TNSNames. 8 + Oracle 데이터베이스 11g R2 P4 오류 [ORA-30009] CONNECT BY 절 대량 사용 시 해당 에러 발생 SQL> SELECT 1 FROM DUAL CONNECT BY LEVEL <= 10000000 결과 잘 나오다가 마지막에 ER. ora file and add a description for XE data source. We are using oracle database 11g. Using Oracle Developer Tools. Of course, this method works if your system isn’t locked down. The database is up and running i. Toad can connect to Oracle without any issue. Adding a Reference To connect the project to an Oracle database, you must add a reference to the Oracle. Hope you are well with the grace of Almighty Allah (swt). NET web application to an Oracle 11g database? Can EntityFramework handle this right out of the box? Or will I need some sort or ODBC plugin from Oracle? *I'm running from a locked down environment, so I can't really test any of these scenarios at this time. net application. DLL calls the TNSNames ultimately establishing a connection to the database. It is useful for short lived scripts such as typically used by web applications. Devart ODBC Driver for Oracle provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, macOS, Linux, both 32-bit and 64-bit. After installing the Oracle Developer Tools for Visual Studio 2017 - MSI Installer, please connect to Oracle through Server Explorer window in Visual Studio 2017. I have Oracle installed on my PC (Oracle Client 11g and Oracle Client ORA Files). oracle 11g client on each machine no, you do not need to - the 9i clients can connect to an 11g database just fine. I am having an issue writing a connecting string in VB to connect to this database in VB so i can create buttons and get results from this from oracle. NET 2017 Program Example to Connect Oracle Database In the following example, it will ask the user to enter Employee's ID, and after clicking on the Query button, it will show the employee's first and last name using the MessageBox. Oracle Dataprovider for NET Windows Forms sample My sample demonstrates reading access to a Oracle database 11g and how to use the Oracle data provider for NET in a Windows Forms application. Michael McLaughlin's Technical Blog. To create a new analysis from SmartView, Open Excel and connect to Oracle BIEE. I created a package and installed it on another PC on same network. NET application that uses an Oracle database. Few links to download Oracle client are as follows: Click here for step-by-step Oracle 11g R2 Client Installation on Windows 7. jar) security exception when run on Domino server (it's ok when runnng local). Instructions: Copy the declarations and code below and paste directly into your VB project. How to connect the oracle database as a backend in asp. I am able to access 9i and 10g Oracle DBs from other clients on my pc - sqlplus, PLSQL Developer, etc. Can Oracle 11g client 64bit connect to Oracle 9i database i would like to ask whether oracle 11g 64bit client runtime can connect back to oracle 9i 32bit database? if can, how are the ways to make the connection works?. ora under the samples folder. One of the most common connect identifiers is a net service name, a simple name for a service. Depending on how you choose to define the connection to the Oracle database, confirm that these Oracle environment variables are set correctly: TNS_ADMIN, ORACLE_HOME, ORACLE_SID, TWO_TASK, and LOCAL. Learn more. There is no general 'best solution' and the best method for connectivity depends on the particular situation and specifications. The View Designer button will open the Oracle BI EE presentation services Subject Areas. Connect to oracle database through JDBC 5. 5861 to Oracle 11g using the below mention step Go to Source/Destination of the Channel (I am using Destination) Select Connector Type: Database Writer Driver: Oracle URL: jdbc racle:thin:@localhost:1521:xe (1521 is the default port for Oracle and XE is the default DBname) Username: (Name of schema) Password:. When the connection to an instance is lost, SESSION failover results only in the establishment of a new connection to another Oracle RAC node; any work in progress is lost. NET programming solution, you must use the Add Adapter Service Reference Visual Studio Plug-in. Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. 1provider thru Windows xp 32 Bit client ->vb. The database is up and running i. I have a VB 6 application to connect to a Oracle database using ADO Connection. This tutorial shows you how to migrate a Microsoft SQL Server database to Oracle Database 11g using Oracle SQL Developer. Connecting to Oracle Database in Java This article is a step by step guide on connecting to an Oracle database from a Java program. I hit New Connection>Change > Change Data Source and then select Oracle Database. It allows the number of connections to be scaled as web site usage grows. What is the easiest way to connect a. It list all connection strings and some drivers for you to connect. Port 1158 is the web listener for Database Control, a webgui for managing the database. about the connection string im using Oracle 10 Express Edition and i want to connect oracle database to vb 2008 im a beginner thanks i want to study oracle because im done with mysql Monday, January 25, 2010 5:26 AM. In Visual Studio 2008, click the “Connect to Database” button in the Server Explorer pane. Oracle database connection in vba; Oracle database connection in vba. How to Speed Up EXPDP/IMPDP Data Pump Jobs Performance in Oracle Checking Temporary Tablespace Usage in Oracle How to Shrink Temp Tablespace and Reclaim Unused Space in Oracle How To Check Alert Log File in Oracle 11g How to Gather Statistics on Large Partitioned Tables in Oracle. FIM needs to connect to the Oracle database to get schema information. – 11g’s EXP tool is not designed to export data from older versions of oracle — it’s whole purpose in 11g is for backward compatibility where you might have to bring a small subset of data from =9i versions to 11g. Our software and services protect against more risks at more points, more completely and efficiently, enabling confidence wherever information is used or stored. 4) Xcopy for Windows x64 to. Emergency Monitoring in Oracle Enterprise Manager Cloud Control 12c. Note: Before you can connect to an Oracle database using Power Query, you need the Oracle client software v8. I have goggled about and cannot find a piece of code that works. I installed Erwin DM on Windows7 64-bit and cannot connect to Oracle. But i am unabpe to do so. Cannot be specified with the START WITH or CONNECT BY condition. NET client connecting to an Oracle database server. Net; Add reference to Oracle. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with. Hi All, I want to connect to oracle enterprise 11g database to query some tables from Eclipse using JAVA code.