Start a new topic

Looking for the SQL Express 2012 driver and a connection problem

[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...
[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!
[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
[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
[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!
[This reply is migrated from our old forums.]

Re: Looking for the SQL Express 2012 driver and a connection problem
Thanks! Regards Roger
[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