• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Ant, JDBC, MS SQL Server

 
Unnsse Khan
Ranch Hand
Posts: 511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What's up with the "Good Riddance" closing greeting?
 
Rudy Dakota
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64721
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Unnsse Khan
Ranch Hand
Posts: 511
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My sentiments exactly.......
 
Rudy Dakota
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 64721
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic