MuADMINS
Решения
Короткие исправления частых проблем серверов, клиентов и сайтов MU Online, каждое с источником и датой. “Подтверждено” означает, что автор вопроса сообщил, что исправление сработало.
Решений: 7 по запросу “ODBC” в категории «Сайт» · Сбросить
Installing WebEngine CMS 1.2.5 with the ODBC driver fails with '[ODBC SQL Server Driver] The data types varchar(max) and text are incompatible in the equal to operator'.
1. Do not use the old ODBC SQL Server driver for the install. 2. Install the Microsoft PHP SQLSRV / PDO_SQLSRV drivers that match your PHP version and enable them in php.ini. 3. Restart A...
✓ Подтверждено в issueGitHub (lautaroangelico/WebEngine) · 2025-02-20WebEngine CMS install keeps saying 'Could not connect to database (1)' with SQL Server 2008 and XAMPP (PDO ODBC), even though SSMS connects fine.
1. The thread found a conflict between SQL Server 2008 and WebEngine's connection. 2. Install a newer SQL Server (2012 worked for the topic starter; another user had 2019 working). 3. Res...
✓ Подтверждено автором темыRaGEZONE · 2023-10-06MuCore on XAMPP on the same VPS as SQL Server cannot connect to the database.
1. Easiest: in the MuCore config.php change the connection type from MSSQL to ODBC. 2. Or open SQL Server Configuration Manager, enable TCP/IP and Named Pipes, and restart SQL Server. 3....
✓ Подтверждено автором темыTuServerMU · 2017-12-27WebEngine 1.0.9 with a remote SQL Server IP fails with 'Could not connect to database (1)', while MuCore connects to the same server without problems.
1. In the WebEngine installer select the ODBC driver instead of dblib/sqlsrv. 2. Make sure the matching PHP ODBC extension is enabled and port 1433 is reachable. 3. Finish the install.
✓ Подтверждено автором темыRaGEZONE · 2017-09-09Which php_pdo_sqlsrv DLL do I need for WebEngine on Windows PHP 8.x, and why does it not load?
1. The driver file must match PHP version, thread safety and bitness: e.g. php_pdo_sqlsrv_82_ts_x64 for PHP 8.2 thread safe 64 bit. 2. XAMPP Apache uses thread safe (ts) PHP; IIS FastCGI...
What does a server need before installing WebEngine CMS 1.2.x?
1. Apache with mod_rewrite (or the Nginx or IIS rules from the wiki). 2. PHP 8.1 or newer, 8.4 suggested. 3. One SQL Server driver: PDO dblib (Linux), ODBC, or SQLSRV (Windows). 4. PHP ex...
WebEngine cannot connect to an older SQL Server (2008, 2012, 2014, 2016). What settings help?
1. Linux with pdo_dblib: install FreeTDS (apt install freetds-bin) and add a named block in /etc/freetds/freetds.conf with host, port 1433, encryption off and tds version 7.1. 2. Test it...



