ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "RADEMAKERS Tanguy" <Tanguy.RADEMAK...@swift.com>
Subject RE: sql task sp_dboptions problem
Date Thu, 25 Aug 2005 18:50:45 GMT
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:moran@place-base.com] 
>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: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message