Connecting through OleDbConnection
-
HI, I WANT TO CONNECT ACCESS DATABASE IN VB.NET. I USED OLEDBCONNECTION. MY CODE IS '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim connectString As String Dim myOleConnection as New OleDbConnection connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=D:\DRDA\Database\drda.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False" myOleConnection.ConnectionString = connectString myOleConnection.Open() ==============ERROR=============== An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Additional information: No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D). ================ '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' PLS CAN U PROVIDE ME THE RIGHT CONNECTION STRING. THANKS Tasnim
-
HI, I WANT TO CONNECT ACCESS DATABASE IN VB.NET. I USED OLEDBCONNECTION. MY CODE IS '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Dim connectString As String Dim myOleConnection as New OleDbConnection connectString = "Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=D:\DRDA\Database\drda.mdb;Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False" myOleConnection.ConnectionString = connectString myOleConnection.Open() ==============ERROR=============== An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Additional information: No error information available: DB_SEC_E_AUTH_FAILED(0x80040E4D). ================ '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' PLS CAN U PROVIDE ME THE RIGHT CONNECTION STRING. THANKS Tasnim
Public Db as new connection Add all the required reference Sub Main() Set Db = New Connection Db.CursorLocation = adUseClient 'Access= ' Db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\DbName.mdb;Persist Security Info=False" Sql server= Db.Open "Provider=SQLOLEDB.1;Password=" & Password & ";Persist Security Info=True;User ID=" & Username & ";Initial Catalog= " & DataBaseName & " ;Data Source=" & ServerName & "" End Sub