Can’t Connect to MSSQL but no problem with MySQL

  • Resolved jwade020

    (@jwade020)


    2 years, 2 months ago

    I am attempting to connect to a MSSQL database with this plug in but I keep getting this error:

    “[24-Apr-2024 11:29:14 UTC] PHP Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect() in C:\Sites\dotorg\wp-content\plugins\external-login\login\db.php:25
    Stack trace: 0 C:\Sites\dotorg\wp-content\plugins\external-login\login\db.php(157): exlog_get_external_db_instance_and_fields() 1 C:\Sites\dotorg\wp-content\plugins\external-login\login\authenticate.php(11): exlog_auth_query() 2 C:\Sites\dotorg\wp-includes\class-wp-hook.php(324): exlog_auth() 3 C:\Sites\dotorg\wp-includes\plugin.php(205): WP_Hook->apply_filters() 4 C:\Sites\dotorg\wp-includes\pluggable.php(618): apply_filters() 5 C:\Sites\dotorg\wp-includes\user.php(106): wp_authenticate() 6 C:\Sites\dotorg\wp-login.php(1311): wp_signon() 7 {main} thrown in C:\Sites\dotorg\wp-content\plugins\external-login\login\db.php on line 25″

    I am using the pdo_sqlsrv_83_nts_x64 extension because the sqlsrv_83_nts_x64 extension doesn’t seem to work. Could this be causing the issue?

    Any help is appreciated.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author tbenyon

    (@tbenyon)

    2 years, 2 months ago

    Hi there,

    You need to ensure sqlsrv is installed on your server.

    Kind regards,

    Tom

    Thread Starter jwade020

    (@jwade020)

    2 years, 2 months ago

    Thanks, apparently php 8.3 was having an issue with sqlsvr. I fixed that but now I get a 500 error whenever I go to the Settings page. I have uninstalled and reinstalled the plugin and removed the options from MySQL. This doesn’t happen with any other plugin. When I click Settings it goes to /wp-admin/options-general.php?page=external-login, but I get a 500 error. Any guidance is appreciated. Thanks!

    Thread Starter jwade020

    (@jwade020)

    2 years, 2 months ago

    Nevermind. The settings page is fixed and correct, but I still get a 500 error when I test the connection. I am able to connect to the database other ways, just not with the Test button within the plugin.

    Thread Starter jwade020

    (@jwade020)

    2 years, 2 months ago

    Once again nervermind, I mistyped a field name. Everything works now.

    Plugin Author tbenyon

    (@tbenyon)

    2 years, 2 months ago

    that’s great news 😊

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Can’t Connect to MSSQL but no problem with MySQL’ is closed to new replies.