I’ve done a little refactoring of the SqlTask, mainly in the SqlHelper class, to ease the addition of new connection types.  I did this in order to use MySQLConnection to connect to a MySql database with the SqlTask.  To get the connection I used the bytefx MySql classes at http://sourceforge.net/projects/mysqlnet.

 

Here’s my task:

            <sql     

connstring="Data Source=ipadev2;Database=mysql;User ID=root;Password=root;COMMAND LOGGING=false"

                        sqltype="MySql"

                        transaction="false"

                        delimiter=";"

                        delimstyle="Line"

                        output="results.txt"

            >

                        select * from user

            </sql>

 

Can this be added to CVS?  Here’s a summary of my changes:

 

-          Changed and added .cs files.

-          Included ByteFX.Data.dll with the source.

-          Update NAntContrib.build to reference ByteFX.Data.dll.

 

Are the any licensing issues that need to be addressed?

 

Included is a zip including the new files and a .patch for the changed file.

 

If I messed anything up or need to do anything else let me know.

 

Thanks!

 

Jason Pettys

 

Workforce ROI Corp.

Fargo, ND

Attachment: mysql.zip
Description: mysql.zip

Reply via email to