Linking Errors with sqlite3 library due to conflicts with engine pluging SQLiteCore

[zellwepa]

Hey there.

I'm actually trying to build a custome version of the SQLiteCore Plugin, similar to your approch.

I've cloned the Engine Pluging, renamed some stuff (to have clean "new" pluging), updated the sqlite3 source files (https://www.sqlite.org/download.html) and builded the pluging succesfull.

I can include it properly to my project. But when linking the plugin librarys during project build, I got linking errors due to the allready defined functions from the original SQLiteCore binaries (Checkout details below). I have cross-checked your settup but haven't seen any special configurations to exclude the Engine Plugin SQLiteCore when building the project.

Any suggestions or haven't I seen the correct config in your project?

Thanks for help!

Details

1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_fts3_may_be_corrupt already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_fts5_may_be_corrupt already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_version already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_aggregate_context already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_aggregate_count already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_auto_extension already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_backup_finish already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_backup_init already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_backup_pagecount already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_backup_remaining already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_backup_step already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_blob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_blob64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_double already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_int already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_int64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_null already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_parameter_count already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_parameter_index already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_parameter_name already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_pointer already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_text already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_text16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_text64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_value already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_zeroblob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_bind_zeroblob64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_blob_bytes already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_blob_close already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_blob_open already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_blob_read already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_blob_reopen already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_blob_write already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_busy_handler already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_busy_timeout already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_cancel_auto_extension already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_changes already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_clear_bindings already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_close already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_close_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_collation_needed already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_collation_needed16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_blob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_bytes already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_bytes16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_count already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_decltype already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_decltype16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_double already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_int already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_int64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_name already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_name16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_text already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_text16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_type already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_column_value already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_commit_hook already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_compileoption_get already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_compileoption_used already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_complete already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_complete16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_config already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_context_db_handle already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_collation already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_collation16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_collation_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_function already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_function16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_function_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_module already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_module_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_create_window_function already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_data_count already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_cacheflush already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_config already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_filename already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_handle already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_mutex already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_readonly already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_release_memory already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_db_status already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_declare_vtab already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_deserialize already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_drop_modules already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_enable_shared_cache already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_errcode already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_errmsg already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_errmsg16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_errstr already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_exec already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_expanded_sql already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_expired already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_extended_errcode already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_extended_result_codes already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_file_control already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_filename_database already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_filename_journal already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_filename_wal already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_finalize already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_free already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_free_table already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_get_autocommit already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_get_auxdata already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_get_table already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_global_recover already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_hard_heap_limit64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_initialize already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_interrupt already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_keyword_check already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_keyword_count already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_keyword_name already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_last_insert_rowid already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_libversion already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_libversion_number already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_limit already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_log already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_malloc already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_malloc64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_memory_alarm already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_memory_highwater already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_memory_used already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_mprintf already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_msize already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_mutex_alloc already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_mutex_enter already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_mutex_free already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_mutex_leave already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_mutex_try already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_next_stmt already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_open already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_open16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_open_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_overload_function already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_prepare already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_prepare16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_prepare16_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_prepare16_v3 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_prepare_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_prepare_v3 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_profile already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_progress_handler already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_randomness already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_realloc already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_realloc64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_release_memory already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_reset already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_reset_auto_extension already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_blob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_blob64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_double already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_error already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_error16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_error_code already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_error_nomem already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_error_toobig already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_int already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_int64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_null already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_pointer already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_subtype already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_text already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_text16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_text16be already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_text16le already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_text64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_value already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_zeroblob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_result_zeroblob64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_rollback_hook already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_rtree_geometry_callback already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_rtree_query_callback already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_serialize already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_set_authorizer already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_set_auxdata already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_set_last_insert_rowid already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_shutdown already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_sleep already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_snprintf already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_soft_heap_limit already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_soft_heap_limit64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_sourceid already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_sql already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_status already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_status64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_step already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_stmt_busy already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_stmt_isexplain already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_stmt_readonly already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_stmt_status already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_append already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_appendall already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_appendchar already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_appendf already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_errcode already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_finish already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_length already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_new already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_reset already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_value already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_str_vappendf already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_strglob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_stricmp already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_strlike already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_strnicmp already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_system_errno already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_table_column_metadata already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_test_control already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_thread_cleanup already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_threadsafe already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_total_changes already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_trace already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_trace_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_transfer_bindings already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_update_hook already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_uri_boolean already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_uri_int64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_uri_key already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_uri_parameter already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_user_data already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_blob already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_bytes already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_bytes16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_double already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_dup already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_free already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_frombind already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_int already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_int64 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_nochange already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_numeric_type already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_pointer already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_subtype already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_text already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_text16 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_text16be already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_text16le already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_value_type already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vfs_find already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vfs_register already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vfs_unregister already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vmprintf already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vsnprintf already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vtab_collation already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vtab_config already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vtab_nochange already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_vtab_on_conflict already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_wal_autocheckpoint already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_wal_checkpoint already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_wal_checkpoint_v2 already defined in SQLiteEmbedded.c.obj
1>SQLiteEmbedded2.c.obj : error LNK2005: sqlite3_wal_hook already defined in SQLiteEmbedded.c.obj

