NYCPHP Meetup

[Ajai Khattri]

Rafi Sheikh wrote:

>Has any one tried to compile FreeTDS for use with PHP (4.3.4 in our case on
>AIX 5.1) to connect with MSSQL?  If yes, would you be so kind as to give us
>some guidance, our compiles are failing miserably 
>
>I am listing the error below:
>
>-----------ERROR LISTING-----------------
>gcc -g -O2 -o .libs/tsql tsql.o  -lcurses -L../tds/.libs -ltds -liconv -lc
>-Wl,-blibpath:/usr/local/lib:/usr/bin/../lib/gcc-lib/powerpc-ibm-aix5.1.0.0/
>2.9-aix51-020209:/usr/bin/../lib/gcc-lib:/opt/freeware/GNUPro/lib/gcc-lib/po
>werpc-ibm-aix5.1.0.0/2.9-aix51-020209:/usr/bin/../lib/gcc-lib/powerpc-ibm-ai
>x5.1.0.0/2.9-aix51-020209/../../..:/opt/freeware/GNUPro/lib/gcc-lib/powerpc-
>ibm-aix5.1.0.0/2.9-aix51-020209/../../..:/usr/lib:/lib
>ld: 0711-317 ERROR: Undefined symbol: .tds_submit_query
>ld: 0711-317 ERROR: Undefined symbol: .tds_get_null
>ld: 0711-317 ERROR: Undefined symbol: .tds_get_conversion_type
>ld: 0711-317 ERROR: Undefined symbol: .tds_convert
>ld: 0711-317 ERROR: Undefined symbol: .tds_process_row_tokens
>ld: 0711-317 ERROR: Undefined symbol: .tds_version
>ld: 0711-317 ERROR: Undefined symbol: .tds_client_msg
>ld: 0711-317 ERROR: Undefined symbol: .tds_process_result_tokens
>ld: 0711-317 ERROR: Undefined symbol: .tds_get_compiletime_settings
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_user
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_app
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_library
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_server
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_client_charset
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_language
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_passwd
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_interfaces_file_loc
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_port
>ld: 0711-317 ERROR: Undefined symbol: .tds_alloc_login
>ld: 0711-317 ERROR: Undefined symbol: .tds_alloc_context
>ld: 0711-317 ERROR: Undefined symbol: .tds_alloc_socket
>ld: 0711-317 ERROR: Undefined symbol: .tds_set_parent
>ld: 0711-317 ERROR: Undefined symbol: .tds_read_config_info
>ld: 0711-317 ERROR: Undefined symbol: .tds_connect
>ld: 0711-317 ERROR: Undefined symbol: .tds_free_connection
>ld: 0711-317 ERROR: Undefined symbol: .tds_free_socket
>ld: 0711-317 ERROR: Undefined symbol: .tds_free_login
>ld: 0711-317 ERROR: Undefined symbol: .tds_free_context
>ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more
>information.
>collect2: ld returned 8 exit status
>make: 1254-004 The error code from the last command is 1.
>
This is clearly a linkage problem. You may want to try specifying where 
your freetds libraries are - you can do that through configure options 
(run "./configure --help" to see all options) or by editing the Makefile 
and adding a -L flag to the compile lines.

-- 
Aj.
Systems Administrator / Developer