Zeoslib Portal

Hi, I have trouble with those DLLs, too (comerr32.dll and such). Sometimes in works to put them into the install directory of my client application, sometimes they need to be in the client's c:\Windows\System32, don't know why. Therefore, I would appreciate it if I could return to protocol postgresq...

Hi,

I use ZSqlProcessor, right. And the property change did exactly that *whew*

Zeos 6.5.1 ZSqlProcessor had no problems with Firebird Storedprocs and their local variables. Default behaviour must have been changed. Anyway, thanks a lot. You made my day :-)

ste_ba

Hi, I try to create a stored procedure that has already worked with FB Embedded 1.5, Zeos 6.5.1, Delphi7 and WinXP. Now (with Delphi 2007, Zeos 6.6.1, and Vista, but still FB Embed 1.5) the very same StoredProc fails. Strange: within the error message, all the local variables used in the script show...

Hi kamilozo,

looks like a completely different piece of cake. Maybe you should better start a new thread for that.

ste_ba

@swm: Have you tried reinstalling Delphi? That's what worked for me in the end. Uninstall Delphi (I deleted all Delphi Registry entries, just to be sure), delete Zeos folders, reboot, install Delphi, unzip and install Zeos 6.5.1. At least that made it work for some time - until it started all over a...

Looks like trouble ... here's what happened: Since I had a few deadlines to keep with my DB apps, I "solved" the problem for now by deinstalling Zeos and reinstalling 6.5.1 (oddly, it only worked to reinstall Delphi completely, reinstalling Zeos wasn't enough). Worked fine. Until five minu...

Hi cipto_kh,

it's not (only?) the specified collation, obviously, since TZConnection.GetTableNames won't work either, and I have worked with COLLATE before without any problems. I'm afraid I have no idea where it comes from.

ste_ba

Sorry ... since I was expecting a resultset, I thought it was obvious that I used TZQuery and Open :-) The first SQL command I send is SELECT COUNT(*) FROM RDB$RELATIONS WHERE upper(RDB$RELATION_NAME)=upper(_ISO8859_1 't_mytablename' COLLATE DE_DE); The ISO and collation specification come from a fu...

Hi, there must be some obvious mistake, but somehow I'm blind, I don't see it. Every SELECT statement I send to the Firebird server is answered with an error message 'Cannot retrieve Resultset data'. Tried with Firebird 2 and Firebird Embedded Server 1.5. Same scripts worked fine with 6.5.1. Details...

Are you sure it was between 6.6.0 and 6.6.1? That might have been a bit forejudged. As I can read the parser logic well, it's written to use only complete, delimited statements. Now it does. It did not before... I'm not sure this effect was desired or not. Probably 'end-of-strings' was seen as the ...

I experienced the same phenomenon. It works just as well if you have specified a different delimiter type, e.g. if you chose dtEmptyLine, just add an empty line to your script. However, it is understandable if one worries about their Zeos 6.5 apps not working properly anymore, since this behaviour o...

Mea culpa. I separated the computer name from the Service name with a slash, but as one might expect, Windows insists on a backslash. Hostname is now "MY_PC_NAME\MSSQLEXPRESS", and Bingo! it works.

ste_ba

Hi Mark, thanks for your answer. Concerning the dll, I had guessed something like that ... Sorry about the forgotten hostname. It's "localhost", however if I insert my computer name (with or without the name of the Service, which is MSSQLEXPRESS in my installation), it won't work either. s...

Hi, after installing Zeos 6.6.1 with Delphi7 and WinXP, I tried in vain to connect at design time to a local MS SQL Server 2005. Before that, I had successfully connected to the same MS server using Zeos 6.5.1, "ado" protocol and a connection string in the "database" property nam...

perhaps I'll update to the latest stable release. It's always good to have the latest things, but it may be some pain to do the updates... It may be so, but the moment one realises that dealing with the old version is more painful than the act of updating is probably the right moment to do it... ;)...