Looking for the SQL Express 2012 driver and a connection problem
a
anonymous
started a topic
over 11 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Hi.
I've just installed MS SQL Express 2012 on my machine (for some development I've to do), and then activate its server.
When I try to create a new database connection in my registered DbVis 9.0, I face two problems:
1) I cannot find the .jar/.zip driver file when I choose "SQL Server 2008 (Micorsoft JDBC driver" option. Do you know where I could get them?
2) If I use the standard "SQL Server JTDS" drive, I'm able to create the database conenction (I could even ping the server), but when I try to open the connection I get this message: "I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property."... Other lof info are: "Type: java.sql.SQLException - SQL State: 08S01" ... What can I do?
Just for information: the native SQL Server Management Studio works fine (but I'd like to use my beloved DbVisualizer!)
Thanks in advance
Sergio
+Italy+
[This reply is migrated from our old forums. The original author name has been removed]
Re: Looking for the SQL Express 2012 driver and a connection problem
*Driver found*, from Microsoft web site!
I could go on....!
Sorry for my previous post...
a
anonymous
said
over 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Looking for the SQL Express 2012 driver and a connection problem
Still problems:
1) Using Microsoft Driver I cannot force anymore "Authenticatoin method: Windows", since the field disappears, and I keep getting errors on authentication:
Long Message:
Login failed for user ''. ClientConnectionId:b3e9a335-5b48-4540-9bb6-f924df3baf82
Details:
Type: com.microsoft.sqlserver.jdbc.SQLServerException
Error Code: 18456
SQL State: S0001
2) using JTDS driver version 1.3 (just downloaded from SOurceForge, I get the folowing messages:
net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0
Details:
Type: java.lang.UnsupportedClassVersionError
Stack Trace:
java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(Unknown Source)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$000(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at com.onseven.dbvis.S.L.ā(Z:2218)
at com.onseven.dbvis.S.B.Ą(Z:778)
at com.onseven.dbvis.db.A.G.ļ(Z:23)
at com.onseven.dbvis.db.A.G.ĭ(Z:497)
at com.onseven.dbvis.db.A.E.ĭ(Z:795)
at com.onseven.dbvis.db.A.D.execute(Z:808)
at com.onseven.dbvis.J.B.Y.ā(Z:3330)
at com.onseven.dbvis.J.B.K.Ă(Z:1374)
at com.onseven.dbvis.J.B.K.doInBackground(Z:1521)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
3) If I switch back to the native jtds driver in DbVis direcotry, I get this:
I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
Details:
Type: java.sql.SQLException
SQL State: 08S01
------------------------------------------------------------------------
:-( :-(
Any Idea or suggestion?
THANKS!
a
anonymous
said
over 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Looking for the SQL Express 2012 driver and a connection problem
> {quote:title=Sergio Sardo wrote:}{quote}
>
> 3) If I switch back to the native jtds driver in DbVis direcotry, I get this:
> I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.
>
Issue 3) solved: I've copied ntlmauth.dll from JTDS 1.3 folder to a folder covered by system path.
Anyway the original DbVis driver has had problems.
Now I'm able to connect the database :-)
The other issues are still open, but I stop working on them for a -long- while
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: Looking for the SQL Express 2012 driver and a connection problem
Sergio,
The jTDS 1.3 version is built for Java 7 and will not work with DbVisualizer which is built for Java 6.
In the next feature version for DbVisualizer will ntlmauth.dll automatically be loaded with no manual setup required.
Regards
Roger
a
anonymous
said
over 11 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Looking for the SQL Express 2012 driver and a connection problem
OK.
Thanks for the info.
Hoping in next future versions....
Anyway I keep using DbVis when possible: it's really a great product!
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: Looking for the SQL Express 2012 driver and a connection problem
Thanks!
Regards
Roger
Roger Bjärevall
said
over 11 years ago
[This reply is migrated from our old forums.]
Re: Looking for the SQL Express 2012 driver and a connection problem
Sergio,
The ntlmauth.dll is now automatically setup in the just just released 9.0.6 version.
http://www.dbvis.com/download/
Regards
Roger
anonymous