Re: [Freeswitch-users] Unable to build FS with odbc support

24 Sep 2008


      you need to install the development package for odbc on your OS before you
can build for ODBC.
This is one of the few dependancy libs we do not build for you.


On Wed, Sep 24, 2008 at 4:12 AM, Woody Dickson <woodydickson@gmail.com>wrote:
...
Hi,
I tried to run "./configure --enable-core-odbc-support" but got the
following error during "make":
Compiling src/switch_pcm.c ...
Compiling libs/libteletone/src/libteletone_detect.c ...
Compiling libs/libteletone/src/libteletone_generate.c ...
Compiling src/switch_odbc.c ...
In file included from src/switch_odbc.c:33:
./src/include/switch_odbc.h:36:17: error: sql.h: No such file or directory
./src/include/switch_odbc.h:43:20: error: sqlext.h: No such file or
directory
./src/include/switch_odbc.h:45:22: error: sqltypes.h: No such file or
directory
In file included from src/switch_odbc.c:33:
./src/include/switch_odbc.h:66: error: expected declaration specifiers or
'...' before 'SQLHSTMT'
./src/include/switch_odbc.h:69: error: expected declaration specifiers or
'...' before 'SQLHSTMT'
src/switch_odbc.c:39: error: expected specifier-qualifier-list before
'SQLHENV'
src/switch_odbc.c: In function 'switch_odbc_handle_new':
src/switch_odbc.c:72: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:72: error: 'SQL_NULL_HANDLE' undeclared (first use in
this function)
src/switch_odbc.c:72: error: (Each undeclared identifier is reported only
once
src/switch_odbc.c:72: error: for each function it appears in.)
src/switch_odbc.c:73: error: 'switch_odbc_handle_t' has no member named
'state'
src/switch_odbc.c: In function 'switch_odbc_handle_disconnect':
src/switch_odbc.c:92: error: 'switch_odbc_handle_t' has no member named
'state'
cc1: warnings being treated as errors
src/switch_odbc.c:93: warning: implicit declaration of function
'SQLDisconnect'
src/switch_odbc.c:93: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:101: error: 'switch_odbc_handle_t' has no member named
'state'
src/switch_odbc.c: In function 'switch_odbc_handle_connect':
src/switch_odbc.c:109: error: 'SQLINTEGER' undeclared (first use in this
function)
src/switch_odbc.c:109: error: expected ';' before 'err'
src/switch_odbc.c:112: error: 'SQLSMALLINT' undeclared (first use in this
function)
src/switch_odbc.c:112: error: expected ';' before 'valueLength'
src/switch_odbc.c:115: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:115: error: 'SQL_NULL_HANDLE' undeclared (first use in
this function)
src/switch_odbc.c:116: warning: implicit declaration of function
'SQLAllocHandle'
src/switch_odbc.c:116: error: 'SQL_HANDLE_ENV' undeclared (first use in
this function)
src/switch_odbc.c:116: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:118: error: 'SQL_SUCCESS' undeclared (first use in this
function)
src/switch_odbc.c:118: error: 'SQL_SUCCESS_WITH_INFO' undeclared (first use
in this function)
src/switch_odbc.c:123: warning: implicit declaration of function
'SQLSetEnvAttr'
src/switch_odbc.c:123: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:123: error: 'SQL_ATTR_ODBC_VERSION' undeclared (first use
in this function)
src/switch_odbc.c:123: error: 'SQL_OV_ODBC3' undeclared (first use in this
function)
src/switch_odbc.c:127: warning: implicit declaration of function
'SQLFreeHandle'
src/switch_odbc.c:127: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:131: error: 'SQL_HANDLE_DBC' undeclared (first use in
this function)
src/switch_odbc.c:131: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:131: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:135: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:138: warning: implicit declaration of function
'SQLSetConnectAttr'
src/switch_odbc.c:138: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:138: error: 'SQL_LOGIN_TIMEOUT' undeclared (first use in
this function)
src/switch_odbc.c:138: error: 'SQLPOINTER' undeclared (first use in this
function)
src/switch_odbc.c:138: error: expected expression before ')' token
src/switch_odbc.c:140: error: 'switch_odbc_handle_t' has no member named
'state'
src/switch_odbc.c:148: warning: implicit declaration of function
'SQLConnect'
src/switch_odbc.c:148: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:148: error: 'SQLCHAR' undeclared (first use in this
function)
src/switch_odbc.c:148: error: expected expression before ')' token
src/switch_odbc.c:150: error: expected ';' before 'outstr'
src/switch_odbc.c:151: error: expected ';' before 'outstrlen'
src/switch_odbc.c:153: warning: implicit declaration of function
'SQLDriverConnect'
src/switch_odbc.c:153: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:153: error: expected expression before ')' token
src/switch_odbc.c:159: error: too many arguments to function
'switch_odbc_handle_get_error'
src/switch_odbc.c:163: warning: implicit declaration of function
'SQLGetDiagRec'
src/switch_odbc.c:163: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:163: error: 'err' undeclared (first use in this function)
src/switch_odbc.c:166: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:170: warning: implicit declaration of function
'SQLGetInfo'
src/switch_odbc.c:170: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:170: error: 'SQL_DRIVER_NAME' undeclared (first use in
this function)
src/switch_odbc.c:170: error: expected expression before ')' token
src/switch_odbc.c:172: error: 'valueLength' undeclared (first use in this
function)
src/switch_odbc.c:173: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:173: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:173: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:173: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:173: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:173: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:176: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:176: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:176: error: 'switch_odbc_handle_t' has no member named
'odbc_driver'
src/switch_odbc.c:177: error: 'switch_odbc_handle_t' has no member named
'is_firebird'
src/switch_odbc.c:179: error: 'switch_odbc_handle_t' has no member named
'is_firebird'
src/switch_odbc.c:183: error: 'switch_odbc_handle_t' has no member named
'state'
src/switch_odbc.c: In function 'db_is_up':
src/switch_odbc.c:190: error: 'SQLHSTMT' undeclared (first use in this
function)
src/switch_odbc.c:190: error: expected ';' before 'stmt'
src/switch_odbc.c:191: error: 'SQLLEN' undeclared (first use in this
function)
src/switch_odbc.c:191: error: expected ';' before 'm'
src/switch_odbc.c:196: error: 'SQLCHAR' undeclared (first use in this
function)
src/switch_odbc.c:196: error: expected ';' before 'sql'
src/switch_odbc.c:199: error: 'SQLRETURN' undeclared (first use in this
function)
src/switch_odbc.c:199: error: expected ';' before 'rc'
src/switch_odbc.c:200: error: 'SQLSMALLINT' undeclared (first use in this
function)
src/switch_odbc.c:200: error: expected ';' before 'nresultcols'
src/switch_odbc.c:209: error: 'switch_odbc_handle_t' has no member named
'is_firebird'
src/switch_odbc.c:210: error: 'sql' undeclared (first use in this function)
src/switch_odbc.c:215: error: 'SQL_HANDLE_STMT' undeclared (first use in
this function)
src/switch_odbc.c:215: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:215: error: 'stmt' undeclared (first use in this
function)
src/switch_odbc.c:215: error: 'SQL_SUCCESS' undeclared (first use in this
function)
src/switch_odbc.c:219: warning: implicit declaration of function
'SQLPrepare'
src/switch_odbc.c:219: error: 'SQL_NTS' undeclared (first use in this
function)
src/switch_odbc.c:223: warning: implicit declaration of function
'SQLExecute'
src/switch_odbc.c:225: warning: implicit declaration of function
'SQLRowCount'
src/switch_odbc.c:225: error: 'm' undeclared (first use in this function)
src/switch_odbc.c:226: error: 'rc' undeclared (first use in this function)
src/switch_odbc.c:226: warning: implicit declaration of function
'SQLNumResultCols'
src/switch_odbc.c:226: error: 'nresultcols' undeclared (first use in this
function)
src/switch_odbc.c:240: error: too many arguments to function
'switch_odbc_handle_get_error'
src/switch_odbc.c: At top level:
src/switch_odbc.c:285: error: expected declaration specifiers or '...'
before 'SQLHSTMT'
src/switch_odbc.c: In function 'switch_odbc_handle_exec':
src/switch_odbc.c:287: error: 'SQLHSTMT' undeclared (first use in this
function)
src/switch_odbc.c:287: error: expected ';' before 'stmt'
src/switch_odbc.c:294: error: 'SQL_HANDLE_STMT' undeclared (first use in
this function)
src/switch_odbc.c:294: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:294: error: 'stmt' undeclared (first use in this
function)
src/switch_odbc.c:294: error: 'SQL_SUCCESS' undeclared (first use in this
function)
src/switch_odbc.c:298: error: 'SQL_NTS' undeclared (first use in this
function)
src/switch_odbc.c:304: error: 'SQL_SUCCESS_WITH_INFO' undeclared (first use
in this function)
src/switch_odbc.c:308: error: 'rstmt' undeclared (first use in this
function)
src/switch_odbc.c: In function 'switch_odbc_handle_callback_exec':
src/switch_odbc.c:328: error: 'SQLHSTMT' undeclared (first use in this
function)
src/switch_odbc.c:328: error: expected ';' before 'stmt'
src/switch_odbc.c:329: error: 'SQLSMALLINT' undeclared (first use in this
function)
src/switch_odbc.c:329: error: expected ';' before 'c'
src/switch_odbc.c:330: error: 'SQLLEN' undeclared (first use in this
function)
src/switch_odbc.c:330: error: expected ';' before 'm'
src/switch_odbc.c:339: error: 'SQL_HANDLE_STMT' undeclared (first use in
this function)
src/switch_odbc.c:339: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:339: error: 'stmt' undeclared (first use in this
function)
src/switch_odbc.c:339: error: 'SQL_SUCCESS' undeclared (first use in this
function)
src/switch_odbc.c:343: error: 'SQL_NTS' undeclared (first use in this
function)
src/switch_odbc.c:349: error: 'SQL_SUCCESS_WITH_INFO' undeclared (first use
in this function)
src/switch_odbc.c:353: error: 'c' undeclared (first use in this function)
src/switch_odbc.c:354: error: 'm' undeclared (first use in this function)
src/switch_odbc.c:357: error: 't' undeclared (first use in this function)
src/switch_odbc.c:363: warning: implicit declaration of function 'SQLFetch'
src/switch_odbc.c:372: error: 'x' undeclared (first use in this function)
src/switch_odbc.c:373: error: expected ';' before 'NameLength'
src/switch_odbc.c:374: error: 'SQLULEN' undeclared (first use in this
function)
src/switch_odbc.c:374: error: expected ';' before 'ColumnSize'
src/switch_odbc.c:378: warning: implicit declaration of function
'SQLDescribeCol'
src/switch_odbc.c:378: error: 'SQLCHAR' undeclared (first use in this
function)
src/switch_odbc.c:378: error: expected expression before ')' token
src/switch_odbc.c:379: error: 'ColumnSize' undeclared (first use in this
function)
src/switch_odbc.c:383: warning: implicit declaration of function
'SQLGetData'
src/switch_odbc.c:383: error: 'SQL_C_CHAR' undeclared (first use in this
function)
src/switch_odbc.c:383: error: expected expression before ')' token
src/switch_odbc.c: In function 'switch_odbc_handle_destroy':
src/switch_odbc.c:424: error: 'SQL_HANDLE_DBC' undeclared (first use in
this function)
src/switch_odbc.c:424: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:425: error: 'SQL_HANDLE_ENV' undeclared (first use in
this function)
src/switch_odbc.c:425: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c: In function 'switch_odbc_handle_get_state':
src/switch_odbc.c:436: error: 'switch_odbc_handle_t' has no member named
'state'
src/switch_odbc.c: At top level:
src/switch_odbc.c:439: error: expected declaration specifiers or '...'
before 'SQLHSTMT'
src/switch_odbc.c: In function 'switch_odbc_handle_get_error':
src/switch_odbc.c:441: error: 'SQL_MAX_MESSAGE_LENGTH' undeclared (first
use in this function)
src/switch_odbc.c:442: error: 'SQL_SQLSTATE_SIZE' undeclared (first use in
this function)
src/switch_odbc.c:443: error: 'SQLINTEGER' undeclared (first use in this
function)
src/switch_odbc.c:443: error: expected ';' before 'sqlcode'
src/switch_odbc.c:444: error: 'SQLSMALLINT' undeclared (first use in this
function)
src/switch_odbc.c:444: error: expected ';' before 'length'
src/switch_odbc.c:447: warning: implicit declaration of function 'SQLError'
src/switch_odbc.c:447: error: 'switch_odbc_handle_t' has no member named
'env'
src/switch_odbc.c:447: error: 'switch_odbc_handle_t' has no member named
'con'
src/switch_odbc.c:447: error: 'stmt' undeclared (first use in this
function)
src/switch_odbc.c:447: error: 'SQLCHAR' undeclared (first use in this
function)
src/switch_odbc.c:447: error: expected expression before ')' token
src/switch_odbc.c:447: error: 'SQL_SUCCESS' undeclared (first use in this
function)
src/switch_odbc.c:448: error: 'sqlcode' undeclared (first use in this
function)
src/switch_odbc.c:442: warning: unused variable 'sqlstate'
src/switch_odbc.c:441: warning: unused variable 'buffer'
make[2]: *** [libfreeswitch_la-switch_odbc.lo] Error 1
Making all in src
Making all in mod
making all mod_amr
make[5]: *** No rule to make target `/usr/src/freeswitch/libfreeswitch.la',
needed by `mod_amr.so'.  Stop.
make[4]: *** [all] Error 1
make[3]: *** [mod_amr-all] Error 1
make[2]: *** [all-recursive] Error 1
Making all in build
 +-------- FreeSWITCH Build Complete -----------+
 + FreeSWITCH has been successfully built.      +
 + Install by running:                          +
 +                                              +
 +              make install                    +
 +----------------------------------------------+
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2
I am running on Centos and odbc is already installed.
Could someone give me idea about what could be the problem?
Thanks,
Woody
_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-- 
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/

AIM: anthm
MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com>
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com>
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org>
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org>
pstn:213-799-1400