Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 23 Jun 1999 15:57:11 +0100
From:      "Peter McGarvey" <Networks.Manager@rncm.ac.uk>
To:        <freebsd-questions@freebsd.org>
Subject:   Apache, PHP and OpenLink's ODBC Drivers.
Message-ID:  <000201bebd88$ac874260$24603fc1@brick.it-dept.rncm.ac.uk>

next in thread | raw e-mail | index | archive | help
For the last few weeks I've been trying to work out how to connect my
Webserver to a Microsoft SQL Server.  I thought I had it but I was wrong.

The SQL Server is version 6.5 running on NT 4.0.  My Webserver is
Apache/1.3.6 with PHP/3.0.7 running on 3.2-STABLE.  Now, someone somewhere
told me that the OpenLink ODBC Drivers were what I was looking for.  I've
gotten the drivers working on the NT machine.  It's the FreeBSD bit that's
causing me problems.

I don't seem to be able to re-compile Apache with PHP with support for the
OpenLink Driver.

I downloaded the BSDI2 version of the OpenLink Driver and installed it....

I re-ran configure for PHP, including the line
	--with-openlink=/OpenLinkDIR/
that worked.  I ran make, that worked.  I ran make install, that worked.

I changed to the Apache directory, re-ran configure, and that worked.  Then
I ran make - it broke.  It started moaning about undefined references to
this, and undefined references to that (anyone with the slightest bit of
interest in the actual messages need only look beyond my sig).

So now I'm completely lost - out of my depth - totally without a clue - and
plain fed-up.

If anyone has actually gotten OpenLink stuff to work can they give me some
help as to how to do it?

TTFN, FNORD

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 Peter McGarvey, Networks Manager  |  email: Networks.Manager@rncm.ac.uk
 Royal Northern College of Music   |    tel: +44 (0)161 907 5218
 124 Oxford Road, Manchester,      |    fax: +44 (0)161 273 7611
     England M13 9RD               | mobile: +44 (0)7887 990564
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


