I would like to request that the following change be made to the
SqlHelper.cs file in the Util directory of the src tree.
I am experiencing a timeout on my executing SQL task and it is resulting
in a timeout.
Here is the chunk of code to change, with the mod.
/// <summary>
/// Executes a SQL statement.
/// </summary>
/// <param name="sql">SQL statement to execute</param>
/// <returns>Data reader used to check the result</returns>
public IDataReader Execute(string sql)
{
OleDbCommand command = new OleDbCommand(sql, _connection);
//set the timeout to be infinite
command.CommandTimeout = 0;
if ( _transaction != null )
command.Transaction = _transaction;
return command.ExecuteReader();
}
The change is the addition of the line "command.CommandTimeout = 0;" If
this line is not present, then the default timeout is 15 second (I
think) and it way too short for the SQL commands that I run in my
script. A better solution might be to have this as a attribute on the
<sql> task itself.
My company's firewall blocks CVS access, so I cannot provide a cvs diff
file at this time.
Thanks,
Jason
-----Original Message-----
From: Brant Carter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 7:34 PM
To: [EMAIL PROTECTED]
Subject: [NAntC-Dev] SlingShot and VB Projects
I just downloaded the latest CVS source and was having trouble getting
it to
work with my VB.NET projects. I have traced the problem to a recent
check-in.
Solution.cs Revision 1.4 added the following lines:
string commonProjectId = "{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}";
string enterproseProjectId = "{FE3BBBB6-72D5-11D2-9ACE-00C04F79A2A4}";
this is fine for C# projects but the commonProjectID for VB projects is
different, it is {F184B08F-C81C-45F6-A57F-5ABD9991F28F}. This is easily
verifiable by creating a solution with a VB project and a C# project,
then
open the SLN file.
I am very new to this project (and source forge in general), and I am
unsure
how to submit the fix.
brant
...
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail
-------------------------------------------------------
This SF.NET email is sponsored by: A Thawte Code Signing Certificate
is essential in establishing user confidence by providing assurance of
authenticity and code integrity. Download our Free Code Signing guide:
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0028en
_______________________________________________
NAntContrib-Developer mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/nantcontrib-developer
-------------------------------------------------------
This SF.NET email is sponsored by: FREE SSL Guide from Thawte
are you planning your Web Server Security? Click here to get a FREE
Thawte SSL guide and find the answers to all your SSL security issues.
http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en
_______________________________________________
NAntContrib-Developer mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/nantcontrib-developer
