Thanks for the reply.
Ok, so you cannot use ODBC with the SQL task. Is there a way to use the SQL
task to get to a MySQL database?
I tried using MySQLProv like below:
-------------------------------------------
<target name="readme_mantis">
<sql
connstring="Provider=MySQLProv;Location=cvs.uai.int;Data
Source=bugtracker;USER ID=nant;option=3;port=3306;"
delimiter=";"
delimstyle="Normal"
transaction="false"
>
select * FROM custom_report;
</sql>
</target>
-------------------------------------------
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
Error while executing SQL statement.
No error information available: DB_E_NOTABLE(0x80040E37).
-------------------------------------------
Any pointers would be appreciated
John Cole
-----Original Message-----
From: Roelof Blom [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 4:52 AM
To: John Cole
Cc: '[EMAIL PROTECTED]'
Subject: Re: [NAntC-Dev] using sql task to get to a odbc database...
Hi John,
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 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
