How can I write access 95 connection string ?
I don't know how to write the connection string.
my .mdb is access 95.... and I tried those two string
string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ DB_path + ";User Id=admin;Password=;";
string Driver = @"{Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+ DB_path + ";Persist Security Info=False;";
but those are didn't work...
And I got to know OLEDB 4.0 is working at access 2002~
and OLEDB 12.0 is working at access 97 ~
Then how can i write a connection string...?
ps. my computer is x64 windows10.... and mdb file created computer is win XP.....
ps2. and I tried those two too...
string Driver = @"{ Microsoft Access Driver(.mdb) }; Dbq = " + DB_path + "; Uid = Admin; Pwd =;";
string Driver = @"{ Porvider =MicrosoftAccessDriver(.mdb) }; Dbq = " + DB_path + "; Uid = Admin; Pwd =;";
and it doesn't work too.. but that's error msg is
An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;
2 answers
Hi!
Have same/similar problem.
Did you find a solution ?
Access 95 on old Win. 32 bit server
Want to access/read from Office 365/Excel through VBA, Win.10 64 bit PC
(besides the obvious "Porvider" misspell)