On Monday, 6 February 2017 at 14:27:24 UTC, Adam D. Ruppe wrote:
> On Monday, 6 February 2017 at 14:17:39 UTC, FrankLike wrote:
>> [Microsoft][ODBC SQL Server Driver]The connection is busy resulting in another hstmt
>
> Process one result before trying to do another query. If you need the data stored, you can do foreach and save the parts you want to an array (it returns strings for all data types so you can append it to a string[])

Thank you. Yes,I do it now,but I find the mysql-Native can do like this.

>>  std.socket.SocketOSException@std\socket.d(2755): Unable to connect socket: Can not connect because the target computer actively refused.
>
> Check the firewall or connection accept settings on the computer running the database server, it is probably blocking you.

Thank you.I test it tomorrow.

On Thursday, 2 February 2017 at 13:28:48 UTC, Shachar Shemesh wrote:
> On 02/02/17 14:50, Adam D. Ruppe wrote:
>> On Thursday, 2 February 2017 at 05:33:57 UTC, FrankLike wrote:
>>>  For example, I want to do the  execution of stored procedure for
>>> MSSql、MySQL database. I found in Mysql-d, Mysql-Native, arsd, DDBC,
>>> etc. there is no result.
>>
>> db.query("CALL my_procedure(args...)");
>
> Generally speaking, you really don't want to do that. Ever. This code is how SQL injection vulnerabilities are born.
>
> Arguments should ALWAYS be passed out of line of the actual call command, so that the server has no chance of confusing arguments and commands.
>
> Sadly, that typically requires a DB library specific to the DB in use.
>
> Shachar
Do you really think that Adam does not know what is SQL-injection?