| |

VerySource

 Forgot password?
 Register
Search
View: 680|Reply: 8

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

[Copy link]

1

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-1-16 20:00:02
| Show all posts |Read mode
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?
Reply

Use magic Report

0

Threads

322

Posts

115.00

Credits

Newbie

Rank: 1

Credits
115.00

 China

Post time: 2020-1-21 16:36:02
| Show all posts
provider = microsoft.jet.oledb.4.0

This does not exist.
Reply

Use magic Report

0

Threads

322

Posts

115.00

Credits

Newbie

Rank: 1

Credits
115.00

 China

Post time: 2020-1-21 17:18:01
| Show all posts
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 ();
Reply

Use magic Report

1

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-1-21 17:36:02
| Show all posts
But if I delete the password, it will be fine. How can I correct it?
Reply

Use magic Report

1

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-1-21 18:09:01
| Show all posts
Your example is when the database has no password. My database must have a password. How to connect to a database with a password?
Reply

Use magic Report

0

Threads

322

Posts

115.00

Credits

Newbie

Rank: 1

Credits
115.00

 China

Post time: 2020-1-21 20:09:01
| Show all posts
try

; User ID = admin; password = cxz;
Reply

Use magic Report

1

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-1-22 09:54:01
| Show all posts
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 ??
Reply

Use magic Report

0

Threads

73

Posts

27.00

Credits

Newbie

Rank: 1

Credits
27.00

 China

Post time: 2020-1-22 14:27:01
| Show all posts
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
Reply

Use magic Report

1

Threads

5

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

 Author| Post time: 2020-8-6 12:45:02
| Show all posts
Thanks:zhouji700
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list