Questions tagged [mssql]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
0 votes
0 answers
41 views

Fetch Data from an external MSSQL Database in a Managed WP hosting

SO, my client is using a managed WP hosting, which is why I can't install MSSQL drivers in his server. I am building a plugin for him to fetch some data from their office's MSSQL server. Now, I have ...
user avatar
0 votes
1 answer
117 views

SQL copy post_title to post_content

Anyone know the SQL to copy post_title to post_content where post_content is empty for all and only posts in wordpress Thanks for any pointers in advance Richard
user avatar
0 votes
1 answer
173 views

How to show result of sql query in a page?

I have a table in the same DB that I have a WordPress page and I want to show in the land page the count of total of rows and then I need an another page that show the information of this table , How ...
user avatar
3 votes
1 answer
19k views

How do I configure WordPress to talk to a Microsoft SQL Server database?

We have are building a WordPress site on our intranet site and wish to connect it to a Microsoft SQL Server. I have downloaded and configured PHP and PHP Manager on IIS. I have also downloaded SQL ...
user avatar
  • 131
2 votes
2 answers
2k views

Installation with sql server express edition

I have developed a web portal in wordpress using xampp server. i have my database in my sql. Now i need to deploy this wordpress portal on other system with sql server express edition. So how can i ...
user avatar
0 votes
3 answers
6k views

Execute a function every hour in the background

I'm in kind of a weird situation (for me) My client has a website that runs on a custom CMS He wants an online site that loads some data from the existing database. This is an external MSSQL database ...
user avatar
1 vote
0 answers
369 views

wordpress + cyrillic characters with SQL server 2008 r2 [closed]

I have a blog running on a windows 2008 machine with SQL server 2008 r2. WP version 3.3.2 I have an English blog, but I would like to post some content in Russian. When I try and post the content I ...
user avatar
2 votes
1 answer
2k views

Wordpress, IIS7, SQL Server 2008, not showing posts (displays 'Nothing Found...') and only shows counts in admin - how to fix?

I recently installed WordPress on IIS 7 and wired it up to SQL Server 2008R2. The installation went fine. Right off the bat, I can see on post is present (just in the count) but none are listed; I ...
user avatar
  • 141
0 votes
1 answer
3k views

Is "SELECT TOP 0" a bug with MS SQL database?

I'm having an issue that my posts page displays "no posts found" while right above it, there is "All (1) | Published (1)" (it is a new installation). The post is also invisible on the live site, not ...
user avatar