There's an MS Knowledge Base article at http://support.microsoft.com/default.aspx?scid=kb;EN-US;310374 that explains why you get this error.
HTH, --Roelof
John Cole wrote:
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
Buildfile: file:///C:/Documents and Settings/jcole/My Documents/src/UtilityCenter/default.build
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>
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.
------------------------------------------------------- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 _______________________________________________ NAntContrib-Developer mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/nantcontrib-developer
