Zeoslib Portal

That's it Michal, setting Mode = ReadWrite did the trick. Thanks. Funny though that it worked OK with TADOQuery with the exact same connection string.

I'm using Zeos with ADO to hook into an Access database. I have a DBGrid connected to a ZQuery. This works fine with Zeos and the SQLite driver. I can do edits in the grid, add records etc. Switching to Zeos/Ado/Access though, on trying to edit a field I get the EOleException error: 'Operation must ...

OK this was due to old Zeos files in a Delphi 5 folder. I did not realize that Delphi also looks at the Windows path setting to find bpls. Like many developers I need to maintain several different Delphi IDEs. The solution is to temporarily put all other Zeos bpls into a temp folder, then install, t...

On attempting 7.1 install in Delphi XE I get the message that these changes must be made in order to install ZComponentDesign: Remove ZPropertyEditor, ZComponentReg. Unit(s) ZPropertyEditor, ZComponentReg were found in required package . If they are removed there are no Zeos components on the tool p...

Pinging the DB server before every data access is very inconvenient. I think an OnLostConnection event would be very useful.

In my experience setting the timeout in .Properties has never worked (in MySQL anyway). I'll try looking into that further.

It appears that there is no way to disconnect a TZConnection. I tried the .Disconnect method and setting the .Connection property to False but each way .Connection is always true.

Using 7.0.3-stable with MySQL and MS SQL via ADO.

I think Zeos 7 could benefit enormously by having two very important features. 1. An event that fires when the connection is lost. This is very important in unstable environments like wireless networks. 2. A timeout property for ZConnection. Now with certain DBs (like I'm seeing now with MS SQL on A...

Note that if you have other Delphi and Zeos versions, you can temporarily rename the folders where the old Zeos units are in so you can install the new Zeos version without encountering this problem.

cmatrix , a good hint. But this is implemented by MySQL and here Zeos can't handle that AFAIK. http://stackoverflow.com/questions/243644/how-to-setup-a-connection-timeout-depending-of-the-user-login-in-mysql execute 'SHOW VARIABLES LIKE 'wait_timeout';'. The defaults are 28800 secs. So if you would...

If a Zeos app tries to connect to a non-existent MySQL DB it will hang indefinitely. This does not happen with ADO/MS SQL.

Adding a Timeout to the connection properties does nothing.

Looking through the previous posts this is a known issue. Anyone find a workaround?

Any plans for FireMonkey support in V7?

You can`t edit in the controls, as if the dataset is readonly. Using Zeos 7.0.0-dev with MS SQL 2008 connecting through ADO, Delphi XE. I downloaded it from Sourceforge not from svn. cmatrix , by saying "databound controls don't seem to work" you mean they doesn't show data, they can not e...

I converted a DB app to use Zeos7. All is OK except that databound controls don't seem to work. I've tried a DBEdit and a DBGrid hooked up to TZTables and TZQuerys with the same result. It's as if the zeos dataset are readonly. I checked the ReadOnly property but it is false. Am I missing something ...

Please indicate if my understanding is correct. The mssql protocol cannot be used with MS SQL 2005 and above. For MS SQL 2005 and up you need to use ado protocol. If so, how can I have the Data Link Properties dialog pop-up during run-time when a user selects the ado protocol from my options screen?

Thanks the alias did the trick. As for the queries they are simple SELECTs. The first query appears to except on merely trying to close the query before assigning text. I think the debugger is off by one line though. The second query excepts when simply trying to assign text to it. //q1 with DM.qry1...