Using MSSQL from PHP4

Anon

I've been using PHP4PL2 without problems.

But I can not make this access to MSSQL Server , via freetds, come true.

What I've done is.

to install freetds :

./configure ---with-tdsver=4.2
gmake
gmake install

Apparently there was no problem after this

then, I recompile PHP4 this way:

./configure --with-mysql --with-apxs --with-sybase=/usr/local/freetds

Apparently there was no problem

then I edit httpd.conf to remove a line that was added by the rebuilding process of
php4

Then, when I type apachectl restart

there's a message telling me to check problem with

apachectl configtest

and what this command sends to standard output is

cannot load /etc/httpd/modules/libphp4.so into server : libsybdb.so.0:
cannot open shared object file: No such file or directory.

May be I am doing the wrong thing with ./configure parameters ?

Any suggestions ?

Thanks in advance.

Anon

This is a good bug report - I hope someone is able to help you.

If you get it fixed, be sure to post a followup with your solution.

Anon

i had the same type of problem, you have to add the lib path to your environment var. what i did was added /usr/local/freetds/lib to my /etc/ld.so.conf file then did ldconfig to reset it. FreeTDS is a great lib but it doesn't support a lot from SQL7 (ie inserts, data types etc..) Hope this helps
-chris

Anon

I am quite new to PHP and have just started out. I use a Pentium 2 266Mhz. Red Hat Linux 6.2 is installed Apache webserver is installed. PHP3 is configured as a module with the web server. PostgreSQL is the database i have. But i am not used to PGSQL much.

The problem is when i try to execute a script to create a table in my own machine, i get a parse error which states that there is no such database(the name of database is passed as a parameter with the pg_connect() statement) in pg_database. But i already have the database.

Please help me out.

Bye

Anon

You should always include exact error messages, but my guess is, you are not passing all the right parameters or are not connecting to the right machine where the database resides.

Anon

Hi Chris,

I tried that and now I get the following error:
Cannot load libphp4.so into server: /etc/httpd/modules/libphp4.so: undefined symbol: DBSETLCHARSET

Please help.

Thanks,
Ken.