Re: help needed: Call to undefined function: mssql_connect()

Hello, I don't use MSSQL so I could be wrong. Anyway, let me try ;) "paula@nervesane.net" <paula@nervesane.net> wrote: > Hi there, > > Hope someone can help me with this. > I need to connect to a MS SQL database but my attemps fail once and > again. > This is the error message I get when try to connect: > > Fatal error: Call to undefined function: mssql_connect() in > /var/www/htdocs/DB_conn.php on line 8 > > The script is very simple: > > <?php > > $hostname = "10.0.0.206:1433"; > $username = "sa"; > $password = ""; > $dbName = "dbname_here"; > > $idLink = mssql_connect($hostname,$username,$password) or die(" > DATABASE > FAILED TO RESPOND."); > mssql_select_db($dbName) or die("Table unavailable"); > > ?> > > Now, this is the info I can provide: > > 1) PHP version 4.3.0-dev > > 2) phpinfo shows: > './configure' > '--prefix=/usr/local' > '--enable-module=so' > '--with-mod_charset' > '--enable-sockets' > '--enable-memory-limit' > '--with-sybase=/usr/local/freetds' Perhaps, because you don't have --with-mssql=/path/ here? <from_the_manual> Installation The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini. To get these functions to work, you have to compile PHP with --with- mssql=[DIR], where DIR is the FreeTDS install prefix. </from_the_manual> > 3) Of course, freetds is located at /usr/local/freetds and works properly. > It was tested using tsql -H -p -U and it's ok. > > 4) I also tried adding #!/usr/local/bin/php to try it as a shell scripting > thing and it WORKS! Which is very confusing. Well, you can actually have two *different* versions of php so it's possible that they were compiled in different ways... - E ...[snip]... __________________________________________________ Do You Yahoo!? Yahoo! BB is Broadband by Yahoo! http://bb.yahoo.co.jp/