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 Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 63057
    
  69

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: 63057
    
  69

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Ant, JDBC, MS SQL Server
 
It's not a secret anymore!