Search found 16 matches

by fjtrooper
15.09.2022, 19:42
Forum: ZeosLib 7.3/8.0 Forum
Topic: TZQuery without TZupdatesql
Replies: 2
Views: 160

Re: TZQuery without TZupdatesql

Ok perfect!
Thanks!
by fjtrooper
15.09.2022, 14:47
Forum: ZeosLib 7.3/8.0 Forum
Topic: TZQuery without TZupdatesql
Replies: 2
Views: 160

TZQuery without TZupdatesql

Hello! Can I use TZquery without TZupdateSQL? Or I will any problem if I don't use it?

Thanks!!!
by fjtrooper
23.02.2022, 17:00
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Now from Desktop APP I can connect to Mysql and Postgresql through ProxyServer, now the problem is that when I use a ZQuery and activate, I get an error: Code: "server" Message = "SQL Error: command string is a null pointer Code: 7" There was a problem when sending the SQL comma...
by fjtrooper
20.02.2022, 10:24
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Now from Desktop APP I can connect to Mysql and Postgresql through ProxyServer, now the problem is that when I use a ZQuery and activate, I get an error: Code: "server" Message = "SQL Error: command string is a null pointer Code: 7" If try to use a Table, when a click to TablaNam...
by fjtrooper
20.02.2022, 09:28
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

I've installed Lazarus 32bit and now it compiles perfect, the problem is 64bit compilation.

Thanks!
by fjtrooper
20.02.2022, 09:08
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Hi! Compilation error "ZDbcMySqlStatement.pas(2143,17) Error: identifier idents no member "AddAscii7Text"" still happens, but I've Lazarus 2.2.0 64bit, and fps 3.2.2. Perhaps compilation problem is because of Lazarus 64bit version. Should I use 32bit version for avoiding this and...
by fjtrooper
18.02.2022, 23:05
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Hello fjtrooper, I added all currently supported protocols to the proxy servers. Please update your sources from SVN. The proxy servers compile for me without problems. My configuration: Lazarus 2.0.12, Windows 32 bits, FPC 3.2.2. Please let me know, if this fixes your problems. Best regards, Jan o...
by fjtrooper
15.02.2022, 13:45
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Hello! I've tested and have theses problems: When I add ZDbcmysql to Proxyserver Application, doesn't compile, and get this error. ZDbcMySqlStatement.pas(2143,17) Error: identifier idents no member "AddAscii7Text" When I add ZDbcpostgresql to Proxyserver Application, it compiles perfect. A...
by fjtrooper
13.02.2022, 22:28
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

The proxy server doesn't include all protocols by default. My mistake. Please add ZDbcMySql to the uses clause of the zeosproxyunit.pas or to the ZDbcProxyServer.pas - depending on wether you use the server service or the server application. That should add mysql to the list of available protocols....
by fjtrooper
11.02.2022, 10:33
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

[General] Database Prefix = db. Security Prefix = sec. ;IP Address = 0.0.0.0 Listening Port = 8000 [db.bdfarmacia] ClientCodepage = UTF8 Database = bdfarmacia HostName = 127.0.0.1 LibraryLocation = c:\library\libmysql.dll Protocol = mysql [db.test] ClientCodepage = UTF8 Database = test HostName = lo...
by fjtrooper
10.02.2022, 23:36
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

I forgot tell you that I'm using version 8
by fjtrooper
10.02.2022, 13:25
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Perfect! Now it seems to connect. I have now a new error message :( When I acitvate ZConnection the error message is: Code="Server" Message= "Requested database driver was not found" In ZConnection I set Protocol WebServiceProxy, and LibraryLocation is my libzdbcproxy.dll locati...
by fjtrooper
10.02.2022, 10:26
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Perfect! Now it seems to connect. I have now a new error message :( When I acitvate ZConnection the error message is: Code="Server" Message= "Requested database driver was not found" In ZConnection I set Protocol WebServiceProxy, and LibraryLocation is my libzdbcproxy.dll locatio...
by fjtrooper
08.02.2022, 14:57
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

I did the configuration, but Lazarus hangs when I activate ZConnection until I stop WebServiceProxy, never connect, and I receive an error message like this. HTTP Request to https://localhost:8000/serices/IZeosProxy Failed It tries to find "https" and not "http" by default? Thanks
by fjtrooper
08.02.2022, 14:41
Forum: ZDBC (ZEOS Database Connectivity)
Topic: WebServiceProxy Example
Replies: 19
Views: 1593

Re: WebServiceProxy Example

Ok thanks, I'll try and I'll give you feedback.

THX