Lazarus, Zeos and Ms Access (mdb)

Forum related to ADO

Moderators: gto, cipto_kh, EgonHugeist

Dali
Junior Boarder
Junior Boarder
Posts: 30
Joined: 08.02.2010, 14:36

Postby Dali » 20.05.2011, 00:56

Mark, do you think there would be an easy way of connecting to an Access database via ODBC with Zeos components being Lazarus the compiler and Windows the target OS? Would such a thing require much work, other than simply commenting some conditional defines out like I did with ADO? Or would I need to write a whole driver from scratch? That might be a solution for me and, in fact, since OLEDB unit would not be required in that case, the patch could be committed, and I'd see it as a big step forward for the port of the whole Zeoslib to Lazarus.

pingy
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 25.01.2012, 13:03

Any chance on ADO

Postby pingy » 25.01.2012, 13:15

I find myself in de same spot as Dali and wanted to give Lazarus/Zeos/ADO a try. Since this topic is running for more than 3 years, I wondered if there's any chance of ADO being incorporated into Zeos.
Besides that, the documentation states "For other databases we propose to use implemented Active Data Objects (ADO) Bridge". What is meant by this and, where is that bridge and where is it implemented? Does anyone have a clue to what I could do whith this statement?

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 01.03.2012, 00:53

pingy,
As long as fpc/lazarus can't provide an oledb replacement and nobody writes his own odbc/ado driver for zeoslib this will not become available. There are 2 reasons for this:
- licence issue with oledb unit
- no volunteering developers to write a new zeoslib driver

Mark
Image

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 01.03.2012, 00:59

Correction! Apparently there's some odbcsql package in the fpc source code directory. No idea if it can be used to start a new driver, however.

Mark
Image

TheBlackSheep
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 27.02.2008, 22:43

Postby TheBlackSheep » 14.02.2013, 22:24

Don't know if anyone has looked into this recently - I have need to populate an MSAccess database (ideally via ADO) and although this is available in Delphi via Zeos it still isn't an option in Lazarus on Windows.

If the outstanding issue is an open source OleDB unit then there might be a possibility of using the open-source Synopse framework which has the SynOleDB unit.

[link=]http://synopse.info/fossil/wiki/Synopse+OpenSource[/link]

It seems to have some issues with compiling - the comments which are extensive have double/triple opening curly brackets which Delphi just ignores but FPC/Lazarus requires equivalent closed brackets and when it doesn't find any just treats all subsequent code as a comment - so that would need tidying.

There's a few dependencies to other files in the framework but might it be possible to modify it in such a way to make it work with Zeos?

TheBlackSheep

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 15.02.2013, 10:14

TheBlackSheep,

sounds great. Thoughts:

Somebody has to write them if we're allowed to provide/change theire codebase. If yes than we can start implement the SynOleDB. Don't hessitate to start theire. IF you would like to start than i propose to work with some defines like {$IFDEF ENABLE_SYNOLEDB}. The implementation should be available for FPC only i think.

Hint: OleDB becomes more and more deprecated. MSSQL2012 f.e. is the last Microsoft server who sopports the OleDB. All fututer relases usung the TDS-protocol or another library. I don't know what happens to MSAccess in this case.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

marcov
Senior Boarder
Senior Boarder
Posts: 94
Joined: 24.06.2010, 09:17

Postby marcov » 26.02.2013, 09:52

The just released FPC 2.6.2 comes with TDS headers (and connection etc classes for SQLDB)

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 28.02.2013, 21:55

TheBlackSheep,

i wrote with the Synopse people. The use our ADO implementation. So this way is closed. I guess we need an ODBC-protocol like the FPC-SQLDB components do support...
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Postby mdaems » 10.03.2013, 21:33

No way to reuse the fpc sqldb classes as they are in a new fpc-only zeoslib dbc driver? As far as I understand they are free to use.

Mark
Image

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Re: Lazarus, Zeos and Ms Access (mdb)

Postby EgonHugeist » 10.12.2014, 23:40

Note:

Since 7.2 you can use the ADO-protocol for FPC too!
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image


Return to “ADO”

Who is online

Users browsing this forum: No registered users and 0 guests