MS Access Database - Web Page - Could not find installable ISAM for password protected file
-
I am trying to open a password protected MS Access file on my website using the foloowing code
string cstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\uploadtest\WebSite1\data\Data.mdb;Database Password=testing"; OleDbConnection ocon2 = new OleDbConnection(cstr); ocon2.Open();This fails with a "Could not find installable ISAM." error. Is there something I am missing, I have no alternative to using a password protected MS Access data file in this process. -
I am trying to open a password protected MS Access file on my website using the foloowing code
string cstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\uploadtest\WebSite1\data\Data.mdb;Database Password=testing"; OleDbConnection ocon2 = new OleDbConnection(cstr); ocon2.Open();This fails with a "Could not find installable ISAM." error. Is there something I am missing, I have no alternative to using a password protected MS Access data file in this process. -
Found it, I love connection strings :( Correct version of string was
string cstr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\uploadtest\website1\data\Data.mdb;Jet OLEDB:Database Password=testing";ConnectionStrings.com is a very useful resource.