Lazarus EOleException

The BETA tester's forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
af0815
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 24.03.2017, 12:49

Lazarus EOleException

Postby af0815 » 19.04.2017, 06:21

ZEOS 7.2.1-rc and Lazarus 1.8.0RC1 rUnknown FPC 3.1.1 i386-win32-win32/win64

I have a very simple sample on Github https://github.com/afriess/schnell/tree/master/ZEOSAccess/01_BasicAccess.

It connects with ado to the Access Db with a DSN with a ZConnection and a ZTable & Datasource & DB-Grid. When i connect, i see the data from the Access Table and can navigate without a problem. But if i set the ZConnection.Connected to false i got a EOleException.

How can i avoid this ?

ZeosError01.JPG


Andreas
You do not have the required permissions to view the files attached to this post.

marsupilami
Gold Boarder
Gold Boarder
Posts: 535
Joined: 17.01.2011, 14:17

Re: Lazarus EOleException

Postby marsupilami » 19.04.2017, 08:13

Hello Andreas,

the MS Access / Jet Engine provider for ADO / OLE is clumsy at best. I had my share of problems on working with it. I think I resolved to using Zeos 7.3 and its OLEDB driver. Not sure, if that helps though.
Could you provide a smallish Access / Jet Engine database that I can use for testing with your github application?

With best regards,

Jan

af0815
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 24.03.2017, 12:49

Re: Lazarus EOleException

Postby af0815 » 19.04.2017, 09:00

Sorry, i forgot to say, the Access DB is the test_1.tpdb8. Its a mdb.

https://github.com/afriess/schnell/blob ... st_1.TPDB8

To make it more clear, i copied the as an mdb.

miab3
Zeos Test Team
Zeos Test Team
Posts: 894
Joined: 11.05.2012, 12:32
Location: Poland

Re: Lazarus EOleException

Postby miab3 » 19.04.2017, 10:23

@af0815,

At me, it works for:

Code: Select all

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=f:\Lazarus_testy\ZEOSAccess\DB\test_1.mdb;Persist Security Info=False

Lazarus 1.6.4-Win32; ZEOS 7.2, 7.3 svn 3986.

Michal

af0815
Fresh Boarder
Fresh Boarder
Posts: 14
Joined: 24.03.2017, 12:49

Re: Lazarus EOleException

Postby af0815 » 19.04.2017, 13:03

miab3 wrote:At me, it works for:

Code: Select all

Provider=Microsoft.ACE.OLEDB.12.0;

Michal


With THIS Provider for me too. There must be a diffence between the providers. So the use of of ODBC DSN in Win 10 looks outdated.

THX
Andreas


Return to “ZeosLib 7.2 Betatest Forum”

Who is online

Users browsing this forum: No registered users and 1 guest