You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 mORMot 1 » Error saving BLOB parameters using UniDac providers » 2017-01-24 11:40:57
- Shapoval
- Replies: 0
Hello,
I have a problem saving a BLOB to a database using the UniDac provider. You can see my (very simple) code here.
This works fine when I'm connecting to the database using the direct Oracle provider. However, it doesn't work when I try to use any UniDac provider (I've tried Oracle and PostgreSQL). For Oracle it gives the "Invalid hex number" error, for PostgreSQL it just saves wrong data.
I'm using Delphi 7.
#2 Re: mORMot 1 » Timeout connecting to HTTP server » 2017-01-19 06:58:11
Hello Arnaud,
It appears to be a client issue. Not really an issue, but the group policy, which disables internet access for any application except of the browser. It's a customers PC, so we just didn't have enough information on this.
Thanks for your help.
#3 Re: mORMot 1 » Timeout connecting to HTTP server » 2017-01-18 14:28:48
Hello Arnaud,
Thank you for the quick answer. It seems that we have another problem. When I checked the server using netsh http show urlacl, it displayed the right record for the database URL.
Reserved URL : http://+:80/syndbremote/
User: \Everyone
Listen: Yes
Delegate: Yes
SDDL: D:(A;;GA;;;WD)
For now we're using your HTTP server from the SynDBExplorer (12) sample, which does it automatically. Also the problem can only be observed on some client PCs. Some other clients work fine.
I've given you the wrong error description in the first post. The actual error is winhttp.dll error 12029 "A connection with the server could not be established".
#4 mORMot 1 » Timeout connecting to HTTP server » 2017-01-18 11:29:04
- Shapoval
- Replies: 5
Hello,
We're trying to implement a REST server using the TSQLDBServerHttpApi instance. That works in general, but we have a problem connecting to our server from some client PCs. The client application, which we run on these PCs, just returns the "timeout connecting to the server" error. The server is running on the port 80 and we also have an IIS instance running on the same port. The "problem clients" can access the IIS on the server (i.e. show the start page), but can't connect to the REST server on the same port. Does anybody have an idea, what could cause this problem?
Thanks in advance.
#5 Re: mORMot 1 » Determine the Field/Datatype of a Query » 2017-01-12 16:31:40
I've had the same question and examined the sources to find the answer. As far as I can see, data type of any field in a TQuery result set may be obtained the following way:
Query.PreparedSQLDBStatement.ColumnType(i)
where i is the column index.
Pages: 1