facing issues in compilation of odbc (trunk,5.2,3.51) on visual studio (2005,2012) on windows (xp,7,2000 server)

[shashank gupta]

Hi all,

I was compiling odbc source code on windows, but I am facing lots of issues. I have been trying for last 5 days but was unable to resolve. Please someone help me with this issue.

I have tried all permutations of (odbc (trunk,5.2,3.51) on visual studio (2005,2012) on windows (xp,7,2000 server)), but errors were same.

Here I am explaning errors on windows 7 with visual studio 2012 on odbc source code (trunk and 5.2)


Error :
Error 76 error LNK1118: syntax error in 'VERSION' statement C:\Users\sgupta\Desktop\odbc_trunk\myodbc\driver\driver.def 26 1 myodbc5
Error 56 error LNK1120: 5 unresolved externals C:\Users\sgupta\Desktop\odbc_trunk\myodbc\bin\Debug\myodbc-installer.exe 1 1 myodbc-installer
Error 74 error LNK1120: 8 unresolved externals C:\Users\sgupta\Desktop\odbc_trunk\myodbc\lib\Debug\myodbc5S.dll myodbc5S
Error 51 error LNK2001: unresolved external symbol _default_charset_info C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3i.obj myodbc-installer
Error 55 error LNK2001: unresolved external symbol _my_free C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3u.lib(stringutil.obj) myodbc-installer
Error 61 error LNK2001: unresolved external symbol _my_free C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\odbcdialogparams.cpp.obj myodbc5S
Error 62 error LNK2001: unresolved external symbol _my_free C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\myodbc3u.lib(installer.obj) myodbc5S
Error 63 error LNK2001: unresolved external symbol _my_free C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\myodbc3u.lib(stringutil.obj) myodbc5S
Error 53 error LNK2001: unresolved external symbol _my_malloc C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3u.lib(stringutil.obj) myodbc-installer
Error 65 error LNK2001: unresolved external symbol _my_malloc C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\odbcdialogparams.cpp.obj myodbc5S
Error 66 error LNK2001: unresolved external symbol _my_malloc C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\myodbc3u.lib(installer.obj) myodbc5S
Error 67 error LNK2001: unresolved external symbol _my_malloc C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\myodbc3u.lib(stringutil.obj) myodbc5S
Error 50 error LNK2019: unresolved external symbol _get_charset_by_csname referenced in function _main C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3i.obj myodbc-installer
Error 68 error LNK2019: unresolved external symbol _list_cons referenced in function _mygetdatabases C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\callbacks.obj myodbc5S
Error 72 error LNK2019: unresolved external symbol _list_free referenced in function "void __cdecl processDbCombobox(struct HWND__ *,struct HWND__ *,unsigned int)" (?processDbCombobox@@YAXPAUHWND__@@0I@Z) C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\odbcdialogparams.cpp.obj myodbc5S
Error 73 error LNK2019: unresolved external symbol _list_length referenced in function "void __cdecl processDbCombobox(struct HWND__ *,struct HWND__ *,unsigned int)" (?processDbCombobox@@YAXPAUHWND__@@0I@Z) C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\odbcdialogparams.cpp.obj myodbc5S
Error 69 error LNK2019: unresolved external symbol _list_reverse referenced in function _mygetdatabases C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\callbacks.obj myodbc5S
Error 71 error LNK2019: unresolved external symbol _my_end referenced in function _DllMain@12 C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\main.obj myodbc5S
Error 60 error LNK2019: unresolved external symbol _my_free referenced in function _ConfigDSNW@16 C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\ConfigDSN.obj myodbc5S
Error 54 error LNK2019: unresolved external symbol _my_free referenced in function _driver_new C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3u.lib(installer.obj) myodbc-installer
Error 70 error LNK2019: unresolved external symbol _my_init referenced in function _DllMain@12 C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\main.obj myodbc5S
Error 49 error LNK2019: unresolved external symbol _my_init referenced in function _main C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3i.obj myodbc-installer
Error 52 error LNK2019: unresolved external symbol _my_malloc referenced in function _driver_new C:\Users\sgupta\Desktop\odbc_trunk\myodbc\installer\myodbc3u.lib(installer.obj) myodbc-installer
Error 64 error LNK2019: unresolved external symbol _my_malloc referenced in function _mytest C:\Users\sgupta\Desktop\odbc_trunk\myodbc\setupgui\callbacks.obj myodbc5S


Environment variables set:
MYSQL_INCLUDE_DIR C:\Program Files\MySQL\MySQL Server 5.6\include
MYSQL_LIB_DIR C:\Program Files\MySQL\MySQL Server 5.6\lib
MYSQL_DIR C:\Program Files\MySQL\MySQL Server 5.6

CMAKE OUTPUT :

C:\Users\sgupta\Desktop\odbc_trunk\myodbc>cmake -G "Visual Studio 11 2012"
-- The C compiler identification is MSVC 17.0.50727.1
-- The CXX compiler identification is MSVC 17.0.50727.1
-- Check for working C compiler using: Visual Studio 11 2012
-- Check for working C compiler using: Visual Studio 11 2012 -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler using: Visual Studio 11 2012
-- Check for working CXX compiler using: Visual Studio 11 2012 -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- ENV{MYSQL_DIR} = C:\Program Files\MySQL\MySQL Server 5.6
-- MySQL Include dir: C:/Program Files/MySQL/MySQL Server 5.6/include
-- MySQL Library : C:/Program Files/MySQL/MySQL Server 5.6/lib/mysqlclient.l
b
-- MySQL Library dir: C:/Program Files/MySQL/MySQL Server 5.6/lib
-- MySQL CXXFLAGS:
-- MySQL Link flags:
-- MySQL Include dir: C:/Program Files/MySQL/MySQL Server 5.6/include
-- MySQL Library dir: C:/Program Files/MySQL/MySQL Server 5.6/lib
-- MySQL CXXFLAGS:
-- MySQL Link flags:
-- ODBC Installation Library: odbccp32
-- Checking if SQLColAttribute last arg is compatible with SQLLEN* - FALSE
-- Checking if SQLColAttribute last arg is compatible with SQLPOINTER - FALSE
-- Checking if SQLParamOptions() 2nd and 3rd arg is compatible with SQLULEN - F
LSE
-- Checking if SQLParamOptions() 2nd and 3rd arg is compatible with SQLUINTEGER
- FALSE
-- Apparently odbc headers could not be found. 2nd and 3rd parameters assumed t
be (*)SQLULEN by default
-- Enabling threads support
-- MySQL client lib(version 50620) requires Secure32.lib - TRUE
CMake Warning (dev) at driver/CMakeLists.txt:83 (GET_TARGET_PROPERTY):
Policy CMP0026 is not set: Disallow use of the LOCATION target property.
Run "cmake --help-policy CMP0026" for policy details. Use the cmake_policy
command to set the policy and suppress this warning.

The LOCATION property should not be read from target "myodbc5". Use the
target name directly with add_custom_command, or use the generator
expression $<TARGET_FILE>, as appropriate.

This warning is for project developers. Use -Wno-dev to suppress it.

-- Configuring done
-- Generating done
-- Build files have been written to: C:/Users/sgupta/Desktop/odbc_trunk/myodbc

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

It will be really helpful if someone can let me know how to resolve this issue.

Regards
shashank