MS ADO (MS SQL-Server/MS Access)

The Microsoft ADO API allows access MS SQL-Server and MS Access databases.

To utilize MS ADO within GNUe, you must use one of the following python drivers:

msado

msado

A Python DB-API 2.0 module that makes it easy to use Microsoft ADO for connecting with databases and other data sources.

Prerequisites:

Mark Hammond's win32all python for windows extensions.

Home Page: http://sourceforge.net/projects/adodbapi

Supported Platforms:

MS Windows 98/NT/2000/XP (Installer available)

Connection Properties

The following properties can be specified in your connections.conf file:

oledb_provider (required)
data_source (required)
initial_catalog (optional for SQL Server)
network_library (optional for SQL Server)
data_provider (optional for SQL Server)

You can find more connection strings here:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm

Examples

The following is an example of a connection.conf entry:

  [access]
  comment = MS Access database
  provider = msado
  oledb_provider = Microsoft.Jet.OLEDB.4.0
  data_source = C:\mydb.mdb

  [sqlserver]
  comment = MS SQL Server database
  provider = msado
  oledb_provider = sqloledb
  data_source = myServerName
  initial_catalog = myDatabaseName

Notes

This driver is only usable under MS Windows.
This driver does not implement schema creation. Index introspection is not supported by this driver
MS SQL Server has been tested successfully. MS Access backends need some more testing
Other than that, the driver is fully functional with no known serious problems.

GNUe Home

Developer Tools