Hello Everyone:

I am new in programming and I am using vb2005, I am trying to connect to an MS Access database and I am getting an erro message on the following line of code:
Code:
searchtable_command = New SqlClient.SqlCommand(searchtable_string, testsearch_connection)
Error:'System.Data.Odbc.OdbcConnection' cannot be converted to 'System.Data.SqlClient.SqlConnection'.

Here my connection string:
Code:
Dim testsearch_connection As New Odbc.OdbcConnection("Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\CesarAccessdatabase.mdb;Uid=admin;Pwd=;")
What am I missing?

Thank you so much for your help
BK