vb.net 连接局域网 oracle 服务器

[麒皑鹭]

本人的机器环境 vista ultimate，oracle 10g.
局域网中IP为192.168.1.168 的机器，xp系统，oracle 9i。
本人现在想用vb.net 连上该服务器，处理数据。

请高手指教！

请指明：

1、指明连接的方法，参照www.connectionstrings.com
2、引用的名空间。
3、连接字符串。

[水猿兵团五哥]

问BAIDU吧

[水哥阿乐]

Imports System.Data.OracleClient '引用,如果不能添加请到Oracle官方下载oracle_net.msi

Public Class Form1
    '连接字符串
    Dim strConn As String = "user id=system;password=manager;data source=test;"
    Dim mcon As New OracleConnection(strConn)
    Dim Mcom As New OracleCommand


    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Try
            mcon.Open()
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try

    End Sub
End Class

[麒皑鹭]

本人的方法

Imports System.Data
Imports System.Data.OleDb

Public Class Form1

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim myConnection As OleDbConnection
        Dim myOracleDataAdapter As OleDbDataAdapter
        myConnection = New OleDbConnection("DNS=192.168.1.168;provider=OraOLEDB.Oracle.1;Data Source=myoracle;user id=scott;password=tiger")
        Try
            myConnection.Open()
        Catch ex As Exception
            MsgBox(ex.Message.ToString)
        End Try
    End Sub
End Class