Thank you, '10.23.23.2\sql5t9' sql5t9 is a name instance, If I use
forward slash, sql5t9 will be treated as a Database name, instead of
name instance.
In this way, 10.23.23.2 can be recognized, but it is not
'10.23.23.2\sql5t9', so I will get login failed issue.
Do I need to track database? I can use '10.23.23.2\sql5t9' as server
name to login in with my password in Toad.


-----Original Message-----
From: Steve Loughran [mailto:stevel@(protected)]
Sent: Tuesday, March 25, 2008 10:25 AM
To: Ant Users List
Subject: Re: ant sql doesn't recognize the database 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
> works fine.
> But for 10.23.23.2\sql5t9, is not working. message shows:
> java.sql.SQLException: Unknown server host name '10.23.23.2\sql5t9'.
> Could you tell what is reason why? Thank you

Its up to the driver how it handles URLS; ant just loads the specific
driver and calls driver.connect(URL). If the driver is rejecting it, it
musnt support backslashes. Given the requirement to be a URL, which
means with forward slashes, this isn't that surprising.

-steve

--
Steve Loughran            http://www.1060.org/blogxter/publish/5
Author: Ant in Action       http://antbook.org/

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)