connecting php and mssql using ADODB

[meenakshidhar]

I have Freetds installed on my linux box and php 4.4.3-6
My code is given below...
<?
include('adodb/adodb.inc.php');

$db = ADONewConnection('odbc_mssql');
$dsn = &quot;Driver={SQL Server};Server=serverip;Database=dbname;&quot;;
$db->Connect($dsn,'username','password');

$rs = $db->Execute('select * from tablename');
$a = $rs->Fields(0);
echo $a;
$rs->Close();
?>

i m not getting blank page without any error....i don't know where i m wrong....plss help me out...

Regards
Meenakshi Dhar

 

[sleipnir214]

If you have FreeTDS installed, and PHP compiled to support MSSQL connectivity, you don't use ADODB connectivity. You use PHP's builtin MSSQL family of functions:

http://www.php.net/manual/en/ref.mssql.php

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[meenakshidhar]

i think there is some problem in installation...now i have a fresh system...plss tell me which version of linux, php-mysql,php-mssql, freetds should i installed...
the only version i found of php-mssql is php-mssql-4.3.4-4.i386.rpm & that of freetds is freetds 0.61...
and what all packages should i select during installation of linux...i am planning to insall Red Hat Linux 9.0 now...

this is very urgent...

Regards
Meenakshi Dhar

 

[sleipnir214]

With PHP, install the latest version, which at the time I'm writing this is 4.3.4. In terms of what packages, I don't know -- I always install PHP from source.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[meenakshidhar]

ok..but what all packages of linux should i install...

 

[sleipnir214]

Whose packages are you installing?



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!