WordPress.org

Support

Support » How-To and Troubleshooting » [Resolved] Connecting to external SQL Server with a plugin

[Resolved] Connecting to external SQL Server with a plugin

  • Hello! I’m trying to connect to a separate SQL Server Database from within my plugin (the data is already in that database) so I am trying to do so this way:

    $dbh= mssql_connect($host, $user, $password) or die ('I cannot connect to the database because: ' . mssql_get_last_message());
    		mssql_select_db($database) or die ('I cannot connect to the table because: ' . mssql_get_last_message());

    However, I’m getting an unable to connect error. When I run the same code outside of a wordpress plugin in the wordpress directory, I connect fine and can display the data.

    Does WordPress have some option I need to enable to connect to a different database not using $wpdb? Is it blocked completely?

    Thanks!

    Joe

Viewing 1 replies (of 1 total)
  • Update: there is no issue. It was a variable issue due to tired eyes.

    So for future reference- you should be able to connect to an external SQL Server within a WordPress plugin with no problems, assuming you have the proper DLL installed.

Viewing 1 replies (of 1 total)
  • The topic ‘[Resolved] Connecting to external SQL Server with a plugin’ is closed to new replies.
Skip to toolbar