problemer med at connecte til Oracle database
HejJeg programmere i vb.net og skal lave et program der bla. skal connecte til en oracle database der ligger på en server. Men jeg får følgende fejl:
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
Mit spørgsmål er: hvad er det jeg skal have installeret for at få det til at virke?
Min kode er følgende:
Dim strConnection As String
Dim strSQL As String
Dim objConnection as OleDb.OledbConnection
Dim objCommand As OledbCommand
Dim objDataReader As OledbDataReader
strConnection = "Provider=msdaora; Driver={Microsoft ODBC Driver for Oracle}; Data Source=10.12.10.42,1521; User ID=xx; Password=xx"
objConnection= New OledbConnection(strConnection)
objConnection.Open
strSQL = "SELECT * FROM REG_DATA"
objCommand = New OleDbCommand(strSQL, objConnection)
dgData.DataSource = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
dgData.DataSource = objDataReader
dgData.DataBind()
objConnection.Close
På forhånd tak.
Hilsen Maria