I have VMWare in my desktop which contains the Oracle database. And in general my desktop is in network with the server having web based applications. Now I want to fetch the data from this VMWare database in my application. Can we establish JDBC connection from the application to this database. Can we create a DSN?
Software/Hardware used:
Web Dynpro Java (SAP)
- Any open source tools to test desktop applications using Java?
- apache web server accessing application on virtual machine
- How do I configure VMware guestOS(s) to talk to Vista Home Premium as a Host to access DB2 or any other database?
- Unable to connect to printer through network
- SQL server production virtualization - to do or not to do
It might be different depending on the Vmware product being used, but in general you would have to select the proper VM from the VM inventory, and in the Hardware section edit the network adapter to use a "Bridged" connection. Now inside the VM you can configure netwoking as if this were another physical machine on your network, join it to the domain, etc.
To create the DSN, the server name would be the host name of your VM (or its ip address), the default Oracle port number is 1521, the Oracle SID is a unique identifier or name of the database instance (it is defined when creating the database), and the user id and password would be from a database user that con log and query the database.
If you configured the VM’s network connection as ‘bridged’, you should be able to connect to the database from any network location as if it were running on a physical machine.
Thanks for your reply.
Can you describe in more details the steps I need to follow for this as I am new to use VMWare. Also I want to know for creating DSN we need to provide some parameters like server name, port number, sid, user id, password. Where can I get these details.
suggest to adopt Microsoft Online Services that is a business-class communications and collaboration software offering delivered as a subscription service, hosted by Microsoft.These services help make it easier for customers to rapidly and cost-effectively access the most up-to-date technologies, and are designed for rapid deployment to provide customers with streamlined communications, simplified management, and business-class reliability and security.More content click here http://www.onlinesc.com
Thanks for following up, Carlosdl and Swatigaur. Question clarifications are always appreciated!
Hi Carlosdl,
I have checked the IP address of my machine and the VMWare, both are different. Do I need to change the IP address of VMWare and put it in my machine’s IP address range???
Also the Server is in network with my machine and I need to create the DSN so that I can connect to the database inside VMWare.
I tried changing IP Address but its not reflecting. Can you please let me know how to change it.
The ip address of the virtual machine must be different from the address of the host (your pc), but it should be on the same subnet as the server from which you are trying to connect to the database.
How to change the ip address would be different depending on the virtual machine’s OS, which you didn’t specify.
Before trying to connect to the database, you should make sure you can ping the virtual machine from the server.