如何使用System.Data连接到远程oracle数据库。OracleClient在c#中

时间:2021-02-23 09:46:17

I am building a tool using visual studio 2008 and i want to connect to remote oracle database whose details is given below:

我正在使用visual studio 2008构建一个工具,我想连接到远程oracle数据库,其详细信息如下:

jdbc:oracle:thin:@chi-sunv490-01.harcourt-elearning.com:1521:ELTCPR1
USER NAME: rdadmin
pwd: rdadmin

please tell me the softwares which are required to be installed to make this connection and please give me the connection string.

请告诉我这个连接需要安装的软件,请给我连接字符串。

1 个解决方案

#1


1  

You should create a TNS enry in your machine to access the oracle.

您应该在您的机器中创建一个TNS enry来访问oracle。

https://peking.ithaca.edu:8250/portal/page/portal/TOPLEVELPAGES/ARGUS_HOME_PG/TAB59/argus_recource_center/INSGNG01.pdf

https://peking.ithaca.edu:8250 / portal /页面/ portal / TOPLEVELPAGES / ARGUS_HOME_PG / TAB59 / argus_recource_center / INSGNG01.pdf

Also please note that the microsoft deprecated the System.Data.OracleClient.

还请注意,微软不赞成使用System.Data.OracleClient。

So it is better to use ODP components. http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

所以最好使用ODP组件。http://www.oracle.com/technetwork/topics/dotnet/index - 085163. - html

#1


1  

You should create a TNS enry in your machine to access the oracle.

您应该在您的机器中创建一个TNS enry来访问oracle。

https://peking.ithaca.edu:8250/portal/page/portal/TOPLEVELPAGES/ARGUS_HOME_PG/TAB59/argus_recource_center/INSGNG01.pdf

https://peking.ithaca.edu:8250 / portal /页面/ portal / TOPLEVELPAGES / ARGUS_HOME_PG / TAB59 / argus_recource_center / INSGNG01.pdf

Also please note that the microsoft deprecated the System.Data.OracleClient.

还请注意,微软不赞成使用System.Data.OracleClient。

So it is better to use ODP components. http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

所以最好使用ODP组件。http://www.oracle.com/technetwork/topics/dotnet/index - 085163. - html