ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Mularien <pmular...@deploy.com>
Subject Re: SQL task for MS SQL server 2000
Date Thu, 08 Nov 2001 16:46:20 GMT
Have you tried connecting to the database from a JDBC program using
these same parameters?

Have you tried ant -verbose or ant -debug?

If you try the latter, please send the relevant output.

Peter

Sugandha Shah wrote:
> 
> I get this error
> Severity 14, State 1, Procedure 'null null', Line 0 Unable to connect,
> please check your
> server's version and availability.
> 
> and
> 
>  Severity 14, State 1, Procedure 'null null', Line 0 Unable to connect,
> please check your
> server's version and availability.
> 
> ----- Original Message -----
> From: "Peter Mularien" <pmularien@deploy.com>
> To: "Ant Users List" <ant-user@jakarta.apache.org>
> Sent: Thursday, November 08, 2001 9:45 PM
> Subject: Re: SQL task for MS SQL server 2000
> 
> > What are the errors you're getting??
> >
> > Peter
> >
> > Sugandha Shah wrote:
> > >
> > > Hi All,
> > >
> > > I 'm trying to use sql task for MS SQL server 2000.
> > >
> > > But somehow it doesn't seem to work.Though same task works for
> Oracle.(after changing the driver string)
> > >
> > > <target name="sql" depends ="build,replace,property" description=
> "creates user">
> > >    <sql
> > >     driver= "weblogic.jdbc.mssqlserver4.Driver"
> > >        url =
> "jdbc:weblogic:mssqlserver4:${DataBaseServiceName}@${DBServerName}:1433"
> > >     userid = "sa"
> > >     password = "sa"
> > >     onerror = "continue" >
> > >    <transaction  src="${HOME}/DatabaseScripts/createuser.sql" />
> > >    </sql>
> > >         </target>
> > >
> > >  <target name="sql1" depends="build,replace,property,sql" description=
> "creates tables">
> > >       <sql
> > >        driver= "weblogic.jdbc.mssqlserver4.Driver"
> > >        url =
> "jdbc:weblogic:mssqlserver4:${DataBaseServiceName}@${DBServerName}:1433"
> > >         userid = "rm_user"
> > >         password = "remote"
> > >         onerror = "continue" >
> > >     <transaction src="${HOME}/DatabaseScripts/ImodeDatamodel.sql" />
> > >     <transaction src="${HOME}/DatabaseScripts/populatedata.sql" />
> > >      <transaction src="${HOME}/DatabaseScripts/Image_map.sql" />
> > >   </sql>
> > >       </target>
> > >
> > > Any help will be appreciated.
> > >
> > > Thanx
> > > -Sugandha
> >
> > --
> > To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
> > For additional commands, e-mail: <mailto:ant-user-help@jakarta.apache.org>
> >
> 
> --
> To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
> For additional commands, e-mail: <mailto:ant-user-help@jakarta.apache.org>

--
To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:ant-user-help@jakarta.apache.org>


Mime
View raw message