سؤال في الربط بين الأوراكل و vb.net

[كشجرة طيبة]

السلام عليكم ورحمة الله وبركاته

أخوتي وأخواتي

هل حد يعرف طريقة الربط بين السيرفر مال الأوراكل و VB.NET ؟

إذا حد يعرف على الأقل يعطينا Hint ونكووووووووووووووووووون شاكرين له :nosweat:

ودمتم في حفظ الرحمااااااااااااااااااااااااااااان

[Yousuf]

You can use ODBC (open database connectivity), but this package needs the oracle client software( version 7.2 or later)

you can download version 10.2 from: http://bric.msu.edu/files/10201_client_win32.zip
and the installation guide from: http://bric.msu.edu/files/OracleClientInstallInstructions.doc

This is an example:

Imports System.Data.Odbc

' set up the connection string
Dim sConnString As String = "Driver={Microsoft ODBC for Oracle};" & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
"(HOST=IP_Adress)(PORT=prt))" & _
"(CONNECT_DATA=(SERVICE_NAME=orcl)));uid=orcl_user; pwd=123456;"

' change IP_Adress to the ip of the server that host the oracle database and prt to the port of the database(usually 1521)
' also change orcl to the service name and user name and password of the database.



oODBCConnection = New Odbc.OdbcConnection(sConnString) ' create the connection


oODBCConnection.Open() ' open the connection

If (oODBCConnection.State) Then
MsgBox("Connected")
End If

oODBCConnection.Close() ' close the ODBC connection

[كشجرة طيبة]

We have been try some directly ways from Microsoft visual software but not succeed :nosweat:
Now, I will try your solution and I hope work successfully with us

thaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaanx a lot :cupidarrow: