Originally posted by Zhang Alan:
a o~
That is a link to microsoft...
And ,cann't open the download page...
But,thank you all the same.
Originally posted by Maximilian Stocker:
And why don't you use the jtds driver then... since it works.
Originally posted by Maximilian Stocker:
And why don't you use the jtds driver then... since it works.
Originally posted by Zhang Alan:
I have already had a jtds driver.
But I got a error,which I said in my topic.
So I want to change to ms sqlserver driver.
Originally posted by Maximilian Stocker:
Also the MS link works fine for me. I can get to the page and download the setup file so if it doesn't work for you something is wrong with your internet connection or browser.
Originally posted by Maximilian Stocker:
The JTDS driver is FAR less buggy than the ms one. I have never seen that error before with JTDS and since there are no native components to the JTDS driver I would conclude that the error you posted has nothing to do with the driver. That error is something else wrong.
Please post the top part of your stack trace and the offending code. There is another bug in your program/setup which you currently have misidentified.
Originally posted by Zhang Alan:
May be.
The protocal of the page is https.May be this is the point.
Originally posted by Maximilian Stocker:
The JTDS driver is FAR less buggy than the ms one. I have never seen that error before with JTDS and since there are no native components to the JTDS driver I would conclude that the error you posted has nothing to do with the driver. That error is something else wrong.
Please post the top part of your stack trace and the offending code. There is another bug in your program/setup which you currently have misidentified.
Originally posted by Maximilian Stocker:
Okay I did more research and found the error. You are attempting to use Windows authentication. Use SQL Server authentication instead.
Originally posted by Maximilian Stocker:
When you come back see my previous post about SQL server authentication vs Windows authentication.
Another is a console application. This one cannot work.
If the error is caused by the difference of these two authentications, I can't have a application can work well because the database of these two application is same
JDBC will only work when your SQL Server instance uses "SQL Server and Windows" authentication. You cannot connect to a SQL Server instance via JDBC (regardless of which driver you use) with "Windows only" authentication.
I am useing the SQL Server authentication. I have read the topic of this problem which may be you read right now. And he(she) change to use ms driver at last. So.....
"console application"? - not sure what you mean by that. Do you just mean a stand alone Java application?
No, you're not. You're not specifying a user name and password, neither in your URL nor in the getConnection() call. That's why jTDS is trying to use the native DLL to authenticate: by not specifying a user name and password you're asking it to use the current Windows user's credentials to log in.
That's wrong. jTDS is able to connect to SQL Server using Windows Authentication, either by using a native DLL or if the user specifies a domain property in the url, in which case the user and password properties are used as Windows credentials.
[OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Don't get me started about those stupid light bulbs. |