Hello, I am trying to use the builtin database engine FireDAC in Delphi XE8, we are using MS SQL Server as database.
FireDAC works pretty good but I have run into problems with some functionality in my application! I sometimes get a message like this "ODBC SQL Server driver, the connection is busy with the result from another hstmt...". I have found a temporary fix for this problem by setting the property RowsetSize (on the query) to a high number for example like this: "FetchOptions.RowsetSize := 30000;" This works fine but I wonder if there is a better solution to this problem? We have many customers with different sizes of databases that use this application and I don't know exactly how to set the RowsetSize! In this particular case 30000 worked fine.
Any suggestion or recommendation is appreciated!
Regards,
Kenbla
FireDAC works pretty good but I have run into problems with some functionality in my application! I sometimes get a message like this "ODBC SQL Server driver, the connection is busy with the result from another hstmt...". I have found a temporary fix for this problem by setting the property RowsetSize (on the query) to a high number for example like this: "FetchOptions.RowsetSize := 30000;" This works fine but I wonder if there is a better solution to this problem? We have many customers with different sizes of databases that use this application and I don't know exactly how to set the RowsetSize! In this particular case 30000 worked fine.
Any suggestion or recommendation is appreciated!
Regards,
Kenbla