WordPress.org

Ready to get started?Download WordPress

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.

1.1.4

  • add all reserved words for sql server - plugins might use them
  • fixed limit regex to catch queries with ; at the end
  • fix for inserting NULL into identity columns

1.1.3

  • fixed ording for items in archives
  • added extra space before N prefix in strings to fix bad concatenation issues

1.1.2

  • packaged correct example fields_map file updated to a base 3.2.1 install
  • blocked install as anything but mu-plugin
  • fixed error messages for attempted regular plugin install
  • fixed html issues with error page
  • field maps parsed_types information cache can have a location defined in wp-config.php
  • on multisite installs, each site has it's own database metadata cache file
  • added error if PHP database extension desired is not loaded to avoid confusing db can't connect errors

1.1.1

  • additional help for installation, upgrading, and migrating
  • packaged example fields_map file updated to a base 3.2.1 install
  • translation uses N prefix for unicode data
  • DB_COLLATE obeyed properly for table creation
  • better error handling and descriptions for plugin, installation and upgrade issues

1.1.0

  • New method of stripping out strings before translation
  • drivers extend sql translation that extends wpdb
  • mysqli driver added
  • Drivers cleaned up and code simplified
  • Issues with sqlsrv and datetime objects, and with integrated windows auth are now fixed
  • Some translation fixes for various plugins
  • API ping is now cached
  • Error if fields_map file cannot be written to
  • Packaged example fields_map file for installations that failed

1.0.1

  • Fix for USING join for categories
  • mysql driver now simply extends wpdb class
  • pdo driver now provides connection exception information when WP_DEBUG is on
  • Added warning for windows users with ntwdblib and mssql to config setup

1.0.0

  • Changed from patch to plugin architecture.
  • Incorporated several fixes from sourceforge forums in T-SQL dialect translations

Requires: 3.0 or higher
Compatible up to: 3.3.2
Last Updated: 2011-12-23
Downloads: 14,125

Ratings

4 stars
4.4 out of 5 stars

Support

0 of 1 support threads in the last two months have been resolved.

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