通过 Visual Studio 2010 连接到远程 oracle 数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5287111/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
connect to remote oracle database via visual studio 2010
提问by BobTurbo
I have installed the oracle develop tools, odp.net blah blah etc for visual studio 2010 to see, but 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.
我已经安装了用于visual studio 2010 的oracle 开发工具odp.net blah blah 等，但我不知道如何连接到远程oracle 服务器？也许我可以通过代码来完成，但我想我可以转到 Visual Studio 中的“数据连接”并添加到 oracle 数据库的连接？但是我不知道在数据源名称中放什么，因为我只有一个 ip、端口和一些数据库名称或其他东西。
回答by ik_zelf
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.
这个http://www.eggheadcafe.com/community/aspnet/14/10227071/how-to-connect-remote-oracle-database-in-vbnet.aspx怎么样？我不知道你使用的工具，所以我可能有点不对劲。
回答by ManikJ
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-->
在“数据源名称”字段中，输入： <--host address-->/<--server_name-->
回答by demo.b
From vs2010 menu, select Tools --> Connect to database
从 vs2010 菜单中，选择工具 --> 连接到数据库
Under 'Data Source' click change and select 'oracle database'
在“数据源”下单击更改并选择“oracle 数据库”
Click ok
单击确定
Enter server name, username and password.
输入服务器名称、用户名和密码。
Test Connection, if good, click ok
测试连接，如果正常，点击ok
