I am very new to RFT and am using the VB.net version. I am trying to connect to a MS Access database locally. I found an example in my book "Software Test Engineering with IBM Rational Functional Tester". The code is very clear and concise. However I am receiving a build errors stating the following;
- Namespace or type specified in the Imports 'System.Data.OleDb' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.
- Type 'System.Data.OleDb.OleDbConnection' is not defined
My code is below. is there anything that I need to import or a setting that I need to turn on/off? I am not sure which way to proceed. Any and all help would be greatly appreciated. Thanks so much.
Public Function TestMain(ByVal args() As Object) As Object
' Connection String to MS Access DB
Dim connectStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Users\DMalerman\keyword.accdb;" & _
"Persist Security Info=True"
' Create connection to the db
Using connection As New System.Data.OleDb.OleDbConnection(connectStr)
' Create the SQL Query
Dim readQuery As String = "Select KeywordDriver.ScriptName from KeywordDriver " & _
"where KeywordDriver.Keyword = test"
Dim queryCommand As New OleDbCommand(readQuery, connection)
'Open the Connection
' Query the Database
Dim dbReader As OleDbDataReader = queryCommand.ExecuteReader()
' Loop until there is nothing left to read
Dim sKeyword As String = ""
sKeyword = dbReader.GetString(0)
' Close the Reader