WordPress.org

Plugin Directory

!This plugin hasn't been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

WP Db Abstraction

This plugin provides db access abstraction and SQL dialect abstraction for SQL Server. It is an mu (Must-Use) plugin AND also a db.php drop-in.

How do I create a wp-config.php file?

For new installs - we package our own wp-config.php creator. The creation url will be at $your_wordpress_url/wp-content/mu-plugins/wp-db-abstraction/setup-config.php The original setup-config.php WILL be redirected after the second step if db.php is in the right place

My themes and images don't show up when using Multisite with IIS

The rewrite rules supplied by wordpress for networking are incorrect for IIS7 and Url Rewrite

change your web.config file and replace the rewrite rule for #5 with the one below

<rule name="WordPress Rule 5" stopProcessing="true">
  <match url="^[_0-9a-zA-Z-]+/(wp-(content|admin|includes).*)" ignoreCase="false" />
  <action type="Rewrite" url="{R:1}" />
</rule>

Why is collation important when using SQL Server? How do I change the SQL Server Collation used?

By default, the SQL Server collation used by this plugin is database_default. This means that the default collation defined by the SQL Server install will dictate the collation used when creating the sql server tables.

If you need to use a different collation for your installation, you may define DB_COLLATE in your wp-config.php file. For example, defining it to Cyrillic_General_BIN. Note that this will only affect new installations of the plugin.

If you want to change the way an individual table is collated you may use the following example syntax:

ALTER TABLE wp_posts ALTER COLUMN post_content varchar(max)COLLATE Latin1_General_CI_AS

Requires: 3.0 or higher
Compatible up to: 3.3.2
Last Updated: 2011-12-23
Active Installs: Less than 10

Ratings

5 out of 5 stars

Support

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1
100,1,1
100,1,1
67,3,2 100,1,1
100,1,1 100,2,2
100,3,3 43,14,6
50,10,5
0,1,0 50,2,1
100,1,1 100,1,1 14,7,1
100,1,1 33,3,1
0,2,0
33,6,2
50,2,1
100,1,1
0,1,0
100,1,1
0,1,0
100,1,1