Configuring server connection with database in vb.net

Question

I am connecting to the MS Access server with the following code.

Dim cnn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=162.222.225.78;Database=CRM.mdb;Integrated Security=SSPI;User ID=corpopef;Password=********;")
Dim cmd As New OleDb.OleDbCommand
If Not cnn.State = ConnectionState.Open Then
cnn.Open()
End If
cmd.Connection = cnn
cmd.CommandText = "INSERT INTO Addressbook(srno) " & _
"VALUES('" & Me.TextBox1.Text & "')"
cmd.ExecuteNonQuery()

But it results in the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." Please suggest to me some methods to work around this problem.

Thanks in advance...!

The connection string seems problematic for an access database — Alireza
– Alireza, Commented Aug 2, 2014 at 7:06
can u plz help in connection string for access database in server.. — megha
– megha, Commented Aug 2, 2014 at 7:09
try this Dim cnn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=162.222.225.78\CRM.mdb;User ID=corpopef;Password=********;") — Vivek S.
– Vivek S., Commented Aug 2, 2014 at 8:34
apart from that,insted of your connection method use this Using cn As New OleDbConnection(ConnectionString) ... End Using — Vivek S.
– Vivek S., Commented Aug 2, 2014 at 8:38

Alireza · Accepted Answer · 2014-08-02 08:53:45Z

1

The connection string you used seems like an SQL client connection string. For an access database, you should use this format:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path_to_mdb_file\CRM.MDB;User Id=user_id; Password=password;

edited Aug 2, 2014 at 8:53

answered Aug 2, 2014 at 7:57

Alireza

5,0561 gold badge26 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Configuring server connection with database in vb.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related