Community AlphaAlpha MUADMINS
ENEnglish
Sign in
On MuADMINSConfig ScannerDrop your files zip: rates, drops, spots, limitsOpenOn MuADMINSMeet us on DiscordAsk for help, share what you are building and talk MU with other server owners.Open

MuADMINS

Solutions

Short fixes for common MU Online server, client and website problems, each with its source and date. “Confirmed” means the person who asked said the fix worked.

7 solutions for “ODBC” in Website · Clear

  1. Websiteany

    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...

    ✓ Confirmed in the issueGitHub (lautaroangelico/WebEngine) · 2025-02-20
  2. WebsiteS6

    WebEngine 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...

    ✓ Confirmed by the topic starterRaGEZONE · 2023-10-06
  3. Websiteany

    MuCore 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....

    ✓ Confirmed by the topic starterTuServerMU · 2017-12-27
  4. Websiteany

    WebEngine 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.

    ✓ Confirmed by the topic starterRaGEZONE · 2017-09-09
  5. Websiteany

    Which 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...

    MuADMINS rewrite of the sourceNot verifiedMicrosoft Learn · 2026-08-21
  6. Websiteany

    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...

    MuADMINS rewrite of the sourceNot verifiedWebEngine docs · 2025-02-25
  7. Websiteany

    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...

    MuADMINS rewrite of the sourceNot verifiedWebEngine docs · 2025-04-25

Videos on MUTube

More videos for “ODBC”

Still stuck? Ask the MU Assistant Search MuGPS

MuADMINS Community Alpha: free and community made, in active development.