Access Database Connection String June 18 2004
Connections to an access database can be a bitch.
I installed MDAC and JET SP8 and I still got the stupid ISAM error message!
Here is an example that I ripped off from the Visual Studio Solution Explorer:
Dim connection As New OleDbConnection(”Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=E:\AccessDB\SalesLead\Leads.mdb;Mode=Share Deny
None;Extended Properties=”"”";Jet OLEDB:System database=”"”";Jet OLEDB:Registry Path=”"”";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: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”)
- Posted in : .NET
- Author : site admin
Comments»
no comments yet - be the first?