[Asterisk-Users] PHP UnixODBC MS SQl 2000

Derek derek at allinternetadvertising.com
Wed Jun 7 10:25:14 MST 2006


Not that this is particularly an Asterisk problem, but make sure 
unixodbc is listed when you do a phpinfo(); , also, you might want to 
make sure you have extension=unixodbc.so in your php.ini since you're 
compiling it as a shared module.

Hope that helps a little bit.

Wasif wrote:

>Hi,
>
>I have Asterisk 12.7.1 installed through Asterisk at Home CD. and explicitly I
>have installed UnixODBC and FREETDS in order to access MS SQL 2000 Database
>which in on Windows 2003 Server on remote location.
>
>I tested connectivity through isql and tsql, both utilities are working
>fine. 
>
>I need to access MS SQL 2000 Database through PHP. When I tired to check the
>connectivity through a Test PHP file I got following results:
>
>Fatal error: Call to undefined function: odbc_connect() in
>/var/www/html/odbctest.php on line 3
>
>
>By Default PHP was configured with following switches: 
>'./configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu'
>'--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr'
>'--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin'
>'--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include'
>'--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var'
>'--sharedstatedir=/usr/com' '--mandir=/usr/share/man'
>'--infodir=/usr/share/info' '--cache-file=../config.cache'
>'--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d'
>'--enable-force-cgi-redirect' '--disable-debug' '--enable-pic'
>'--disable-rpath' '--enable-inline-optimization' '--with-bz2'
>'--with-db4=/usr' '--with-curl' '--with-exec-dir=/usr/bin'
>'--with-freetype-dir=/usr' '--with-png-dir=/usr' '--with-gd=shared'
>'--enable-gd-native-ttf' '--without-gdbm' '--with-gettext'
>'--with-ncurses=shared' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr'
>'--with-openssl' '--with-png' '--with-pspell' '--with-xml'
>'--with-expat-dir=/usr' '--with-dom=shared,/usr' '--with-dom-xslt=/usr'
>'--with-dom-exslt=/usr' '--with-xmlrpc=shared' '--with-pcre-regex=/usr'
>'--with-zlib' '--with-layout=GNU' '--enable-bcmath' '--enable-exif'
>'--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem'
>'--enable-sysvshm' '--enable-track-vars' '--enable-trans-sid' '--enable-yp'
>'--enable-wddx' '--with-pear=/usr/share/pear' '--with-imap=shared'
>'--with-imap-ssl' '--with-kerberos' '--with-ldap=shared'
>'--with-mysql=shared,/usr' '--with-pgsql=shared' '--with-snmp=shared,/usr'
>'--with-snmp=shared' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr'
>'--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx'
>'--enable-dio' '--enable-mbstring=shared' '--enable-mbstr-enc-trans'
>'--enable-mbregex' '--with-mime-magic=/usr/share/file/magic.mime'
>'--with-apxs2=/usr/sbin/apxs'
>
>
>Please guide me what else should I need to do.
> 
>
>Thanks
>
>Wazb
>
>_______________________________________________
>--Bandwidth and Colocation provided by Easynews.com --
>
>Asterisk-Users mailing list
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>
>!DSPAM:44870975154201497913098!
>
>
>
>  
>

-- 
Derek Fedel
Director of Network Development




More information about the asterisk-users mailing list