Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Add ODBC driver for ODB.|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||akela501.chace, issues, mechtilde|
|Version:||OOo 2.0 Beta|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
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 email@example.com
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.