首页 \ 问答 \ 在我的代码中,“无法找到可安装的ISAM”错误的原因是什么?(What could be the cause of 'Could not find installable ISAM' error in my code?)

在我的代码中,“无法找到可安装的ISAM”错误的原因是什么?(What could be the cause of 'Could not find installable ISAM' error in my code?)

我无法弄清楚为什么我在这里收到错误说: Could not find installable ISAM 。 我试图将数据添加到Access文件,这似乎有问题。

我不确定为什么这不起作用,因为我在删除每个条目时使用almoust严格的代码。

这里有任何明显的错误吗?

        // Creating a query for each type of data.
        string sqlPC = @"INSERT INTO PersonalData([Type], [UserName], [Password]) 
                         VALUES(@Type, @UserName, @Password)";
        string sqlWS = @"INSERT INTO PersonalData([Type], [URL], [UserName], [Password]) 
                         VALUES(@Type, @URL, @UserName, @Password)";
        string sqlSC = @"INSERT INTO PersonalData([Type], [SoftwareName], [SerialCode]) 
                         VALUES(@Type, @SoftwareName, @SerialCode)";

    HashPhrase hashPhrase = new HashPhrase();
    Security security = new Security();

    private void InsertData(string sql)
    {
        string hashShortPass = hashPhrase.ShortHash(pass);

        string connectionString = 
            @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0};
              Persist Security Info=False; Jet OLEDB: Database Password={1};";

        using (OleDbConnection connection = new OleDbConnection())
        {
            connection.ConnectionString = 
                string.Format(connectionString, filePath, hashShortPass);

            using (OleDbCommand command = new OleDbCommand(sql, connection))
            {
                OleDbParameter prmType = new OleDbParameter
                    ("@Type", security.EncryptAES(cmbType.Text, pass, user));

                command.Parameters.Add(prmType);

                if (cmbType.SelectedIndex == 0)
                {
                    OleDbParameter prmUserName = new OleDbParameter
                        ("@UserName", security.EncryptAES
                            (txtUserName.Text.Trim(), pass, user));
                    OleDbParameter prmPassword = new OleDbParameter
                        ("@Password", security.EncryptAES
                            (txtPassword.Text, pass, user));

                    command.Parameters.Add(prmUserName);
                    command.Parameters.Add(prmPassword);
                }
                else if (cmbType.SelectedIndex == 1)
                {
                    OleDbParameter prmURL = new OleDbParameter
                        ("@URL", security.EncryptAES
                            (txtURL.Text.Trim(), pass, user));
                    OleDbParameter prmUserName = new OleDbParameter
                        ("@UserName", security.EncryptAES
                            (txtUserName.Text.Trim(), pass, user));
                    OleDbParameter prmPassword = new OleDbParameter
                        ("@Password", security.EncryptAES
                            (txtPassword.Text, pass, user));

                    command.Parameters.Add(prmURL);
                    command.Parameters.Add(prmUserName);
                    command.Parameters.Add(prmPassword);
                }
                else if (cmbType.SelectedIndex == 2)
                {
                    OleDbParameter prmSoftwareName = new OleDbParameter
                        ("@SoftwareName", security.EncryptAES
                            (txtSoftwareName.Text.Trim(), pass, user));
                    OleDbParameter prmSerialCode = new OleDbParameter
                        ("@SerialCode", security.EncryptAES
                            (txtSerialCode.Text.Trim(), pass, user));

                    command.Parameters.Add(prmSoftwareName);
                    command.Parameters.Add(prmSerialCode);
                }

                try
                {
                    connection.Open();
                    command.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error: " + ex.Message);
                }
            }
        }
    }

I can't figure out why I am getting an error here saying: Could not find installable ISAM. I am trying to add data to Access file which seems to have a problem.

I'm not sure why this wouldn't work since I am using almoust exacting code when deleting each entry.

