wouldn't this work?
<sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://localhost\myinstance:1433;DatabaseName=$
{the.database.i.wanted.to.pass}"
userid="sa"
password="${the.password.of.the.database.i.wanted.to.pass}"
src="cleanDB.sql"
/>
>-----Original Message-----
>From: Moran Ben-David [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 25, 2005 8:43 PM
>To: 'Ant Users List'
>Subject: RE: sql task sp_dboptions problem
>
>Sorry Razwan,
>
>I am not familiar with the <sql> task enough to help you on
>that. However,
>one thing I can suggest is that instead of using the tasks'
>"src" attribute,
>you put the sql from cleanDB.sql in you're ant file as such:
>
>
><sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>url="jdbc:microsoft:sqlserver://localhost\myinstance:1433;Datab
>aseName=on_de
>velop" userid="sa" password="on_develop">
>
> -- example code from cleanDB.sql
> DROP DATABASE ${the.database.i.wanted.to.pass};
>
></sql>
>
>Moran
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
