Re: AssemblyFileSet (was Re: [nant-dev] Custom Function to select from ODBC datasource...)

Thu, 13 May 2004 19:46:25 -0700 

Sounds good. I'll take a look at it.
Ian
Jaroslaw Kowalski wrote:

+1 for this idea.

Jarek

----- Original Message ----- From: "Gert Driesen" <[EMAIL PROTECTED]>
To: "Ian MacLean" <[EMAIL PROTECTED]>; "John Cole" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 6:42 PM
Subject: AssemblyFileSet (was Re: [nant-dev] Custom Function to select from
ODBC datasource...)




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






-------------------------------------------------------
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




--
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

Reply via email to