Dev1 Galaxy Forum / php and sql server

Re: php and sql server

dummy@example.com (mckaygerhard) — Sat, 20 Feb 2021 14:50:45 +0000

ftusc wrote:

Thanks a lot.
Unfortunately for me this and other link don't work.
It only works when use PDO via ODBC via SQLSRV.
M$ products sucks me too. Unfortunately I have to interface with it at work.
Instead mysql and other free software databases integration works like a charm!

but more miscinformation.. the problem are two..

1. you need updated odbc fixed from freedts and correct odbc ini file.. there's some changes that i already send to "freddy77" but stil is happened as https://github.com/FreeTDS/freetds/issues/372, check if your problem is related to MARS or cicled/anidated querys

2. php packages from sury and tdenetworks now has some problems, i corrected only php5.6 ones.. if you use php5.6 here are the solution: https://t.me/vegnuli/361 by addiding :

echo 'deb http://download.opensuse.org/repositories/home:/vegnuli:/lamp-vnx/Debian_10/ /' > /etc/apt/sources.list.d/home:vegnuli:lamp-vnx.list

curl -fsSL https://download.opensuse.org/repositories/home:vegnuli:lamp-vnx/Debian_10/Release.key | gpg --dearmor | tee /etc/apt/trusted.gpg.d/home_vegnuli_lamp-vnx.gpg > /dev/null

apt update
apt install php5.6 (etc etc)

Re: php and sql server

dummy@example.com (ftusc) — Mon, 09 Nov 2020 11:35:46 +0000

Thanks a lot.
Unfortunately for me this and other link don't work.
It only works when use PDO via ODBC via SQLSRV.

M$ products sucks me too. Unfortunately I have to interface with it at work.
Instead mysql and other free software databases integration works like a charm!

Re: php and sql server

dummy@example.com (golinux) — Thu, 05 Nov 2020 21:32:37 +0000

Please check out this thread for updated php.

Re: php and sql server

dummy@example.com (xinomilo) — Thu, 05 Nov 2020 21:01:06 +0000

usually stay away from M$ products, so never tried it, but maybe this helps :
https://github.com/microsoft/msphpsql/b … 8-9-and-10

php and sql server

dummy@example.com (ftusc) — Mon, 02 Nov 2020 11:01:53 +0000

I want connect to sql server database with php.
In the past (Devuan jessie) I had used with php5 mssql library (removed with php 7.0).
https://www.php.net/manual/es/function. … onnect.php

Until a few days ago with Devuan ascii (php 7.0) I had used pdo sqlite without problems.
https://www.php.net/manual/en/ref.pdo-dblib.php

I upgrade to Beowulf (php 7.3) but now don't work it. I've found a way to make it work with pdo-odbc.
https://www.php.net/manual/en/ref.pdo-sqlsrv.php

Unfortunately this library don't permit me to use prepared statements (php script return segmentation fault!),
use "getColumnMeta" to get column name and so on.

What to do?

I cannot install php7.0 in beuwulf. It is not present.

Microsoft SQL Server Driver for PHP for me don't work:
https://www.php.net/manual/en/book.sqlsrv.php
I tried to execute step by step installation and configuration but don't work.

How to do?