Is possible to create a New WPDB object and connect to MICROSOFT SERVER SQL database?
$mydb = new wpdb('username','password','database','localhost');
$rows = $mydb->get_results("select Name from my_table");
Just for retrieve some data!!
[resolved] New WPDB and connect to MS SQL database? (12 posts)
-
-
@esmi is that your ANSWER???
Is it posible to connect to a MICROSOFT SERVER SQL with wpdb class??? -
Sorry - I thought you were trying to connect to your WP database.
-
Thank for you reply anyway,.. do you think you can consult to someone this issue?
-
Best I can offer is to move this topic to the WP-Advanced forum. Perhaps some of the regulars in there can help.
-
Really thanks for your support!!, that would be great!
-
Mark / t31os
Posted 11 months ago #See if the following guide helps.
http://wordpress.visitmix.com/development/installing-wordpress-on-sql-serverApparently an easier solution is to just install a MySQL server on the same server you have MSSQL on, they should run just fine alongside one another.
-
Mark / t31os, thanks for your reply, but i dont want to install wordpress on SQLSERVER, i JUST want to make a query to database on SQLSERVER(this db is NOT wordpress related)..
-
Posted 11 months ago #The WPDB class is designed for MySQL databases, so no i don't think you can query a MSSQL database, not using WordPress functions at least, you'll need to just do some straight PHP.
-
Thanks a lot for your reply!!!
-
Posted 11 months ago #You're welcome. :)
Reply
You must log in to post.
