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
精彩评论