Zeosdbo 6.6 6 Stable
ZEOSDBO-6.6.3-stable merupakan versi terbaru dari Zeos yang berfungsi mengkoneksikan Delphi – dengan database. Yang mau dibahas disini adalah koneksi dengan MYSQL. Extract ZEOSDBO-6.6.3-stable.rar yang bisa anda Download di Sini 2. Buka Delphi 7 anda. Pilih File – Open, kemudian Cari dimana Folder tempat dimana anda menaruh extract tadi.
What component are you using to access the Zeos data? Is it a TADO component? What kind of connection are you establishing? There are timeout settings at both the query component level and the connection level.
Unless you are setting both of those with the same value, the timeout will be the lowest of the settings. For instance, if you set the query's timeout to 5 minutes but don't change the connection setting, your query will sutill time out in 30 seconds because that is the default for the connection. Similarly, if you set the timeout on the connection to 5 minutes but don't change the query component's setting, your query will timeout in 30 seconds because that is also the default for the query component.
Finally, you may need to optimize your query and/or make sure you have the right indexes on the database on the ZEOS side. Are you working with SQL Server or with Firebird? The link seems to talk a lot about interfacing with Firebird, is why I ask. I am not at all familiar with the components you are using. If the TZQuery and TZStoredProcedure do not offer a TimeOut (or CommandTimeOut) property, then they will be using a default, which is (once again) probably 30 seconds. If you cannot change that setting then I would highly recommend using a different componet because, even though you can set the connection timeout, the default setting in the query or stored procedure component will be the controlling factor. If it is surfaced to you by the components, you should be able to either find the Timeout property in the list of properties or find information about setting that property in the Help for the component.
If all else fails, you might want to contact the people who make those components and ask them how to set the timeout for the query/SP components. Installer aplikasi persediaan 2011 gmc. If I remember correctly, Zeos is an IBM operating system. In any case, no matter the source of the OS, you should be able to get an ADO driver from the vendor so that you can use TADO components. The TADO components come with Delphi (reducing costs) and I know that they do have timeout settings for both the connection and the query/SP components. Hmmm, ZEOS is not exactly a unique product name, then.:-/ As I said before, I am not familiar with the components (I've never used them because I find TADO to be really good;-). You will need to either check the Help or the components' property lists or check any on-line help that the vendor offers. However, I am fairly certain that the essence of the problem is that you are setting the connection timeout but still getting impacted by the query/stored procedure component timeout.
This may be a flaw in the design and implementation of those particular components. If so, then you may have to live with the problem until it is addressed by the vendor or convert to other components. As an aside, this is another reason that I tend to stick with the TADO components. I have a known entity that is shipped as a part of the product and, therefore, is thoroughly tested for use with the product. It also has a fairly large user base. In ADO, you should be able to set the timeout in the connection string and in the query component. Most components tend to have a default of 30 seconds, so it is not at all uncommon for someone to want to specify a different timeout period and to need to be able to do it to almost any component (because you never know which component is going to be used;-).
The additional memory helping with the problem would kind of make me nervous. Unless you can get some (reasonable) explanation from the vendor, how can you know when the problem will revisit you?:-/.