Enabling MS SQL Native Client 2005 Connections in Data Explorer

Abstract: This article shows how to enable MS SQL Native Client 2005 connections in the Data Explorer for RAD Studio 2010.

By default, the Data Explorer in RAD Studio 2010 only shows MS SQL Native Client 2008 connections. A simple change to the dbxdrivers.ini file will allow the Data Explorer to show both 2005 and 2008 connections.

  • Open dbxdrivers.ini in Notepad
    • On Windows XP: c:\Documents and Settings\All Users\Documents\RAD Studio\dbExpress\7.0
    • On Vista: c:\Users\Public\Documents\RAD Studio\dbExpress\7.0
  • Insert MSSQL9=1 into the [Installed Drivers] section

Hide image

  • Launch the RAD Studio 2010 IDE (if it was already open, close it and launch it again). You will now see connection nodes for the default MSSQL connection as well as MSSQL9.

Hide image