RE: ant sql doesn't recognize the database server name with back slash?

slash... 10.23.23.2/sql5t9 -Rob Anderson -Original Message- From: Chaohua Wang [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2008 8:26 AM To: Ant Users List; [EMAIL PROTECTED] Subject: ant sql doesn't recognize the database server name with back slash? Hi Folks, I am using j

RE: ant sql doesn't recognize the database server name with back slash?

with back slash? Chaohua Wang wrote: > Hi Folks, > > I am using jdbc driver to connect database. I have 2 database. The url > is like this 10.23.23.1, another one is 10.23.23.2\sql5t9. > I am using jtds drvie to connect: jdbc:jtds:sqlserver://10.23.23.1 it > works fine. > But

RE: ant sql doesn't recognize the database server name with back slash?

atabase server name with back slash? Chaohua Wang wrote: > Hi Folks, > > I am using jdbc driver to connect database. I have 2 database. The url > is like this 10.23.23.1, another one is 10.23.23.2\sql5t9. > I am using jtds drvie to connect: jdbc:jtds:sqlserver://10.23.23.1 it > work

ant sql doesn't recognize the database server name with back slash?

Hi Folks, I am using jdbc driver to connect database. I have 2 database. The url is like this 10.23.23.1, another one is 10.23.23.2\sql5t9. I am using jtds drvie to connect: jdbc:jtds:sqlserver://10.23.23.1 it works fine. But for 10.23.23.2\sql5t9, is not working. message shows: java.sql.SQLEx

答复: how to load a bunch data from a tx t file, and ant sql call these data

ur work for you. But if you have specific questions about things you are having difficulty with, we are happy to help if we can. -Rob Anderson -Original Message- From: Chaohua Wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 3:52 PM To: Ant Users List Cc: [EMAIL PROTECTED]

how to load a bunch data from a txt file, and ant sql call these data

Hi Folks, I have a ant sql statement INSERT INTO Payment (RefNumber, VAN, Amount, OptCode, VendorID, PriorRefNumber, TransactionTS, IsProcessed) VALUES ('6569998989','2131213','1131',2031,232,'7898', { fn NOW()

RE: ant sql call stored procedure

. Keep in mind that the Ant sql task uses a jdbc connection, and cannot accommodate vendor specific statements that may work fine in the vendor supplied client. -Rob Anderson -Original Message- From: Chaohua Wang [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 9:23 AM To: Ant Users

RE: ant sql call stored procedure

y editing tool in Windows, e.g. UltraEdit32) and set the task's "encoding" attribute accordingly (see http://ant.apache.org/manual/CoreTasks/sql.html) BR, Olivier Original Message Subject: ant sql call stored procedure From: Chaohua Wang <[EMAIL PROTECTED]> T

ant sql src

Hi Folks, I read this link http://ant.apache.org/manual/CoreTasks/sql.html about ant sql. There is attribute src- File containing SQL statements. I am not sure this src is a sql statement or it is a stored procedure. I am using MS Sqlserver. Could someone give me a example? Please Help. cw

ant sql call stored procedure

Hi folks, I am using ant sql to call a stored procedure of Ms Sql server I can execute stored procedure in Ms Sql server. My stored procedure name is uspSelectCount. But when I am using ant sql to call the file uspSelectCount.sql that is located with the build file. I alway

a stored procedure example for an sql src.

Hi folks, could somebody give me a stored procedure example to let me call Very simple one select * from table. I am stuck in stored procedure. I just want to execute select.sql. I have created a stored procedure in my database. Thank you. cwang --

ant sql call stored procedure

Hi folks, I am using ant sql to call a stored procedure of Ms Sql server I can execute stored procedure in Ms Sql server. My stored procedure name is uspSelectCount. Then I use Execute--> File to generate a file called selectCount.sql. But when I am using ant sql to call the fi

RE: about ant sql connection being pulled out , into a property file

Thank you very much -Original Message- From: Steve Loughran [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 3:52 AM To: Ant Users List Subject: Re: about ant sql connection being pulled out , into a property file Chaohua Wang wrote: > Folks, > > I am usin

about ant sql connection being pulled out , into a property file

Folks, I am using ant sql, Because I have a few of ant sql statements, could you tell me how to put above part into a property file. So there is no duplicate code. In this part like something like this. Thank you cwang