Devart Forums

Stellar

Hi there,

Thanks for your information but in order to investigate low performance of our driver please send us all table files (*.DBF, *.CDX, *.FPT, etc.) where the issue occurs.

You can send them using the contact form at our site:
https://www.devart.com/company/contactform.html

Regards
Sergey

Stellar

Hi there!

Thank you for contacting our forum!

The time-out for connecting to the server is set in seconds; by default, the parameter is set to a 15 seconds value.
Please also note that the actual time-out may be slightly longer than the specified value.

Should you have any questions, do not hesitate to ask!

Stellar

Hi there,

When the data in the locally sorted dataset is changed the recordset is automatically sorted.
To solve this issue, you may sort data on server, or make changes on the server, and then update the dataset.

Regards,
Sergey

Stellar

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.

Stellar

To get the actual number of records, you need to use either the TUniQuery.Options.QueryRecCount property:
https://www.devart.com/unidac/docs/deva ... ccount.htm

var
RecordCount: Integer;
begin
UniQuery1.Options.QueryRecCount := True;
UniQuery1.SQL.Text := 'SELECT * FROM Dept';
UniQuery1.Open;

UniQuery1.RecordCount;
end;

Stellar

Hello,

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.

Best regards,
Sergey
Devart Team
www.devart.com

Stellar

Hello,

ODBC Driver for xBase is designed with using SQLite engine, therefore to compose queries using our drivers, you can use the syntax used in SQLIte: sqlite.org/lang.html
In most cases, our driver supports the SQLite syntax. To limit the number of rows returned for a query, please use the LIMIT clause. For example:

Code: Select all

SELECT TOP 5 A.VendorId, A.Code, A.Name 
FROM Vendors as A 
LIMIT 5

Should you have any questions, do not hesitate to ask!
Best regards,
Sergey
Devart Team
www.devart.com

Stellar

Hi Eden,

Please note that this forum is created for technical requests only.
Please use the contact form below in order to reach our billing team by email so they could assist you with this question:
https://www.devart.com/company/contactform.html

Regards,
Sergey

Stellar

Hello,

Thanks for your request, I will gladly assist you further.
Find out how to use our products in the applications supporting DataSnap technology at https://blog.devart.com/using-dac-produ ... pment.html

Should you have any questions, do not hesitate to ask!
Best regards,
Sergey
Devart Team
www.devart.com

Stellar

Hello,

If you are not able to connect to the server in the Direct mode, but connection is successfully established through OLE DB, the most probable reason for this is that a TCP connection to the server is not allowed.

You can use the documentation to configure a remote connection to the server:
blogs.msdn.microsoft.com/walzenbach/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008/
support.microsoft.com/en-us/help/968872/how-to-open-the-firewall-port-for-sql-server-on-windows-server-2008#LetMeFixItMyselfAlways

Should you have any questions, do not hesitate to ask!
Best regards,
Sergey
Devart Team
www.devart.com

Stellar

Hi there,

We have added the description of constants for Data Type Mapping into correspondent article:
https://www.devart.com/unidac/docs/using-postgresql.htm

Regards,
Sergey

Stellar

Hi Roman,

The loss of the string value part occurred when storing a Unicode string in a VARCHAR field in the database, for instance:

Code: Select all

CREATE TABLE T1 ( 
    [fid] [int] NOT NULL, 
    [fname] [varchar](50) NULL)

Code: Select all

MSQuery1.SQL.Text := 'INSERT INTO t1 ( fid, fname ) VALUES ( :fid, :fname )' ; 
MSQuery1.Params[0].ParamType := ptInput; 
MSQuery1.Params[0].DataType := ftInteger; 
MSQuery1.Params[1].ParamType := ptInput; 
MSQuery1.Params[1].dataType := ftWideString; 

MSQuery1.Prepare; 
MSQuery1.Params[0].AsInteger := 1; 
MSQuery1.Params[1].AsWideString := '121222'; 
MSQuery1.Execute;

Regards,
Sergey

Stellar

Unfortunately, we couldn't reproduce the issue. To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us, including database objects creating scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html

Stellar

SDAC doesn't provide information about which provider was used to connect, but you can find out about the used client:

Code: Select all

uses
  MSClasses;

procedure TForm1.Button1Click(Sender: TObject);
var
  St: String;
  MSSQLConnection: TMSSQLConnection;
begin
  MSSQLConnection := TMSSQLConnection(TDBAccessUtils.GetIConnection(MSConnection));

  if MSConnection.Connected then begin
    St := MSSQLConnection.GetServerVersionFull;
    if st <> ':' then
      Memo1.Lines.Add(St);
  end;
  if (MSConnection.Options.Provider <> prCompact) and
     (MSConnection.Options.Provider <> prDirect)
  then begin
    St := MSSQLConnection.GetClientVersionFull + ': ' + MSSQLConnection.GetClientVersion;
    if St <> ': ' then
      Memo1.Lines.Add(St);
  end;
end;

Stellar

The Direct mode doesn't support this syntax. What error message are you getting?
In order for us to be able to give a more concrete answer, please specify the exact error message.

Devart Forums

Search found 571 matches

Re: Visual Foxpro - Slow Recordset Parse

Re: Connection Timeout

Re: process all records in sorted dataset

Re: TSQLMonitor not supported on Delphi 10.4 Pro.

Re: The RecordCount property of the TUniQuery component has a bug

Re: How to connnect the SQL SQL SERVER Express in Direct Mode?

Re: Error using Select TOP with foxpro

Re: Could dbexpsda40.dll not exist in Deployment?

Re: How to connect Datasnap

Re: How to connnect the SQL SQL SERVER Express in Direct Mode?

Re: DataTypeMap.AddDBTypeRule(?,ft...);

Re: Trimmed string param bug

Re: OLE DB error Code 80040E00h

Re: Get the used provider

Re: TUniConnection - SQL Server, direct with instance name