Add Browse Dialog To Ado Datasource

Database Access

Document - ID	Specification Owner	Last Change	Status
	Wind Li	12/17/03	Draft
Conforms to	
Applies to	Dbaccess
Task ID(s)	Issue 23384
Category	Feature

Abstract

We use ADO datasource to access many kind of database in windows platform. But to use it users have to give an ugly string(named ADO connection string) to point out the detail about how to connect to the ADO datasource. So we need add a browse dialog where users can create or edit ADO connection stirngs in graphic mode.

i-Team Members (The specification owner is part of the i-Team)

	Name	E-mail Address
User Experience	Christian Jansen (CJ)	cj@openoffice.org
Development	Wind li(yl146652)	yl146652@openoffice.org
Quality Assurance	Marc Neumann (MSC)	msc@openoffice.org
Documentation	Uwe Fischer (UFI)	ufi@openoffice.org

Approved for Implementation

	Approved by	Date
User Experience	Christian Jansen (CJ)	January 13, 2004
Development	Wind li(yl146652)	January 18, 2004
Quality Assurance	Marc Neumann (MSC)	January 13, 2004
Documentation	Uwe Fischer (UFI)	January 13, 2004
String Review		

Document Change History

Rev. Level	Change	Initials	Date
0.1	initial revision		03／12／17
1	Add Error Conditions		04／1／18

Contents

Glossary	1

1	Motivation	1

2	User Scenarios	1

3	Goals	1

4	Requirements and Dependencies	1

4.1	Requirements	1

4.2	Technical Dependencies	1

5	Competitive Analyses	1

6	Detailed Specification	1

6.1	G11n	2

6.2	Error Conditions	2

7	Future Tasks	2

8	Notes	2

9	References	2

Glossary

Term	Description
OLE DB	OLE DB is a set of COM-based interfaces that expose data from a variety of sources. OLE DB interfaces provide applications with uniform access to data stored in diverse information sources, or data stores.
ADO	The full name of AOD is “ActiveX Data Objects”. It is an application-level programming interface to data and information wrapped around OLE DB.
ADO Connection String	A string which contains all the necessary information needed to connect to an OLE DB datasource. Currently if one of our OOo users want to use our ADO-SDBC wrapper driver to access any database, he/she would have to give the ADO Connection String to it.
OLE DB Provider	Similar to our sdbc driver.

Motivation

Improve the usability of our ADO-SDBC wrapper driver. Make it easy to use MS Access database and many other OLE DB supported database in OOo on windows platform.

Goals

The goal is to find out a solution to popup a dialog where users can create or edit an ADO connection string in a friendly and interactive mode.

Requirements and Dependencies

Requirements

Windows 95 or Windows NT 4.0 or later windows version.

Technical Dependencies

Microsoft OLE DB

Microsoft ADO

Detailed Specification

Microsoft provides a standard OLE DB Data link configuration dialog in its OLE DB runtime libraries. We can pass an ADO connection string to it,it then shows the connection dialog. When users change any thing and press OK button on it, It returns the new ADO connection string. Many applications which uses ADO to access database use it to allow a user to have the ability to configure a connection string. It looks like this:

Illustration 1OLE DB providers

Illustration 2Driver special information

Illustration 4All Information Illustration 3Advanced Information

We can enable the browse button in our connection properties dialog for ADO connection. We popup the OLE DB datalink dialog and pass the ADO Connection String to it when users press browse button. When users press OK button of OLE DB datalink dialog, we get the new ADO connection string from it.

Illustration 5 Ado DataSource Administration

Error Conditions

standard OLE DB Data link configuration dialog is not avalibale:

An error messagebox pops up: “The standard OLE DB Data link configuration dialog could not be openned.”

connection string can't be parsed: Pops up the same dialog to let user create a new one.

Future Tasks

Notes

References

OLE DB Programmer's Reference

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/olpridatasourcelocator.asp

ADO Browse Dialog

Page 5

http://dba.openoffice.org/specifications/ADO_Browse_Dialog.sxw

2003-12-15T19:00:50