1.

Solve : VBA Error index 33 string, Argument exception was unhandles?

Answer»

Public Class Form1
Dim con As New OleDb.OleDbConnection
Dim da As OleDb.OleDbDataAdapter
Private Sub Form1_Load(BYVAL sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dbprovider As STRING = "Provider=Microsoft.Jet.OLEDB.4.0;
Dim dbsource As String = "DATA SOURCE:=C:\Users\Finance\Desktop\Test\data.mdb"
con.ConnectionString = dbprovider & dbsource
con.Open()
MsgBox("database OPENED")
End Sub
End Class

i get this error :

Argument excpetion was unhandled
Format of the initialization string does not conform to specification starting at index 33.I think it needs to end with a semicolon.


Discussion

No Comment Found

Related InterviewSolutions