[lrine]

I am new to Java and to myeclipse so hopefully I won’t embarrass myself. I am trying to connect to MSSQL Server using the Microsoft provided JDBC driver.

The connection string I am using works in an Eclipse environment. The driver template (Other MSSQL 2008 is not available from myeclipse.

With myeclipse, I either get an error that the driver is not supported for integrated logon, or when I remove the integrated logon criteria from the connection string the message is that logon fails for the administrative user id.

I have placed the dll files is the appropriate location (I think) although I repeat that it works in eclipse.

[support-swapna]

lrine,

Sorry that you are seeing this issue.

Can you answer some more questions for us ?

1. Can you please copy paste the Installation Details from MyEclipse > Installation Summary > Installation Details ?

2. Can you let us know on which version of Eclipse is the connection string working ?

3. Please give us details about the version of MSSQL Server you are working with and the connection string you are using.

4. Can you please check if you can configure and connect to the said database from the MyEclipse Database explorer ? Here is the tutorial to configure the DB :
http://www.myeclipseide.com/documentation/quickstarts/dbexplorer/

Let us know how it works for you.

[lrine]

The installation summary is:

*** Date:
Thursday, August 9, 2012 9:18:54 AM CDT

*** System properties:
OS=Windows Server 2008
OS version=6.1.0
OS arch=x86
Profile arch=x86
Window system=win32
Java version=1.6.0_13
Workspace=file:/C:/Users/administrator.INTERSECT/Workspaces/MyEclipse Bling Edition 10/
VM Args=-Xmx512m
-XX:MaxPermSize=256m
-XX:ReservedCodeCacheSize=64m
-Dosgi.nls.warnings=ignore
-Djava.class.path=C:\Users\ADMINI~1.INT\AppData\Local\MYECLI~1\MYECLI~1\../Common/plugins/ORB7B5~1.JAR

*** Subscription information
Your 30-day trial period expires on Sep 03, 2012

*** Eclipse details:
MyEclipse Blue Edition

Version: 10.6 Blue
Build id: 10.6-Blue-20120727

Blueprint: MyEclipse Bling Edition 10

com.genuitec.myeclipse.blue.feature – 10.6.0.me201207261914
com.genuitec.myeclipse.database – 10.6.0.me201207261914
com.genuitec.myeclipse.db2 – 10.6.0.me201207261914
com.genuitec.myeclipse.desktop – 10.6.0.me201207261914
com.genuitec.myeclipse.editor – 10.6.0.me201207261914
com.genuitec.myeclipse.geronimo – 10.6.0.me201207261914
com.genuitec.myeclipse.glassfish – 10.6.0.me201207261914
com.genuitec.myeclipse.icefaces.feature – 10.6.0.me201207261914
com.genuitec.myeclipse.iedebugger – 10.6.0.me201207261914
com.genuitec.myeclipse.imageeditor – 10.6.0.me201207261914
com.genuitec.myeclipse.jboss – 10.6.0.me201207261914
com.genuitec.myeclipse.jetty – 10.6.0.me201207261914
com.genuitec.myeclipse.jonas – 10.6.0.me201207261914
com.genuitec.myeclipse.jrun – 10.6.0.me201207261914
com.genuitec.myeclipse.jsf – 10.6.0.me201207261914
com.genuitec.myeclipse.matisse – 10.6.0.me201207261914
com.genuitec.myeclipse.maven – 10.6.0.me201207261914
com.genuitec.myeclipse.oracle – 10.6.0.me201207261914
com.genuitec.myeclipse.orion – 10.6.0.me201207261914
com.genuitec.myeclipse.persistence – 10.6.0.me201207261914
com.genuitec.myeclipse.pulse – 10.6.0.me201207261914
com.genuitec.myeclipse.reports – 10.6.0.me201207261914
com.genuitec.myeclipse.resin – 10.6.0.me201207261914
com.genuitec.myeclipse.struts – 10.6.0.me201207261914
com.genuitec.myeclipse.sun – 10.6.0.me201207261914
com.genuitec.myeclipse.tomcat – 10.6.0.me201207261914
com.genuitec.myeclipse.uml2 – 10.6.0.me201207261914
com.genuitec.myeclipse.visualvm – 10.6.0.me201207261914
com.genuitec.myeclipse.visualvm.server – 10.6.0.me201207261914
com.genuitec.myeclipse.weblogic – 10.6.0.me201207261914
com.genuitec.myeclipse.ws – 10.6.0.me201207261914
com.genuitec.myeclipse.ws.blue – 10.6.0.me201207261914
com.skyway.myeclipseforspring.feature – 10.0.0.201111091436
org.eclipse.birt – 2.6.1.me201207261914
org.eclipse.datatools.connectivity.feature – 1.9.0.me201207261914
org.eclipse.datatools.enablement.feature – 1.9.0.me201207261914
org.eclipse.datatools.modelbase.feature – 1.9.0.v201106031100-77078CcNBHCBYKYEbNV
org.eclipse.datatools.sqldevtools.feature – 1.9.0.me201207261914
org.eclipse.emf – 2.7.0.v20110606-0949
org.eclipse.gef – 3.7.0.v20110425-2050-777D-81B2Bz0685C3A6E34272
org.eclipse.graphiti.feature – 0.8.0.v20110607-1252
org.eclipse.jpt.jpa.feature – 3.0.0.me201207261914
org.eclipse.jpt.jpadiagrameditor.feature – 1.0.0.me201207261914
org.eclipse.jst.common.fproj.enablement.jdt – 3.3.0.me201207261914
org.eclipse.jst.enterprise_ui.feature – 3.3.0.me201207261914
org.eclipse.jst.server_adapters.ext.feature – 3.3.0.me201207261914
org.eclipse.jst.server_adapters.feature – 3.2.100.me201207261914
org.eclipse.jst.server_ui.feature – 3.3.0.me201207261914
org.eclipse.jst.ws.axis2tools.feature – 1.1.200.me201207261914
org.eclipse.m2e.feature – 1.0.0.me201207261914
org.eclipse.sapphire.platform – 0.3.0.201106221325
org.eclipse.wst.common.fproj – 3.3.0.me201207261914
org.eclipse.wst.server_adapters.feature – 3.2.100.me201207261914
org.eclipse.xsd – 2.7.0.v20110606-0949
org.springframework.ide.eclipse.feature – 2.9.1.me201207261914

fr.obeo.acceleo.bridge.feature – 2.6.0.200906261742
org.eclipse.cvs – 1.3.100.v20110520-0800-7B78FHl9VF7BD7KBM4GP9C
org.eclipse.draw2d – 3.7.0.v20110425-2050-46-7w3122153603161
org.eclipse.equinox.p2.core.feature – 1.0.1.v20110906-1605-8290FZ9FVKHVRKtmx3fpNuo02129
org.eclipse.equinox.p2.extras.feature – 1.0.1.v20110906-1605-7A4FD4DiVOMap8cHSc6vPuny4gqO
org.eclipse.equinox.p2.rcp.feature – 1.0.1.v20110906-1605-782EqBqNKGVkiV-PUsgz-uny4gqO
org.eclipse.equinox.p2.user.ui – 2.1.2.R37x_v20110815-1155-6-Bk8pYWZz0qUTX5I15GZWwbXkrl
org.eclipse.help – 1.3.0.v20110530-0844-7i7uFFmFFl8nvqbDpEqTvx
org.eclipse.jdt – 3.7.2.v20120120-1414-7z8gFcuFMP7BW5XTz0jLTnz0l9B1
org.eclipse.jsf.feature – 3.3.0.me201207261914
org.eclipse.ocl – 3.1.0.v20110606-1427
org.eclipse.pde – 3.7.2.v20120120-1420-7b7rFUOFEx2Xnqafnpz0E–0
org.eclipse.platform – 3.7.2.v20120207-1839-9gF7UHPDFxGjd-PqDr2jX_4yKaumkoHTz04_q-q
org.eclipse.rcp – 3.7.2.v20120120-1424-9DB5FmnFq5JCf1UA38R-kz0S0272

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-showsplash
-launcher
C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\myeclipse-blue.exe
-name
Myeclipse-blue
–launcher.library
C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\../Common/plugins/org.eclipse.equinox.launcher.i18n.win32.win32.x86_4.2.0.v201201111650\eclipse_4201.dll
-startup
C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\../Common/plugins/org.eclipse.equinox.launcher_1.2.0.v20110502.jar
-install
C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10
-configuration
C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\MyEclipse Bling Edition 10\configuration
-vm
C:\Users\administrator.INTERSECT\AppData\Local\MyEclipse Bling Edition\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\jre\bin\client\jvm.dll

The Eclipse version is:

Eclipse Java EE IDE for Web Developers.

Version: Indigo Service Release 2
Build id: 20120216-1857

(c) Copyright Eclipse contributors and others 2005, 2012. All rights reserved.
Visit http://www.eclipse.org/webtools

The working connection string is:

jdbc:sqlserver://localhost:1433;databaseName=intersect;integratedSecurity=true;

I am using SQL Server 2012 which is reverse compatible with SQL 2008.

Thanks for your help.

[support-swapna]

lrine,

Thank you for the details.

1.Did you get a chance to try to connect to the database from the MyEclipse Database Explorer view ?

2. Clear the contents of the .log file which is located at <workspace dir>/.metadata/.log. Now replicate the issue and copy paste the contents of the .log file here for us to investigate further.

[Author]

Posts