SOLVED: What's wrong with not finding installable ISAM?

15968818

The code for my database connection is as follows:
string strconnection = "provider = microsoft.jet.oledb.4.0;";
strconnection + = "data source =";
strconnection + = MapPath ("Data / CXZDataManage.mdb");
strconnection + = "; Jet OLEDB: Database Password = cxz";
OleDbConnection objConnection = new OleDbConnection (strconnection);
objConnection.Open ();
Error prompt:
No installable ISAM was found.
Explanation: An unhandled exception occurred during the execution of the current web request. Check the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No installable ISAM was found.
Where is my mistake?

shenmue024

provider = microsoft.jet.oledb.4.0

This does not exist.

shenmue024

Give an example of connecting access.


string strConn = "Provider = Microsoft.Jet.OLEDB.4.0; Persist Security Info = True; Data Source = d:\\aa.mdb";

System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection (strConn);
conn.Open ();
DataTable dt = conn.GetOleDbSchemaTable (System.Data.OleDb.OleDbSchemaGuid.Columns, null);
conn.Close ();
this.DataGrid1.DataSource = dt.DefaultView;
this.DataGrid1.DataBind ();

15968818

But if I delete the password, it will be fine. How can I correct it?

15968818

Your example is when the database has no password. My database must have a password. How to connect to a database with a password?

shenmue024

try

; User ID = admin; password = cxz;

15968818

string strconnection = "provider = microsoft.jet.oledb.4.0;";
strconnection + = "data source =";
strconnection + = MapPath ("Data / CXZDataManage.mdb");
strconnection + = "; User ID = admin Password = cxz";
OleDbConnection objConnection = new OleDbConnection (strconnection);
objConnection.Open ();
This doesn't work, it is said that it is not a valid account name or password ??

zhouji700

string strconnection = "provider = microsoft.jet.oledb.4.0;";
strconnection + = "data source =";
strconnection + = MapPath ("Data / CXZDataManage.mdb");
strconnection + = "; Persist Security Info = False; Jet OLEDB: Database Password = cxz";

The password in Access cannot be directly used in the Password mode, it should be the same as above

15968818

Thanks:zhouji700