File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Ant, JDBC, MS SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Ant, JDBC, MS SQL Server" Watch "Ant, JDBC, MS SQL Server" New topic
Author

Ant, JDBC, MS SQL Server

Unnsse Khan
Ranch Hand

Joined: Nov 12, 2001
Posts: 511
Hello,
I am having trouble using Ant and MS SQL Server... Here's the info:
<target name="run.prelim.sql" depends="" >
<sql
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://baba:1433;database=FishStore"
userid="foobar"
password="barbaz"
rdbms="mssqlserver"
>
<transaction
src="E:\Apps\FishStore\FishScripts\test.sql"/>
</sql>
</target>
When I run this ant target:
BUILD FAILED
E:\Apps\FishStore\FishScripts\build.xml:45: java.sql.SQLException: [Microsoft][SQL Server 2000 Driver for JDBC][SQLServer]Login failed for user 'foobar'. Reason: Not associated with a trusted SQL Server connection.
Any suggestions, hints, & tips?
Kindest regards,
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Hi Unnsse,
By the sound of it I suspect it 's the security settings of the SQL Server instance you 're working with. Could it be the instance is set to accept only windows authentication, thus barring logins using explicit username/password?
Good riddance,
Rudy.
Unnsse Khan
Ranch Hand

Joined: Nov 12, 2001
Posts: 511
What's up with the "Good Riddance" closing greeting?
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Nothing much. I just think it fits nicely with the ranch theme, just as my display name does.
S' long,
Rudy
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61753
    
  67

What's up with the "Good Riddance" closing greeting?

Nothing much. I just think it fits nicely with the ranch theme

How does rudeness fit "nicely with the ranch theme"?
[ March 20, 2004: Message edited by: Bear Bibeault ]

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Unnsse Khan
Ranch Hand

Joined: Nov 12, 2001
Posts: 511
My sentiments exactly.......
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Unnsse, Bear, possibly others,
Please accept my apologies for any rudeness. I am afraid I have tried to leap further than my knowledge of english allows for in using the term 'good riddance'. I have in the meantime found out it is not exactly related to riding, as I thought. I must say, though, that I have not really found why it 'd be rude.
Anyway, inappropriate is also out of place, so I 'll close my post with:
Good riding,
Rudy.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61753
    
  67

I had a feeling that it was because you really didn't understand the phrase.
"Good riddance" is rude because it basically means "goodbye and I'm glad to see you go because I don't like you".
Rudy Dakota
Ranch Hand

Joined: Jul 27, 2002
Posts: 54
Thanks for the explanation, Bear. I can see how that fits to what I read in the dictionary. Would be great if those also gave this kind of explanation.
Good riding,
Rudy.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Ant, JDBC, MS SQL Server