How to connect to database inside VMWare from the web applications

25 pts.
Tags:
DSN connection
Java Database
JDBC
Oracle Database
VMware
Web Dynpro
Hi All,

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)
ASKED: July 7, 2010  12:34 PM
UPDATED: July 21, 2010  3:22 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Swatigaur
    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.
    25 pointsBadges:
    report
  • carlosdl
    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.
    65,110 pointsBadges:
    report
  • Swatigaur
    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
    0 pointsBadges:
    report
  • Michael Morisy
    Thanks for following up, Carlosdl and Swatigaur. Question clarifications are always appreciated!
    8,038 pointsBadges:
    report
  • Swatigaur
    Hi Carlosdl,
    Now inside the VM you can configure netwoking as if this were another physical machine on your network, join it to the domain, etc.
    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.
    25 pointsBadges:
    report
  • carlosdl
    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.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following