Issue 44754 - Add ODBC driver for ODB.
Summary: Add ODBC driver for ODB.
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0 Beta
Hardware: PC Windows XP
: P3 Trivial with 11 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-03-10 22:03 UTC by davidshq
Modified: 2013-02-07 22:34 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.