mssql connect

rodent43

Hi folks,

this is my first post on this forum, so excuse me for sounding like a complete noob 🙂

I have made a Linux mail server using Red Hat 8.0 and sendmail...

we have a intranet system running on a Windows 2000 box and a MSSQL Server 7 on a windows 2000 box...

My problem is...i wanted to use php to pull some info off the sql server to the linux mail server...

I have configured/make/make install on both freetds and php and when i try to run the php page i got 'call to undefinded function: mssql_connect'...

so i copied a php_mssql.dll from a zip file and then i get 'unable to load dynamic library and the path name'..

can anyone help...????

this is driving me round the bend...

any comments would b appreciated...thx

goldbug

did you enable the mssql stuff when you configured php?

for example, my usual configure command:

./configure \
... some unrelated stuff ...
--with-mssql=/usr/local \
... some more unrelated stuff ...

and I've got the freetds libs in /usr/local/lib

other than that, normal install for freetds and php should be like you normally do (install freetds first, obviously)

rodent43

thx for responding dude...

well i done the freetds with ./configure --enable-msdblib etc and it is now in /usr/local/freetds

i then done the php with --with-mssql=/usr/local/freetds

but after all this, no php_mssql file was created anywhere and i kept getting the first error as i said above, so i tried copying the file from a zip file instead, then i got the 2nd error :-/

any more ideas??? or mistakes i made????

thx

goldbug

Not sure if it will make a difference, but make the include paths /usr/local/ not /usr/local/freetds. It might be looking for a /lib directory in what you specify, so /usr/local , it would look in /usr/local/lib for the freetds lib. Dunno, I'm full of crap, but it can't hurt to try.

FYI, I don't even have a /usr/local/freetds at all. All of my libtds. files are in /usr/local/lib

rodent43

thx man, i will have a look tomorrow....

any more comment will b appreciated to folks 🙂

rodent43

Still no go 😕

This has got me puzzled now...

Any one had similar prob and sorted it, comments will b appreciated 🙂