# 2008/11/27(Thu) : [VB.NET] [ORACLE] お仕事メモ

VB.NET + ORACLE にて、接続文字列の Data Source に tnsnames.ora の中身をそのまま書いても接続できた。
これで tnsnames.ora が不要になる。

Dim conn As New OracleConnection("User ID=XXX;Password=XXX;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))")
Try
 conn.Open()
 Dim cmd As OracleCommand = New OracleCommand("SELECT * FROM XXX", conn)
 Dim reader As OracleDataReader = cmd.ExecuteReader()
 Do While reader.Read()
  Console.WriteLine(reader.Item(0).ToString())
 Loop
Catch ex As Exception
 MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error)
Finally
 conn.Close()
End Try

[TOP] [ALL]

© 2005-2010 M-OZ SOFT.
Powered by Gauche Ver.0.8.10