Zeoslib Portal

Hello Michael, I have written components, that make use of the Zeos components. It seems, that I need to know which version of Zeos I am compiling against. Is there any constant to check, wether I compile against Zeos 6 or Zeos 7? Ich habe einige Komponenten geschrieben, die Zeos benutzen. Es schein...

Hello,

I am currently using some components with Zeos 6 and would like to also be able to use them with Zeos 7. Unfortunately Some Classes changed the units, where thys reside. So is there a constant defined anywhere do make some conditional compiles for this?
Best regards,

Jan

Hello jascha, I think your best option for your problem is to use TClientDataset from Delphi or TJvMemoryData from jedi or something like that. Lazarus also has a component like this. Most probably you will have to copy the records into the target Data Set by yourself. But once you fiish, everything...

Hello Henk, I have no suggestion for this problem. To me it seems like something strange is going on with the ADO-ODBC-Bridge. For testing this I would need more information about your setup - Which Database do you want to connect to (MS SQL, Sybase ASE, ...), which Version of the Database do you us...

Hello hstijnen, when I try to create an ODBC connection string for ADO it always looks somewhat like this: Provider=MSDASQL.1;Persist Security Info=False;User ID=sysdba;Data Source=Test So I suggest for you to set the following: DBsettings = "Provider=MSDASQL.1;Persist Security Info=False;User ...

Hello,

I tried to insert into a BLOB field in a firebird database, using an insert statement in a TZQuery object. This failed with an EZIBConvertError-Exception. To make this work, I had to do a small change which is appended as a file.
Best regards,

Jan

Hello Sorien,

which transaction isolation level did you set in the first connection component? I tried this with Firebird 2.1 and a transaction isolation of tiReadCommitted and things worked as expected.
Best regards,

Jan

Hello hstijnen,

you need to define the DSN on the computer where the program is running. The DSN in turn has to refer to the external computer where tha database server is running.
Best regards,

Jan

Hello,

The problem seems to have resolved itself somehow.
I am sorry for the trouble...
Best regards,

Jan

Hello :) I finally have my first testproject and have a problem. In most of my Projects I use a structure similar to this: ZConnection1.Connect; ZConnection1.StartTransaction; try [do someting] ZConnection1.Commit; except ZConnection1.Rollback; end; ZConnection1.Disconnect; With Zeos 7 this raises a...

Hello hstijnen, I think this is not the scope of database connection components. As far as I know there is no common mechanism to know if a VPN connection has been made because there are a lot of different kinds of VPNs. In Windows most VPN Connections install their own virtual network card. Maybe y...

Hello pawelp,

the svn location of that code is https://zeoslib.svn.sourceforge.net/svn ... gonhugeist
the user that is working on that branch is egonhugeist

Best regards,

Jan

The only solution would be to advise the db somehow to eliminate any non win1252 charackters table by table. I think, this can only be done by an external application - get the data in unicode, eliminate all non-WIN1252-characters and write it back into the database. but that would take a serious a...

If you want to remove them from the database - that should be possible with Ansi-Delphi. But if removing the characters from the database is not an option then it will not be possible unless you use utf8-conversion functions or some kind of additional translating columns in your dataset or something...

You are right, WIN1252 is the correct codepage for a german windows. Is the contents of your database from your german customers? Or do they have different contents where the transliteration error would not occur? Zeos 7 is still in an alpha state. So if you use Zeos 7, you would have to test your a...