[solved] MS-Access?

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
hstijnen
Junior Boarder
Junior Boarder
Posts: 32
Joined: 11.04.2012, 08:49

[solved] MS-Access?

Post by hstijnen »

Hi,
Is it possible to connect MS-Access with ZEOS lib?

Henk
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

Yes it is, use the ado protocol.

I have also access to text, als,csv files via ado+MicrosoftJetEngine.

Everything which has an dbc driver and is a SqlServer can be used with Zeos.

Michael
Best regards, Michael

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

Image
hstijnen
Junior Boarder
Junior Boarder
Posts: 32
Joined: 11.04.2012, 08:49

Post by hstijnen »

.mdb is OK, but how to connect .accdb (Access 2010)?
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Post by EgonHugeist »

hstijnen,

hmm, don't they provide an ODBC driver? If yes then it should be equal possible. I can't test it by my selves, Henk...

Michael
Best regards, Michael

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

Image
hstijnen
Junior Boarder
Junior Boarder
Posts: 32
Joined: 11.04.2012, 08:49

Post by hstijnen »

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Pharos_BRN.accdb;Persist Security Info=False

does the job, thanks for your hint
Locked