Imports Excel = Microsoft.Office.Interop.Excel Imports System.Data Imports System.Data.OleDb Imports ADODB Imports System.Data.SqlClient Imports System.Console Imports System.Data.SqlServerCe Imports Microsoft.VisualBasic Public Class Form3 Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim rs As New ADODB.Recordset Dim dbConnection As SqlCeConnection dbConnection = New SqlCeConnection("Persist Security Info = False; Data Source = C:\Documents and Settings\Desktop\MyDatabase#1.sdf") ' Create the connection string. dbConnection.Open() 'Create the SQL statement. Dim testCommand As SqlCeCommand = New SqlCeCommand("SELECT * FROM Name") 'Create the recordset and run the query. rs = New ADODB.Recordset rs.Open(testCommand, dbConnection, 0, 1, 1) ....
rs.Open(testCommand, dbConnection, 0, 1, 1)
The error reads: COMException was unhandled. Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Any ideas on what the problem might be?? I am fairly new at all of this and really confused.