Hello,
I need to hit
a ODBC database (mysql through the ODBC driver) with NAnt. I tried using
the sql task but I get the following error:
----------------------------------
NAnt 0.85 (Build
0.85.1552.0; net-1.1.win32; nightly; 4/1/2004)
Copyright (C) 2001-2004 Gerry Shaw
http://nant.sourceforge.net
Copyright (C) 2001-2004 Gerry Shaw
http://nant.sourceforge.net
Buildfile: file:///C:/Documents and Settings/jcole/My
Documents/src/UtilityCenter/default.build
Target(s) specified: readme_mantis
Target(s) specified: readme_mantis
readme_mantis:
BUILD FAILED
INTERNAL ERROR
System.ArgumentException: The .Net Framework Data Provider for OLEDB
(System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC
Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC
(System.Data.Odbc).
----------------------------------
Here is my
taks
<target
name="readme_mantis">
<sql
connstring="Provider=MSDASQL;DSN=mantis"
delimiter=";"
delimstyle="Normal"
>
select * FROM custom_report;
</sql>
</target>
<sql
connstring="Provider=MSDASQL;DSN=mantis"
delimiter=";"
delimstyle="Normal"
>
select * FROM custom_report;
</sql>
</target>
I the DSN is good
and connecting to the database. Should I be using another provider? or is
this not possible with the SQL task?
Thanks,
John
Cole
-------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.
