Connecting Flex 3 to MSSQL

[Kalenta]

Hello,



I've spent hours trying to figure out what you guys say is
EASY! Seriously how do you connect a Flex 3 application to
Microsoft SQL Server 2008!



This is what I get everytime!



java.sql.SQLException: Network error IOException: Connection
refused: connect

at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:372)

at
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)

at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)

at
org.eclipse.datatools.connectivity.db.generic.JDBCConnection.createConnection(JDBCConnection.java:87)

at
org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)

at
org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)

at
org.eclipse.datatools.connectivity.db.generic.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:52)

at
org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:77)

at
org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:354)

at
com.adobe.datatools.derived.wizards.BaseConnectionProfilePage.testConnectionSimple(BaseConnectionProfilePage.java:70)

at
com.adobe.datatools.derived.wizards.BaseConnectionProfilePage.testConnection(BaseConnectionProfilePage.java:51)

at
org.eclipse.datatools.connectivity.ui.wizards.ConnectionProfileDetailsPage$1.widgetSelected(ConnectionProfileDetailsPage.java:85)

at
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)

at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)

at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)

at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)

at
org.eclipse.jface.window.Window.runEventLoop(Window.java:820)

at org.eclipse.jface.window.Window.open(Window.java:796)

at
com.adobe.flexbuilder.dbwizard.ui.DbWizard$8.widgetSelected(DbWizard.java:598)

at
org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227)

at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)

at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)

at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)

at
org.eclipse.jface.window.Window.runEventLoop(Window.java:820)

at org.eclipse.jface.window.Window.open(Window.java:796)

at
com.adobe.flexbuilder.dbwizard.actions.DBWizardAction.run(DBWizardAction.java:69)

at
org.eclipse.ui.internal.PluginAction.runWithEvent(PluginAction.java:256)

at
org.eclipse.ui.internal.WWinPluginAction.runWithEvent(WWinPluginAction.java:229)

at
org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:546)

at
org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)

at
org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)

at
org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938)

at
org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682)

at
org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293)

at
org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2389)

at
org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2353)

at
org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2219)

at
org.eclipse.ui.internal.Workbench$4.run(Workbench.java:466)

at
org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:289)

at
org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:461)

at
org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at
com.adobe.flexbuilder.standalone.FlexBuilderApplication.start(FlexBuilderApplication.java:112)

at
org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)

at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)

at
org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)

at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)

at
org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at
org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)

at org.eclipse.equinox.launcher.Main.run(Main.java:1173)

at org.eclipse.equinox.launcher.Main.main(Main.java:1148)

Caused by: java.net.ConnectException: Connection refused:
connect

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.PlainSocketImpl.doConnect(Unknown Source)

at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown
Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at
net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:289)

at
net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:250)

at
net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:297)

... 57 more

[atta707]

Are you sure you're using correct parameters, like host name,
port, user name and password, for you MySql DB? Can you connect
using same values from the command line?