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 built the plugin in my localhost by connecting directly using SQLSRV. But this plugin won't work on his site because I can't fetch the data without mssql driver. Can you please guide me through this issue? How can I fetch the …
Category: Web

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
Category: Web

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 Server DLL from the list of answered questions that popped on as I was typing the title of this thread. I downloaded those DLLs inside the PHP folder as instructed. When I fired up the server address to install WordPress, I was prompted …
Category: Web

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 can I do this? And I want to be easy to add, for example that I can add the count or the information like presing edit page and in the add section there is something …
Category: Web

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 deploy it successfully with sql server?? and what software or driver or service will be needed for this deployment on the system?
Category: Web

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 and for security reasons a serialized table is created. So there is no way for me to "read" from the database. I contacted the company that hosts and maintains the database and they said that they could automatically create an .csv …
Category: Web

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 added a few posts. In the admin menu, under posts, I see that there are six published posts "Published (6)". However the list below this is empty. Also trying to view these on the site, by selecting the category returns Nothing …
Category: Web

wordpress + cyrillic characters with SQL server 2008 r2

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 get question marks where the Cyrillic characters should be. I see the same question marks stored in the DB. I tried inserting the post manually in to the database and it works, i.e. the issue is not the sql …
Category: Web

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 only in the administration. I guess it might have something to do with my database which is SQL Server using WP Db Abstraction. So I installed debug bar and found this query: SELECT TOP 0 * FROM wp_posts WHERE 1=1 AND wp_posts.post_type …
Category: Web

About

Geeks Mental is a community that publishes articles and tutorials about Web, Android, Data Science, new techniques and Linux security.