SQLite3.dll problems x64

本文关键字:x64 problems dll SQLite3 | 更新日期: 2023-09-27 18:03:37

我已经解决了我的问题在SQLite sqlite3_column_origin_name函数与一个简单的解决方案,但现在我有另一个大问题。

我有一个sqlwrapper与这些导入:

    [DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_int")]
    static extern int sqlite3_column_int(IntPtr stmHandle, int iCol);
    [DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_text")]
    static extern string sqlite3_column_text(IntPtr stmHandle, int iCol);
    [DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_double")]
    static extern double sqlite3_column_double(IntPtr stmHandle, int iCol);

这是我的ExecuteQuery函数:

    public DataTable ExecuteQuery(String query)
    {
        SQLiteWrapper.query = query;
        if (!_open)
            throw new SQLiteException("SQLite database is not open.");
        //prepare the statement
        IntPtr stmHandle = IntPtr.Zero;
        try
        {
            stmHandle = Prepare(query);
        }
        catch(Exception e)
        {
            Log.e(e.Message);
            return null;
        }

        // Prevensione sul out of memory
        if(stmHandle == IntPtr.Zero) 
        {
            return null;
        }
        //get the number of returned columns
        int columnCount = sqlite3_column_count(stmHandle);
        DataTable dTable = null;
        try
        {
            //create datatable and columns
            dTable = new DataTable();
            for (int i = 0; i < columnCount; i++)
            {
                try
                {
                    ArrayList selections = Utils.getQuerySelection(query);
                    foreach(String s in selections) 
                    {
                        dTable.Columns.Add(s);
                    }
                    //Workaround for sqlite3_column_origin_name
                    //dTable.Columns.Add("_id");
                   //dTable.Columns.Add(sqlite3_column_origin_name(stmHandle, i));
                }
                catch(Exception e) 
                {
                }
            }
            //populate datatable
            while (sqlite3_step(stmHandle) == SQLITE_ROW)
            {
                object[] row = new object[columnCount];
                for (int i = 0; i < columnCount; i++)
                {
                    switch (sqlite3_column_type(stmHandle, i))
                    {
                        case SQLITE_INTEGER:
                            // WORKS CORRECTLY!!!!
                            row[i] = sqlite3_column_int(stmHandle, i);
                            break;
                        case SQLITE_TEXT:
                            // ERROR!!!!!!!!!!!!!!!!!!!!!!
                            row[i] = sqlite3_column_text(stmHandle, i);
                            break;
                        case SQLITE_FLOAT:
                            row[i] = sqlite3_column_double(stmHandle, i);
                            break;
                    }
                }
                dTable.Rows.Add(row);
            }
        }
        catch(AccessViolationException ave)
        {
            Log.e("SqliteWrapper - AccessViolationException - " + ave.Message + ":" + query);
            return null;
        }
        // Se ci sono stati errori allora torna null e ritenta la query
        Boolean finalized = Finalize(stmHandle);
        if(!finalized) 
        {
            return null;
        }
        return dTable;
    }

当我调用sqlite3_column_text(…)我的应用程序崩溃。我已经探索了dll文件中的函数,这个入口点"sqlite3_column_text"存在。

我能解决我的问题吗?

编辑:我从http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/1.0.66.0/下载我的sqlite3.dll文件

文件在/bin/x64内,我已将其重命名为sqlite3.dll

编辑2:点击我有更多的信息:

File che contribuiscono all description del problema:
C:'Users'Utente'AppData'Local'Temp' WERB927.tmp.WERInternalMetadata.xmlC:'Users'Utente'AppData'Local'Temp' WERD59D.tmp.appcompat.txt
C:'Users'Utente'AppData'Local'Temp' WERD5BD.tmp.mdmp

Leggere l'informativa sulla privacy online:
http://go.microsoft.com/fwlink/?linkid=104288& clcid = 0 x0410

Se l'informativa sulla隐私在线非è一次性,leggere' windows 'system32'it- it' erofflps.txt

SQLite3.dll problems x64

试试下面的代码

[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_text")]
    static extern string sqlite3_column_text(IntPtr stmHandle, int iCol);

string

[DllImport("sqlite3.dll", EntryPoint = "sqlite3_column_text")]
static extern IntPtr sqlite3_column_origin_name(IntPtr stmHandle, int iCol);
row[i] = Marshal.PtrToStringAnsi(sqlite3_column_text(stmHandle, i));