The officially official Devuan Forum!

You are not logged in.

#1 2020-11-02 11:01:53

ftusc
Member
Registered: 2020-07-03
Posts: 12  

php and sql server

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?

Offline

#2 2020-11-05 21:01:06

xinomilo
Member
Registered: 2017-07-02
Posts: 155  

Re: php and sql server

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

Offline

#3 2020-11-05 21:32:37

golinux
Administrator
Registered: 2016-11-25
Posts: 2,076  

Re: php and sql server

Please check out this thread for updated php.

Offline

#4 2020-11-09 11:35:46

ftusc
Member
Registered: 2020-07-03
Posts: 12  

Re: php and sql server

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!

Last edited by ftusc (2020-11-09 11:36:25)

Offline

Board footer