[SOLVED] v1.2.4 - Voicemail ODBC Compile Error


#1

I have been using Voicemail ODBC in the past. But with v1.2.4 I am getting an error at compile after following the directions here:

voip-info.org/wiki/view/Aste … BC+storage

Anyone else having problems?

app_voicemail.c: In function ‘retrieve_file’: app_voicemail.c:803: error: ‘SQLSMALLINT’ undeclared (first use in this function ) app_voicemail.c:803: error: (Each undeclared identifier is reported only once app_voicemail.c:803: error: for each function it appears in.) app_voicemail.c:803: error: syntax error before ‘colcount’ app_voicemail.c:804: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:809: error: syntax error before ‘collen’ app_voicemail.c:813: error: ‘SQLULEN’ undeclared (first use in this function) app_voicemail.c:837: warning: implicit declaration of function ‘SQLAllocHandle’ app_voicemail.c:837: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this func tion) app_voicemail.c:837: error: dereferencing pointer to incomplete type app_voicemail.c:838: error: ‘SQL_SUCCESS’ undeclared (first use in this function ) app_voicemail.c:838: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in thi s function) app_voicemail.c:843: warning: implicit declaration of function ‘SQLPrepare’ app_voicemail.c:843: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:846: warning: implicit declaration of function ‘SQLFreeHandle’ app_voicemail.c:849: warning: implicit declaration of function ‘SQLBindParameter ’ app_voicemail.c:849: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this func tion) app_voicemail.c:849: error: ‘SQL_C_CHAR’ undeclared (first use in this function) app_voicemail.c:849: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c:857: warning: implicit declaration of function ‘SQLFetch’ app_voicemail.c:858: error: ‘SQL_NO_DATA’ undeclared (first use in this function ) app_voicemail.c:873: warning: implicit declaration of function ‘SQLNumResultCols ’ app_voicemail.c:873: error: ‘colcount’ undeclared (first use in this function) app_voicemail.c:883: error: ‘collen’ undeclared (first use in this function) app_voicemail.c:884: warning: implicit declaration of function ‘SQLDescribeCol’ app_voicemail.c:885: error: ‘datatype’ undeclared (first use in this function) app_voicemail.c:885: error: ‘colsize’ undeclared (first use in this function) app_voicemail.c:885: error: ‘decimaldigits’ undeclared (first use in this functi on) app_voicemail.c:885: error: ‘nullable’ undeclared (first use in this function) app_voicemail.c:892: warning: implicit declaration of function ‘SQLGetData’ app_voicemail.c:892: error: ‘SQL_BINARY’ undeclared (first use in this function) app_voicemail.c: In function ‘last_message_index’: app_voicemail.c:959: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:959: error: syntax error before ‘stmt’ app_voicemail.c:966: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this func tion) app_voicemail.c:966: error: dereferencing pointer to incomplete type app_voicemail.c:967: error: ‘SQL_SUCCESS’ undeclared (first use in this function ) app_voicemail.c:967: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in thi s function) app_voicemail.c:972: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:978: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this func tion) app_voicemail.c:978: error: ‘SQL_C_CHAR’ undeclared (first use in this function) app_voicemail.c:978: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c: In function ‘message_exists’: app_voicemail.c:1010: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:1010: error: syntax error before ‘stmt’ app_voicemail.c:1019: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:1019: error: dereferencing pointer to incomplete type app_voicemail.c:1020: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:1020: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:1025: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:1031: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this fun ction) app_voicemail.c:1031: error: ‘SQL_C_CHAR’ undeclared (first use in this function ) app_voicemail.c:1031: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c: In function ‘delete_file’: app_voicemail.c:1068: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:1068: error: syntax error before ‘stmt’ app_voicemail.c:1076: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:1076: error: dereferencing pointer to incomplete type app_voicemail.c:1077: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:1077: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:1082: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:1088: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this fun ction) app_voicemail.c:1088: error: ‘SQL_C_CHAR’ undeclared (first use in this function ) app_voicemail.c:1088: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c: In function ‘copy_file’: app_voicemail.c:1106: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:1106: error: syntax error before ‘stmt’ app_voicemail.c:1117: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:1117: error: dereferencing pointer to incomplete type app_voicemail.c:1118: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:1118: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:1127: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:1133: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this fun ction) app_voicemail.c:1133: error: ‘SQL_C_CHAR’ undeclared (first use in this function ) app_voicemail.c:1133: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c: In function ‘store_file’: app_voicemail.c:1164: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:1164: error: syntax error before ‘stmt’ app_voicemail.c:1165: error: ‘SQLINTEGER’ undeclared (first use in this function ) app_voicemail.c:1221: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:1221: error: dereferencing pointer to incomplete type app_voicemail.c:1222: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:1222: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:1238: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:1244: error: ‘len’ undeclared (first use in this function) app_voicemail.c:1245: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this fun ction) app_voicemail.c:1245: error: ‘SQL_C_CHAR’ undeclared (first use in this function ) app_voicemail.c:1245: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c:1247: error: ‘SQL_C_BINARY’ undeclared (first use in this functi on) app_voicemail.c:1247: error: ‘SQL_BINARY’ undeclared (first use in this function ) app_voicemail.c: In function ‘rename_file’: app_voicemail.c:1284: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:1284: error: syntax error before ‘stmt’ app_voicemail.c:1295: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:1295: error: dereferencing pointer to incomplete type app_voicemail.c:1296: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:1296: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:1305: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:1311: error: ‘SQL_PARAM_INPUT’ undeclared (first use in this fun ction) app_voicemail.c:1311: error: ‘SQL_C_CHAR’ undeclared (first use in this function ) app_voicemail.c:1311: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c: In function ‘messagecount’: app_voicemail.c:1977: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:1977: error: syntax error before ‘stmt’ app_voicemail.c:2003: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:2003: error: dereferencing pointer to incomplete type app_voicemail.c:2004: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:2004: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:2009: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:2027: error: ‘SQL_CHAR’ undeclared (first use in this function) app_voicemail.c:2036: error: dereferencing pointer to incomplete type app_voicemail.c: In function ‘has_voicemail’: app_voicemail.c:2080: error: ‘SQLHSTMT’ undeclared (first use in this function) app_voicemail.c:2080: error: syntax error before ‘stmt’ app_voicemail.c:2103: error: ‘SQL_HANDLE_STMT’ undeclared (first use in this fun ction) app_voicemail.c:2103: error: dereferencing pointer to incomplete type app_voicemail.c:2104: error: ‘SQL_SUCCESS’ undeclared (first use in this functio n) app_voicemail.c:2104: error: ‘SQL_SUCCESS_WITH_INFO’ undeclared (first use in th is function) app_voicemail.c:2109: error: ‘SQL_NTS’ undeclared (first use in this function) app_voicemail.c:2127: error: ‘SQL_CHAR’ undeclared (first use in this function) make[1]: *** [app_voicemail.o] Error 1 make[1]: Leaving directory `/usr/src/asterisk-1.2.4/apps' make: *** [subdirs] Error 1

UPDATE

I only had the UnixODBC app installed and not the devel libraries required for compilation. I updated the wiki to make this more clear.