Issue 44754

Summary: Add ODBC driver for ODB.
Product: Base Reporter: davidshq <dave>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: akela501.chace, issues, mechtilde
Version: OOo 2.0 Beta   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description davidshq 2005-03-10 22:03:23 UTC
I think it would be really great of the ODB format could be made ODBC compliant.
This would open it up as a replacement for Access for many web scripts (e.g.
ASP, ASP.NET)
Comment 1 Frank Schönheit 2005-03-11 09:19:23 UTC
confirming as valid RFE, and assigning to requirements evaluation team,
according to http://qa.openoffice.org/issue_handling / "QA for RFEs"
Comment 2 pmleite 2005-11-18 19:15:06 UTC
Would be fantastic... I hop do you get an ODBC drive for ODB verry sun
Comment 3 Mechtilde 2007-12-16 11:04:03 UTC
you can use the ODBC driver of many DBMS.

So I think we can close this isuue.
Comment 4 prince_davi 2008-01-15 04:16:14 UTC
You mention you can use many DBMS drivers that will connect over ODBC, however 
I would like to convert my Access databases to ODB, then use ODBC to connect 
through to them which would replace my need for access completely.

I have tried using the Microsoft Access driver when setting up a System DSN to 
the converted ODB, but this does fail.
Comment 5 Mechtilde 2008-01-15 09:03:14 UTC
Questions are inside

> You mention you can use many DBMS drivers that will connect over ODBC,
> however I would like to convert my Access databases to ODB,

you mean to the internal HSQL DB?

> then use ODBC to connect through to them which would replace my need for
> access completely.

What do you want to do via the ODBC connection?

> I have tried using the Microsoft Access driver when setting up a System DSN
> to the converted ODB, but this does fail.

Do you want to connect to an Access database?

I think it is better to discuss these things on the mailing list
users@dba.openoffice.org


Comment 6 joannabanana 2008-10-01 17:47:14 UTC
Wow, this would be great.  I've been searching and searching for an ODBC driver 
that will allow me to connect to my OpenOffice Base database.  I've also seen 
lots of other people searching for this exact thing as well.  I know how to 
work with ODBC drivers, and am fainting at the thought of trying to wrap my 
mind around how to connect to my .odb otherwise.