gcc  -funsigned-char -DMOD_PERL -DUSE_PERL_SSI  -DUSE_HSREGEX
paci`     -o httpd buildmark.o modules.o  modules/standard/libstandard.a
modules/php3/libphp3.a  modules/perl/libperl.a  main/libmain.a
./os/unix/libos.a  ap/libap.a
regex/libregex.a  -Lmodules/php3 -L../modules/php3 -L../../modules/php3 -lmo
dphp3         -R/usr/local/lib/mysql -L/usr/local/lib/mysql -lmysqlclient   
        -L/usr/local/lib -lgd                  -lpam -lm -lcrypt   -lcrypt  
  -Wl,-E
/usr/libdata/perl/5.00503/mach/auto/DynaLoader/DynaLoader.a -L/usr/libdata/p
erl/5.00503/mach/CORE -lperl -lm -lc -lcrypt -lperl
modules/php3/libphp3.a(unified_odbc.o): In function `_free_result':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x5c): undefined reference
to `SQLFreeStmt'
modules/php3/libphp3.a(unified_odbc.o): In function `_results_cleanup':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x9e): undefined reference
to `SQLFreeStmt'
modules/php3/libphp3.a(unified_odbc.o): In function `_close_connection':
/usr2/_inst/php3/functions/unified_odbc.c:228: undefined reference to
`SQLDisconnect'
/usr2/_inst/php3/functions/unified_odbc.c:229: undefined reference to
`SQLFreeConnect'
modules/php3/libphp3.a(unified_odbc.o): In function `_close_pconnection':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x115): undefined reference
to `SQLDisconnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x11c): undefined reference
to `SQLFreeConnect'
modules/php3/libphp3.a(unified_odbc.o): In function `php3i_odbc_minit':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x145): undefined reference
to `SQLAllocEnv'
modules/php3/libphp3.a(unified_odbc.o): In function `php3i_odbc_mshutdown':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x30e): undefined reference
to `SQLFreeEnv'
modules/php3/libphp3.a(unified_odbc.o): In function `php3i_odbc_sql_error':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x4ba): undefined reference
to `SQLError'
modules/php3/libphp3.a(unified_odbc.o): In function `php3i_odbc_bindcols':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x676): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x6c5): undefined reference
to `SQLColAttributes'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x6de): undefined reference
to `SQLColAttributes'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x719): undefined reference
to `SQLColAttributes'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x74a): undefined reference
to `SQLBindCol'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_prepare':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x806): undefined reference
to `SQLAllocStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x848): undefined reference
to `SQLPrepare'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x867): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x877): undefined reference
to `SQLNumParams'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x882): undefined reference
to `SQLNumResultCols'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_execute':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xa55): undefined reference
to `SQLDescribeParam'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xabc): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xb4c): undefined reference
to `SQLBindParameter'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xb70): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xb96): undefined reference
to `SQLExecute'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xbc2): undefined reference
to `SQLParamData'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xbf5): undefined reference
to `SQLPutData'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xc19): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xc31): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xc8d): undefined reference
to `SQLFreeStmt'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_cursor':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xd5d): undefined reference
to `SQLGetInfo'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xda6): undefined reference
to `SQLGetCursorName'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xde8): undefined reference
to `SQLError'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xe16): undefined reference
to `SQLSetCursorName'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_exec':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xf34): undefined reference
to `SQLAllocStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xf7d): undefined reference
to `SQLGetInfo'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xf9b): undefined reference
to `SQLSetStmtOption'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xfbb): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xfd3): undefined reference
to `SQLExecDirect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0xff3): undefined reference
to `SQLFreeStmt'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1003): undefined reference
to `SQLNumResultCols'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_fetch_into':
/usr2/_inst/php3/functions/unified_odbc.c:1150: undefined reference to
`SQLExtendedFetch'
/usr2/_inst/php3/functions/unified_odbc.c:1154: undefined reference to
`SQLFetch'
/usr2/_inst/php3/functions/unified_odbc.c:1188: undefined reference to
`SQLGetData'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_fetch_row':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x13f3): undefined reference
to `SQLExtendedFetch'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x13ff): undefined reference
to `SQLFetch'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_result':
/usr2/_inst/php3/functions/unified_odbc.c:1396: undefined reference to
`SQLExtendedFetch'
/usr2/_inst/php3/functions/unified_odbc.c:1399: undefined reference to
`SQLFetch'
/usr2/_inst/php3/functions/unified_odbc.c:1421: undefined reference to
`SQLColAttributes'
/usr2/_inst/php3/functions/unified_odbc.c:1436: undefined reference to
`SQLGetData'
/usr2/_inst/php3/functions/unified_odbc.c:1483: undefined reference to
`SQLGetData'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_result_all':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x18e5): undefined reference
to `SQLExtendedFetch'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x18f3): undefined reference
to `SQLFetch'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1a82): undefined reference
to `SQLGetData'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1b36): undefined reference
to `SQLExtendedFetch'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1b47): undefined reference
to `SQLFetch'
modules/php3/libphp3.a(unified_odbc.o): In function
`php3i_odbc__do_connect':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1e88): undefined reference
to `SQLAllocConnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1eae): undefined reference
to `SQLDriverConnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1ecc): undefined reference
to `SQLFreeConnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1f59): undefined reference
to `SQLDisconnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1f60): undefined reference
to `SQLFreeConnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1fd0): undefined reference
to `SQLDisconnect'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x1fd7): undefined reference
to `SQLFreeConnect'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_num_rows':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x2143): undefined reference
to `SQLRowCount'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_field_type':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x2329): undefined reference
to `SQLColAttributes'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_field_len':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x23f3): undefined reference
to `SQLColAttributes'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_autocommit':
/usr2/_inst/php3/functions/unified_odbc.c:2206: undefined reference to
`SQLSetConnectOption'
/usr2/_inst/php3/functions/unified_odbc.c:2217: undefined reference to
`SQLGetConnectOption'
modules/php3/libphp3.a(unified_odbc.o): In function
`php3i_odbc__do_transact':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x264d): undefined reference
to `SQLTransact'
modules/php3/libphp3.a(unified_odbc.o): In function `php3_odbc_setoption':
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x2752): undefined reference
to `SQLSetConnectOption'
/usr2/_inst/php3/functions/unified_odbc.c(.text+0x2796): undefined reference
to `SQLSetStmtOption'
*** Error code 1

Stop.
*** Error code 1

Stop.
*** Error code 1

Stop.



To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?000201bebd88$ac874260$24603fc1>