Lazarus EOleException

The 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: 658
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: 942
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 Forum”

Who is online

Users browsing this forum: No registered users and 1 guest