I don't think so, because the cleanDB.sql file still refers to a specific database. What I want to do is somehow pass a parameter to the cleanDB.sql file so that the file can be generic.
-----Original Message----- From: RADEMAKERS Tanguy [mailto:[EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:51 PM To: Ant Users List Subject: RE: sql task sp_dboptions problem 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
