□投稿者/ ueno -(2014/10/10(Fri) 12:36:03)
| 分類:[VB.NET/VB2005 以降]
visual studio 2013 vb.net での oracle db の 接続方法、読み方を(コード)を教えてください。 よろしくお願いいたします
********** vb6の接続方法 *************************************
Public poraSess As Object Public poraDb As Object
Dim strMessage As String Dim strDbName As String Dim strUser As String Dim strPass As String
strUser = "TZAI" strPass = "TZAI" strDbName = "UENO"
'Oracle Objects Serverとの接続 Set poraSess = CreateObject("OracleInProcServer.XOraSession")
'Oracle RDBMSとの接続(Oracleモードで接続) Set poraDb = poraSess.DbOpenDatabase(strDbName, strUser & "/" & strPass, 1&)
'*************************************************************************** strSQL1 = "SELECT * FROM 見積明細 " _ & "WHERE 依頼NO = '" & IraiNo & "' " _ & "ORDER BY 依頼NO,業者種別,行NO" '*************************************************************************** Set oraDs1 = poraDb.DbCreateDynaset(strSQL1, 0&)
Do Until oraDs1.EOF
・ ・ ・ oraDs1.DBMOVENEXT Loop
Set oraDs1 = Nothing
|
|