MSSQL; PHP+ APACHE, FREETDS Apache

Anon

I am having problems getting PHP, under apache on LINUX to talk with MSSQL on NT SQL7.. I am able to get to a SQL prompt and it looks as though I make a database connect, but when I query the table I get a CORE..

I would appreciate any insight from someone that is running the configuration as follows:
(and how they set it up?)

Linux
Apache web server
PHP - 4.0.x
FreeTDS - 0.52
iODBC

I used iODBC to create the DSN to connect to.

Connecting to NT 4.0 via IP port 1433
to MSSQL 7.0 SP2 or SP3..

Our development team is ready to chuck the Linux option and go to NT I shutter at the security issues.. We can use PHP on NT but we'd prefer to use apache / under linux..

Thanks in advance ..

Rex

Anon

Hey Rex, just posted back on the compile 🙂

Anyway, I've never had to use iODBC with it and that may be what is causing the problem.

My interfaces file reads:

server01
query tcp tds7.0 server01 1433

Then in my script I simply do (direct):

$hostname ="server01";
$username = "user";
$password = "pass";
$dbname = "Table"; $connection = mssql_connect($hostname,$username,$password) or die("unable to connect");
mssql_select_db($dbname);
$query_result =mssql_query($other) ;
$number_rows = mssql_num_rows($query_result);
$number_fields = mssql_num_fields($query_result) ;
and so on....

Anon

What does your compile line look like for PHP?

Anon

I know you found this one Rex. Here it is for others following along.

http://www.phpbuilder.com/forum/read.php3?num=5&id=22989&thread=5252

Anon

THanks again Jerry.. Your a butt saver..

my php compile failed when I use the sybase directive line any thoughts?

Anon

Is the freetds installation in your /etc/ld.so.conf file? And run ldconfig after adding it and see what you get.

Is there a hint of what part if failing in the error?

Anon

Jerry,

it appears now I got it compiled..

I need to run a test from a php script to see if they can query against the database..

Do you have a down and dirty test to check the database connection from the interface file:

/usr/local/freetds/interfaces

ims2
query tcp ether 10.3.253.37 1433
master tcp ether 10.3.253.37 1433

i do know the login id and password..

the database instance name is PLV_SIMS

Thanks again Jerry.. You've really helped..

Anon

There is a basic php script in my first post in this thread. Just fill in the appropriate vars, define a query and see what you get. If you can get a row count on the query you're likely in business.

$hostname ="ims2";
$username = "user";
$password = "pass";
$table="tablename";
$query="SELECT ?? FROM $table";
$dbname = "table";
$connection = mssql_connect($hostname,$username,$password) or die("unable to connect");
mssql_select_db($dbname);
$query_result =mssql_query($query) ;
echo mssql_num_rows($query_result);

Anon

Jerry, it is working now the coding is in the hands of our development team..

Thanks much!!!

Kudos!!!

Anon

GREAT!!

I have enjoyed good, stable performance with PHP/MSSQL for over a year. I hope your team has similar or better results!