Devart Forums

Hello,

I'm using Delphi 7, and trying to use UniDAC with SQLite.

In the absence of SQLite3.dll, the components are complaining that dll is not found. But when I put the dll into the program folder, connection can be made, but every other operation fails with "SQLite function is not linked" error message.

What I'm doing wrong?

I'm using the latest SQLite dll from official site.

Thank you.

Hello,

Please check that you are using the latest version of SQLite3.dll (3070600) from the official site (http://sqlite.org/download.html).

Also please move the SQLite3.dll file to ..\System32, and try again.
If it doesn't help, please send me the SQLite3.dll file you are using to alexp*devart*com, and specify the exact version of UniDAC

Hello,

Operating System: Windows XP Pro 32 Bit
SQLite DLL: http://sqlite.com/sqlite-dll-win32-x86-3070600.zip
UniDAC version: 3.50.0.14.
Delphi Version: 7.0 (Build 4.453)

I am sending the info also to your mail adress.

Thank you for your help!

Hello again,

As you can see, the module is loaded, but I do keep getting same error.

Here's the screenshot:



and the export list:

sqlite3_aggregate_context $60911322
sqlite3_aggregate_count $60904D83
sqlite3_auto_extension $60914DB6
sqlite3_backup_finish $60931B77
sqlite3_backup_init $60930DB6
sqlite3_backup_pagecount $6090436A
sqlite3_backup_remaining $6090435F
sqlite3_backup_step $60936713
sqlite3_bind_blob $60919E02
sqlite3_bind_double $60919EE7
sqlite3_bind_int $60919EC1
sqlite3_bind_int64 $60919E5E
sqlite3_bind_null $60919E2D
sqlite3_bind_parameter_count $60904EA1
sqlite3_bind_parameter_index $6090CA4C
sqlite3_bind_parameter_name $60904F12
sqlite3_bind_text $60919DD7
sqlite3_bind_text16 $60919DAC
sqlite3_bind_value $60919F58
sqlite3_bind_zeroblob $60919C85
sqlite3_blob_bytes $6090507C
sqlite3_blob_close $609379EA
sqlite3_blob_open $609549A4
sqlite3_blob_read $60937731
sqlite3_blob_reopen $609548D5
sqlite3_blob_write $6093770F
sqlite3_busy_handler $609074AC
sqlite3_busy_timeout $6090755E
sqlite3_changes $609073C4
sqlite3_clear_bindings $60909AE5
sqlite3_close $609315DA
sqlite3_collation_needed $609077FE
sqlite3_collation_needed16 $60907842
sqlite3_column_blob $6091E026
sqlite3_column_bytes $6091ED74
sqlite3_column_bytes16 $6091E089
sqlite3_column_count $60904D91
sqlite3_column_decltype $60904E65
sqlite3_column_decltype16 $60904E83
sqlite3_column_double $60915356
sqlite3_column_int $60915327
sqlite3_column_int64 $609152BA
sqlite3_column_name $60904E29
sqlite3_column_name16 $60904E47
sqlite3_column_text $6091DFB5
sqlite3_column_text16 $6091D06C
sqlite3_column_type $60915264
sqlite3_column_value $60915287
sqlite3_commit_hook $60907661
sqlite3_compileoption_get $60901200
sqlite3_compileoption_used $6090208B
sqlite3_complete $60906FAC
sqlite3_complete16 $60922929
sqlite3_config $6090FCE0
sqlite3_context_db_handle $60904D50
sqlite3_create_collation $60918713
sqlite3_create_collation16 $6091862E
sqlite3_create_collation_v2 $609186B4
sqlite3_create_function $60918B59
sqlite3_create_function16 $60918A0E
sqlite3_create_function_v2 $60918A9A
sqlite3_create_module $6091519B
sqlite3_create_module_v2 $6091517A
sqlite3_data_count $60904DA3
sqlite3_db_config $60908CEB
sqlite3_db_handle $60904F45
sqlite3_db_mutex $60907356
sqlite3_db_status $6090E93C
sqlite3_declare_vtab $6094FAEB
sqlite3_enable_load_extension $6090FCA2
sqlite3_enable_shared_cache $60903E35
sqlite3_errcode $6091997E
sqlite3_errmsg $6091D0AF
sqlite3_errmsg16 $6091CFCB
sqlite3_exec $60943215
sqlite3_expired $60904CBF
sqlite3_extended_errcode $60919921
sqlite3_extended_result_codes $60907897
sqlite3_file_control $6090C21D
sqlite3_finalize $6093778F
sqlite3_free $60901BB7
sqlite3_free_table $609063C9
sqlite3_get_autocommit $60907886
sqlite3_get_auxdata $60904D5B
sqlite3_get_table $60952F00
sqlite3_global_recover $6095A9DE
sqlite3_initialize $6090FE7F
sqlite3_interrupt $609075CB
sqlite3_last_insert_rowid $609073B6
sqlite3_libversion $60907229
sqlite3_libversion_number $6090723D
sqlite3_limit $609077C8
sqlite3_load_extension $609232E3
sqlite3_log $60918494
sqlite3_malloc $60914E42
sqlite3_memory_alarm $6090FBB4
sqlite3_memory_highwater $60918C0F
sqlite3_memory_used $60918C3C
sqlite3_mprintf $60922A07
sqlite3_mutex_alloc $60923635
sqlite3_mutex_enter $6090173F
sqlite3_mutex_free $60901728
sqlite3_mutex_leave $6090176F
sqlite3_mutex_try $60901756
sqlite3_next_stmt $60904F55
sqlite3_open $6095A7ED
sqlite3_open16 $6095A80B
sqlite3_open_v2 $6095A7D2
sqlite3_os_end $6090FC86
sqlite3_os_init $60923725
sqlite3_overload_function $60918966
sqlite3_prepare $60952A94
sqlite3_prepare16 $609528EC
sqlite3_prepare16_v2 $609528C1
sqlite3_prepare_v2 $60952917
sqlite3_profile $6090761F
sqlite3_progress_handler $609074F0
sqlite3_randomness $609237F5
sqlite3_realloc $60910378
sqlite3_release_memory $609017F1
sqlite3_reset $60937AA9
sqlite3_reset_auto_extension $60910285
sqlite3_result_blob $6091111A
sqlite3_result_double $60909A20
sqlite3_result_error $60911169
sqlite3_result_error16 $6091113C
sqlite3_result_error_code $60910E91
sqlite3_result_error_nomem $60904D1F
sqlite3_result_error_toobig $60910DC9
sqlite3_result_int $60909774
sqlite3_result_int64 $6090970D
sqlite3_result_null $60904D0D
sqlite3_result_text $60910F68
sqlite3_result_text16 $60910F46
sqlite3_result_text16be $60910F27
sqlite3_result_text16le $60910F08
sqlite3_result_value $60910B4E
sqlite3_result_zeroblob $609099E8
sqlite3_rollback_hook $609076E5
sqlite3_rtree_geometry_callback $6095A9E5
sqlite3_set_authorizer $60905774
sqlite3_set_auxdata $60912FB6
sqlite3_shutdown $609102D5
sqlite3_sleep $609237C0
sqlite3_snprintf $6091A09D
sqlite3_soft_heap_limit $60923614
sqlite3_soft_heap_limit64 $60923591
sqlite3_sourceid $60907233
sqlite3_sql $60904646
sqlite3_status $60918BA5
sqlite3_step $6093F166
sqlite3_stmt_readonly $6090FC8D
sqlite3_stmt_status $60904F91
sqlite3_strnicmp $60902035
sqlite3_test_control $60923946
sqlite3_thread_cleanup $60907892
sqlite3_threadsafe $60907247
sqlite3_total_changes $609073CF
sqlite3_trace $609075DD
sqlite3_transfer_bindings $6090C11A
sqlite3_update_hook $609076A3
sqlite3_user_data $60904D43
sqlite3_value_blob $6091DFE4
sqlite3_value_bytes $6091E0B8
sqlite3_value_bytes16 $6091E055
sqlite3_value_double $60904CD9
sqlite3_value_int $60904CE8
sqlite3_value_int64 $60904CF5
sqlite3_value_numeric_type $60905056
sqlite3_value_text $6091D09B
sqlite3_value_text16 $6091CFB7
sqlite3_value_text16be $6091CFA3
sqlite3_value_text16le $6091CF8F
sqlite3_value_type $60904D01
sqlite3_vfs_find $60923760
sqlite3_vfs_register $609236B9
sqlite3_vfs_unregister $60901786
sqlite3_vmprintf $60922999
sqlite3_vsnprintf $6091A040
sqlite3_wal_autocheckpoint $60907727
sqlite3_wal_checkpoint $6095A97E
sqlite3_wal_checkpoint_v2 $6095A8A8
sqlite3_wal_hook $60907786
sqlite3_win32_mbcs_to_utf8 $6090FBD5
winCurrentTime $6090CDFF
winDlClose $6090DA57
winDlSym $6090DA6B

Thank you.

Hello,

Thank you for the information.
We have reproduced and fixed the problem.
This fix will be included in the next build.

This problem is connected with the fact that the latest version of SQLite3.dll was built without the SQLITE_ENABLE_COLUMN_METADATA directive and some functions aren't included into it

Also you can manually build SQLite3.dll from the source code with the SQLITE_ENABLE_COLUMN_METADATA directive enabled or use the previous SQLite version 3.7.5 ( http://sqlite.org/sqlite-dll-win32-x86-3070600.zip ) until the next build of UniDAC is released (it will be released next week).

Thank you very much for your fast response and solution!

Hello,

If you have any other questions, feel free to contact us.