Is there any obvious errors here?

        // Creating a query for each type of data.
        string sqlPC = @"INSERT INTO PersonalData([Type], [UserName], [Password]) 
                         VALUES(@Type, @UserName, @Password)";
        string sqlWS = @"INSERT INTO PersonalData([Type], [URL], [UserName], [Password]) 
                         VALUES(@Type, @URL, @UserName, @Password)";
        string sqlSC = @"INSERT INTO PersonalData([Type], [SoftwareName], [SerialCode]) 
                         VALUES(@Type, @SoftwareName, @SerialCode)";

    HashPhrase hashPhrase = new HashPhrase();
    Security security = new Security();

    private void InsertData(string sql)
    {
        string hashShortPass = hashPhrase.ShortHash(pass);

        string connectionString = 
            @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0};
              Persist Security Info=False; Jet OLEDB: Database Password={1};";

        using (OleDbConnection connection = new OleDbConnection())
        {
            connection.ConnectionString = 
                string.Format(connectionString, filePath, hashShortPass);

            using (OleDbCommand command = new OleDbCommand(sql, connection))
            {
                OleDbParameter prmType = new OleDbParameter
                    ("@Type", security.EncryptAES(cmbType.Text, pass, user));

                command.Parameters.Add(prmType);

                if (cmbType.SelectedIndex == 0)
                {
                    OleDbParameter prmUserName = new OleDbParameter
                        ("@UserName", security.EncryptAES
                            (txtUserName.Text.Trim(), pass, user));
                    OleDbParameter prmPassword = new OleDbParameter
                        ("@Password", security.EncryptAES
                            (txtPassword.Text, pass, user));

                    command.Parameters.Add(prmUserName);
                    command.Parameters.Add(prmPassword);
                }
                else if (cmbType.SelectedIndex == 1)
                {
                    OleDbParameter prmURL = new OleDbParameter
                        ("@URL", security.EncryptAES
                            (txtURL.Text.Trim(), pass, user));
                    OleDbParameter prmUserName = new OleDbParameter
                        ("@UserName", security.EncryptAES
                            (txtUserName.Text.Trim(), pass, user));
                    OleDbParameter prmPassword = new OleDbParameter
                        ("@Password", security.EncryptAES
                            (txtPassword.Text, pass, user));

                    command.Parameters.Add(prmURL);
                    command.Parameters.Add(prmUserName);
                    command.Parameters.Add(prmPassword);
                }
                else if (cmbType.SelectedIndex == 2)
                {
                    OleDbParameter prmSoftwareName = new OleDbParameter
                        ("@SoftwareName", security.EncryptAES
                            (txtSoftwareName.Text.Trim(), pass, user));
                    OleDbParameter prmSerialCode = new OleDbParameter
                        ("@SerialCode", security.EncryptAES
                            (txtSerialCode.Text.Trim(), pass, user));

                    command.Parameters.Add(prmSoftwareName);
                    command.Parameters.Add(prmSerialCode);
                }

                try
                {
                    connection.Open();
                    command.ExecuteNonQuery();
                }
                catch (Exception ex)
                {
                    MessageBox.Show("Error: " + ex.Message);
                }
            }
        }
    }
更新时间:2023-02-03 19:02

最满意答案

在我的情况下,我修正了这样:

我改变:

string conexion = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\Fa.mdb;Database Password=xxx;";

至:

string conexion = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\temp\Fa.mdb;Persist Security Info=False; Jet OLEDB:Database Password='xxx';";

I have changed:

string connectionString = 
            @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0};
              Persist Security Info=False; Jet OLEDB: Database Password={1};";

To:

string connectionString = 
            @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0};
              Persist Security Info=False; Jet OLEDB:Database Password={1};";

And it works, I have had 1 unneeded space...

相关问答

更多

相关文章

更多

最新问答

更多
  • 在csproj中使用appdata环境变量(Use appdata environment variable in csproj)
  • 从背景返回后,Skobbler Map崩溃(Skobbler Map crashes after returning from background)
  • 如何保持对绑定服务的轮询?(How to keep polling a bound service?)
  • ASP.NET单选按钮jQuery处理(ASP.NET radio button jQuery handling)
  • Linux上的FORTRAN图形库(FORTRAN graphic library on Linux)
  • 我们如何根据索引更新dynamodb表(不基于primary has和range key)(how can we update dynamodb table based on index(not based on primary has and range key))
  • 功能包装避免重复(wrap of functions avoid duplicating)
  • Android BroadcastReceiver和Activity.onPause()(Android BroadcastReceiver and Activity.onPause())
  • 无法使用phonegap 2.4在Android上播放录音(unable to play audio recordings on android using phonegap 2.4)
  • VS2015 + Resharper:不要使用C#6(VS2015 + Resharper: Don't use C#6)
  • 大学电脑四级对初学者来说要多久能过
  • 特殊字符删除?(Special characters remove?)
  • Android视频教程现在网上的都比较零散呢?有些太坑爹了,感觉老师就是在想当然的讲
  • 计算同一个表中不同行之间的差异[重复](Calculate delta's between different rows in same table [duplicate])
  • Javaweb开发,技术路线是什么?该怎么写?
  • JavaScript只在php代码中执行一次(JavaScript only executes once inside php code)
  • 不兼容的字符编码:ASCII-8BIT和UTF-8(incompatible character encodings: ASCII-8BIT and UTF-8)
  • Clojure(加载文件)给出错误(Clojure (load-file) gives an error)
  • 为具有瞬态scala依赖性的spring-xd项目优化gradle(Optimize gradle for spring-xd project with transient scala dependency)
  • 如何才能在Alpha测试模式下发布我的应用程序?(How can I publish my app in Alpha test mode only?)
  • “没有为此目标安装系统映像”Xamarin AVD Manager(“No system images installed for this target” Xamarin AVD Manager)
  • maven中的Scalatest:JUnit结果(Scalatest in maven: JUnit results)
  • 使用android SDK将文件直接上传到存储桶中的文件夹(Upload a file directly to a folder in bucket using android SDK)
  • 是否应将plists导入CoreData?(Should plists be imported to CoreData?)
  • java.lang.reflect.InvocationTargetException JavaFX TableView(java.lang.reflect.InvocationTargetException JavaFX TableView)
  • 根据唯一列值动态创建多个子集(Dynamically create multiple subsets based on unique column values)
  • 使用CSS可以使HTML锚标签不可点击/可链接吗?(Is it possible to make an HTML anchor tag not clickable/linkable using CSS?)
  • 嵌套的模板可能性(Nested template possibilities)
  • 任何方式在iOS7 +上以编程方式打开蓝牙(Any way to turn on bluetooth programmatically on iOS7+)
  • 如何为给定的SQL查询编写JPA查询(How I can write JPA query for given SQL query)