Answer the question
In order to leave comments, you need to log in
PHP and MS SQL, how to make friends?
There are 2 servers:
1. Server with a site, FreeBSD. The site is based on the bitrix engine and runs under mysql. PHP 5.4.
2. Server with MSSQL database, windows
Second database - should not be the base for the engine, these are separate data that must be periodically pulled to the site. Both servers are local.
At the moment there is a problem with PHP access to MS SQL server.
The problem is in the php driver for accessing the database. There are several options:
1. sqlsrv driver for PHP developed by microsoft.
Admin response: Unfortunately, it did not fit. it works only under windows system, and the server on which the site is located is currently running under unix.
2. MSSQL driver for php.
Admin response: Unfortunately, it works on PHP versions up to 5.3, the site server is now running 5.4. Versions 5.2 and less were unacceptable for the bitrix engine.
3. Connection via ODBC for linux developed by microsoft.
Admin response: It is impossible, because. it's just a driver and we don't have Linux installed.
4. Connection via FreeTDS + dblib.
Admin response: You can connect only through tsql, but not through php.
I do not have direct access to the servers (limited by the client's security policy), I communicate with the system administrator. I offered him 4 options, he said all 4 that it was unrealistic.
What can be done? Is the admin wrong somewhere?
Answer the question
In order to leave comments, you need to log in
I myself faced a similar problem. I described the solution in my blog iteye.ru/1853/installing-mssql-module-for-php-on-m... if you have any questions write in the comments there. Do not look at what is there about macosx on freebsd, everything is very similar.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question