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 …
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
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 …
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 …
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?
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 …
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 …
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 …
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 …