The SDBC Driver for ADO

From Apache OpenOffice Wiki
Jump to: navigation, search



The SDBC driver for ADO supports the service com.sun.star.sdbcx.Driver. ADO does not allow modification on the database structure unless the database is a Jet Engine. Information about the limitations for ADO are available on the Internet. The URL for SDBC driver for ADO looks like this:

 sdbc:ado:<ADO specific connection string>

Possible connection strings are:

  • sdbc:ado:PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\northwind.mdb
  • sdbc:ado:Provider=msdaora;data source=testdb
Content on this page is licensed under the Public Documentation License (PDL).
Personal tools
In other languages