[zellwepa]

Solved by removing all dependecies to the SQLiteCore Library (there were some implicite dependecys from other plugins used within my project)

[Ysgrathe]

Hi there, sorry I didnt reply sooner, just really saw this...
My understandings of SQLite vs Unreal development have come along a ways since I originally started using them, right now, I see this:

It doesnt matter what you do to it, you cant have multiple SQLite plugins in the same Unreal project.
Because without changing the SQLite library code itself, you would effectively have namespace collisions.
The reason for this is because with unreal plugins, we are (usually) compiling the SQLite ourselves when we build the project
(We get the source from the SQLite developer page, and include it in the SQLiteCore plugin.

So even without the Unreal UClass wrappers over the top, you would not be able you use say, your sqlite plugin, at the same time as the official Epic one.

The only reasons I personally wanted to do something different from Epic, is because their plugin is tied to a really old version of the SQLite library, which doesnt support many of the newer, really useful features.
However, in their plugin, they happily explain how to replace it with the newer version, which is what I did.

But... I still fairly frequently get people contacting me about how they can use my plugin, WITH some other Epic ones that also depend on the Epic version... and I have to keep telling them that they cannot.

SO, for me anyway, the TLDR here is this:
We could precompile SQLite into a DLL, and just reference that in our plugins.
Nothing stopping several versions of SQLite libraries being loaded at once (just not compiled into the same exe)

Or... we could take the Epic sqlite library, and do a little refactoring on it, so that it supported MULTIPLE SQLite versions
Each version is in its own include file, so I feel it wouldnt actually be too difficult to have a #define, which could be configured from the /build.cs file, to either take a default version (the most recent), or to use a specific version if you feel you really need to.

Maybe if we did that, it could be submitted to Epic, and they might accept it for future versions of UE, and everyone would be happy, with no need to make custom versions anymore.

[zellwepa]

Hey, thank you very much for your answer.

This all matches what I found out the hard way.

FYI:
Our intention was to use the standard SQLite library directly via Unreal on the Hololens 2. We wanted to implement this by using the integrated SQLite library from SQLiteCore. Unfortunately, we had various Disk IO problems on the Hololens 2 (but not when tested locally). Because of this, I was looking for an easy way to build the SQLite library (to have also the current SQLite version with all the new features as you have mentioned) myself (in the form of a plugin) without having to compile the entire engine from source (currently we are working with the installer based engine version). For me, your plugin was more of a reference, or rather a sign that it should work :).

The linking errors mentioned here was only a minor problem and could be eliminated by correctly defining the dependencies. Our final solution is a custom SQLite plugin, which is integrated into our Unreal project parallel to the standard SQLiteCore plugin (the SQLiteCore deactivated and is therefore not part of the build chain) and serves as a simple wrapper/integrator for the standard SQLite library.

You can find a more detailed description and solution to this problem here:

• https://forums.unrealengine.com/t/how-can-i-solve-sqlite-ioerr-seek-on-unreal-uwp-application-on-ms-hololens2 /1776136

Thank you very much for your feedback.

Have a nice day