Zeoslib Portal

Hi,

I use the "datetime" datatype for this timestamp in the ms sql-server database.

woec

Thank you for the hint.

I tried it, but it does not solve the problem - no change in behavior.

The datetime value is already defined as ftDateTime Parameter type in the TZQuery properties.
Also, I tried different settings for size and precision for this parameter, but also no change.

woec

Hi, in my database application I insert log data into ms sql-server database using ado protocol (ZeosLib 7.2.4 stable, Lazarus 1.8.4 Win 32 and Win64). Log data contains a datetime timestamp. I encountered the problem, that the millisecond part of the timestamp data is lost at the insert. Only the d...

Hi, Jan

if try what you suggest, I get the file-selection dialog opened, so the object expects a file reference to a database. There is no possibility to select connection properties.
Do you have any further suggestions?

Best regards,
Johann

Hi Jan,

thank you for your reply. Up to now, I did not find any possibility to supply a working parameter neither any support from the IDE in any of the used class object properties. Can you give me more specific hints, where to find the IDE pop-up support you meant?

Regards,
Johann

Hi, I experienced a query timeout after 30 seconds on executing a query lasting longer than this limit on querying from the sql-server (2008R2) using the ADO protocol. How can I set the query timeout to a higher value? I did not find any possibility for that. Supplying additional parameters on the c...

Hi, actually for some mistake I made in getting the source, I used not the last source code. After correcting this, ADO works in my environment. Furthermore I noticed, that connections with ADO work with TZConnection Object, but not when I use TZConnectionGroup. In this case I get a connection error...

Hi,

I tried to configure ADO protocol for my MS SQL Server Database connection. But ADO protocol ist not in the list to select from.
I use zeos-7.2.0-beta-r3472 and lazarus 1.2.6 on win7/32
Are there any additional steps to prepare this protocol type?

regards
Johann

Hi Michael,

thanks for your reply. Please tell me, wich additional part(s) of code beyond the fragment I supplied as example in my first post of this thread you need.

Best regards,
Johann

Hi, Michael thanks for reply. I tried at design time and get the same error message about the missing parameter, wenn I try to set the Procedureobject to Active. Also I noticed, there is no possibility to assign a value to a parameter at design time ? I use msdblibd.dll (Build 2012-11-08) Protocol F...

Hi, I tried to call Stored Procedures using TZStoredProc on MS SQL Server 2008 and I experience problems submitting parameters: Here is my code (fragment): with SP1 do begin StoredProcName := 'test'; p0:=params.createparam(ftDateTime,'@par1',ptInput); p1:=params.createparam(ftVariant,'@par2',ptInput...

Hi, maybe I should put my problem into the database servers -> ms sql server - thread. There I found a similar problem description in the entry http://zeos.firmos.at/viewtopic.php?t=3483. The contributor solved it by declaring a resultparameter prior to the input parameter. This makes the input para...

Hi, I tried to call a storedprocedure using TZStoredProc Object with a parameter set. Seems, the parameter setting is ignored - the procedure is executed, but the default parameter defined within the stored procedure on the database server is used. I place a TZStoredProc Object onto the form and set...