Ian, Wouldn't this by a good time to consider adding an AssemblyFileSet, and centralize that logic ?
Gert ----- Original Message ----- From: "Ian MacLean" <[EMAIL PROTECTED]> To: "John Cole" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 13, 2004 5:57 PM Subject: Re: [nant-dev] Custom Function to select from ODBC datasource... > Hi John, > Actually custom functions and tasks are two different things. To start > writing a custom task you might want to look at this article: > http://www.theserverside.net/articles/showarticle.tss?id=NAnt > as well as the sample in the nant sources > \nant\examples\UserTask\UserTask.cs. > > As to why you're getting that error - the script task doesn't currently > process the asis attribute properly ( its a bug ). I need to migrate > some logic from the compiler tasks to use the framework resolution stuff > to resolve system assembly references. > > try using the following for now: > > <includes > name="C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\System.Data.dll" /> > and it should work. I get the following on my machine: > > Function call > failed.System.Data.Odbc.OdbcExceptionSystem.Data.Odbc.OdbcException: > ERROR [IM002] [Microsoft][ODBC Driver Manager] > Data source name not found and no default driver specified > at NAnt.Core.ExpressionEvaluator.EvaluateFunction(String > functionName, Object[] args) in h:\cvs\nant\src\NAnt.Core\ExpressionEv > aluator.cs:line 91 > at NAnt.Core.ExpressionEvalBase.ParseValue() in > h:\cvs\nant\src\NAnt.Core\ExpressionEvalBase.cs:line 595 > ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not > found and no default driver specified > > > Ian > > John Cole wrote: > > >Hello, > > First, thanks to everyone who helped get last nights CVS version to build, > >I was able to get both NAnt and NAntContrib built this morning. > > > > I need to pull some info out of a MySQL database, and I'd like to use > >ODBC for this. The SQL task in NAntContrib will only use oledb datasources, > >and the only one I found for MySQL is incomplete and does not work, so I'm > >attempting to create my own taks for running an ODBC query. The task is as > >follows: > > > >----------------------------------------------- > > <target name="initsql"> > > <script language="C#" prefix="odbc"> > > <references> > > <includes name="System.Data.dll" asis="true"/> > > </references> > > <code><![CDATA[ > > [Function("query")] > > public static string Query(string pConnStr, string pSQL, string > >pDelimiter) > > { > > string s = ""; > > System.Data.Odbc.OdbcConnection c = new > >System.Data.Odbc.OdbcConnection(pConnStr); > > System.Data.Odbc.OdbcCommand cmd = new > >System.Data.Odbc.OdbcCommand(pSQL, c); > > c.Open(); > > System.Data.Odbc.OdbcDataReader r; > > r = cmd.ExecuteReader(); > > > > while (r.Read()) > > { > > string line = ""; > > for(int i = 0; i<r.FieldCount; i++) > > { > > if (line.Length > 0) line += pDelimiter; > > line += r.GetString(i); > > } > > s += line + "\n"; > > } > > r.Close(); > > c.Close(); > > > > return s; > > } > > ]]></code> > > </script> > > <echo message="${odbc::query('DSN=mantis', 'select id, name, engine FROM > >custom_report', ', ')}" /> > > </target> > >------------------------------------------------------- > > > >This code runs from Visual Stuido, but I get the following error when I > >attempt to run this from within NAnt: > > > >------------------------------------------------------- > >NAnt 0.85 (Build 0.85.1594.0; net-1.1.win32; nightly; 5/13/2004) > >Copyright (C) 2001-2004 Gerry Shaw > >NAnt Team > > > >Buildfile: file:///C:/Documents <file:///C:/Documents> and > >Settings/jcole/My Documents/src/UtilityCenter/default.build > >Target(s) specified: initsql > > > >initsql: > > > > > >BUILD FAILED > > > >C:\Documents and Settings\jcole\My > >Documents\src\UtilityCenter\default.build(357,4): > >Compilation failed: > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(21,13) : > >error CS0234: The type or namespace name 'Data' does not exist in the class > >or namespace 'System' (are you missing an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(22,13) : > >error CS0234: The type or namespace name 'Data' does not exist in the class > >or namespace 'System' (are you missing an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(23,6) : > >error CS0246: The type or namespace name 'c' could not be found (are you > >missing a using directive or an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(24,13) : > >error CS0234: The type or namespace name 'Data' does not exist in the class > >or namespace 'System' (are you missing an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(25,6) : > >error CS0103: The name 'r' does not exist in the class or namespace > >'nant1fce0aafadd14e78ac9662d5dda7042c' > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(27,13) : > >error CS0246: The type or namespace name 'r' could not be found (are you > >missing a using directive or an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(30,24) : > >error CS0246: The type or namespace name 'r' could not be found (are you > >missing a using directive or an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(33,16) : > >error CS0246: The type or namespace name 'r' could not be found (are you > >missing a using directive or an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(37,6) : > >error CS0246: The type or namespace name 'r' could not be found (are you > >missing a using directive or an assembly reference?) > >c:\Documents and Settings\jcole\Local Settings\Temp\otnp2wzj.0.cs(38,6) : > >error CS0246: The type or namespace name 'c' could not be found (are you > >missing a using directive or an assembly reference?) > >------------------------------------------------------- > > > >I've tried using the <references> and <includes> tags, but I haven't found > >the right combonation. How can I get a script to get access to > >System.Data.Odbc? > > > >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. > > > > > > > > > -- > Ian MacLean, Developer, > ActiveState, a division of Sophos > http://www.ActiveState.com > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: SourceForge.net Broadband > Sign-up now for SourceForge Broadband and get the fastest > 6.0/768 connection for only $19.95/mo for the first 3 months! > http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click > _______________________________________________ > nant-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/nant-developers > ------------------------------------------------------- This SF.Net email is sponsored by: SourceForge.net Broadband Sign-up now for SourceForge Broadband and get the fastest 6.0/768 connection for only $19.95/mo for the first 3 months! http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click _______________________________________________ nant-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/nant-developers
