connect to remote oracle database via visual studio 2010

I have installed the oracle develop tools, odp.net blah blah etc for visual studio 2010 to see, bu开发者_如何学JAVAt I have no idea how to connect to the remote oracle server? Maybe I can do it via code, but I was thinking that I could go to "Data Connections" in Visual Studio and add a connection to the oracle database? Yet I have no idea what to put in data source name, etc as all I have is an ip, port, and some name of the database or something.

How about this http://www.eggheadcafe.com/community/aspnet/14/10227071/how-to-connect-remote-oracle-database-in-vbnet.aspx ? I don't know about the tool you use, so I might be a little off.

I had the same issue. Just got it solved. Pretty straightforward by the end.

Under the username and password, enter the credentials you have.

In the 'Data source name' field, enter: <--host address-->/<--server_name-->

From vs2010 menu, select Tools --> Connect to database

Under 'Data Source' click change and select 'oracle database'

Click ok

Enter server name, username and password.

Test Connection, if good, click ok