开发者

connect to remote oracle database via visual studio 2010

开发者 https://www.devze.com 2023-02-16 06:36 出处:网络
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 co

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

0

精彩评论

暂无评论...
验证码 换一张
取 消