SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

SQL Power Software Forum
SQL Power Software Forum
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Error when creating a new connection to sql server 2008  XML
Forum Index » SQL Power DQguru Technical Support
Author Message
[Post New]2009-12-07 23:27:35
    Subject: Error when creating a new connection to sql server 2008
[Up]
anildsouza


Joined: 2009-12-07 22:16:27
Messages: 2
Offline
Hi

Im trying to connect to sql server 2008. However I keep getting this error.

com.microsoft.sqlserver.jdbc.SQLServerException: The server version is not supported. The target server must be SQL Server 2000 or later.
[Post New]2009-12-08 09:56:32
    Subject: Re:Error when creating a new connection to sql server 2008
[Up]
Benjamin


Joined: 2006-09-08 17:47:35
Messages: 163
Offline
Hi,

you might want to look here: http://www.sqlpower.ca/forum/posts/list/2151.page#4275, it's posted for a different program but should also work for DQGuru.
--------------------------------------
Get involved: http://goo.gl/lt6r
--------------------------------------
[WWW]
[Post New]2009-12-08 18:16:15
    Subject: Re:Error when creating a new connection to sql server 2008
[Up]
anildsouza


Joined: 2009-12-07 22:16:27
Messages: 2
Offline
Thanks for the reply. I did manage to connect to sql server 2008 based on the post you guided me. However when I try to attache a table to anew project i get thhe following error ( i did see another post regarding this error but i could find a solution)

java.lang.RuntimeException: ca.sqlpower.sqlobject.SQLObjectException: Failed to populate columns of table CMF (cause: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to DOUBLE is unsupported.)
at ca.sqlpower.matchmaker.swingui.ProjectEditor.refreshIndexComboBoxAndAction(ProjectEditor.java:529)
at ca.sqlpower.matchmaker.swingui.ProjectEditor.access$200(ProjectEditor.java:83)
at ca.sqlpower.matchmaker.swingui.ProjectEditor$2.itemStateChanged(ProjectEditor.java:169)
at javax.swing.JComboBox.fireItemStateChanged(Unknown Source)
at javax.swing.JComboBox.selectedItemChanged(Unknown Source)
at javax.swing.JComboBox.contentsChanged(Unknown Source)
at javax.swing.AbstractListModel.fireContentsChanged(Unknown Source)
at javax.swing.DefaultComboBoxModel.setSelectedItem(Unknown Source)
at javax.swing.DefaultComboBoxModel.addElement(Unknown Source)
at javax.swing.JComboBox.addItem(Unknown Source)
at ca.sqlpower.matchmaker.swingui.SQLObjectChooser.setComboBoxStateAndItem(SQLObjectChooser.java:431)
at ca.sqlpower.matchmaker.swingui.SQLObjectChooser.validate(SQLObjectChooser.java:38
at ca.sqlpower.matchmaker.swingui.SQLObjectChooser.access$000(SQLObjectChooser.java:63)
at ca.sqlpower.matchmaker.swingui.SQLObjectChooser$3.itemStateChanged(SQLObjectChooser.java:251)
at javax.swing.JComboBox.fireItemStateChanged(Unknown Source)
at javax.swing.JComboBox.selectedItemChanged(Unknown Source)
at javax.swing.JComboBox.contentsChanged(Unknown Source)
at javax.swing.AbstractListModel.fireContentsChanged(Unknown Source)
at javax.swing.DefaultComboBoxModel.setSelectedItem(Unknown Source)
at javax.swing.JComboBox.setSelectedItem(Unknown Source)
at javax.swing.JComboBox.setSelectedIndex(Unknown Source)
at javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at javax.swing.plaf.basic.BasicComboPopup$1.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: ca.sqlpower.sqlobject.SQLObjectException: Failed to populate columns of table CMF (cause: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to DOUBLE is unsupported.)
at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:257)
at ca.sqlpower.sqlobject.SQLTable.getUniqueIndices(SQLTable.java:141
at ca.sqlpower.matchmaker.swingui.ProjectEditor.refreshIndexComboBoxAndAction(ProjectEditor.java:510)
... 43 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to DOUBLE is unsupported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
at com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:946)
at com.microsoft.sqlserver.jdbc.IntColumnFilter.apply(SQLServerDatabaseMetaData.java:2165)
at com.microsoft.sqlserver.jdbc.Column.getValue(Column.java:114)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1982)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:1967)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getDouble(SQLServerResultSet.java:2174)
at ca.sqlpower.sqlobject.SQLColumn.fetchColumnsForTable(SQLColumn.java:347)
at ca.sqlpower.sqlobject.SQLTable.populateColumns(SQLTable.java:250)
... 45 more
 
Forum Index » SQL Power DQguru Technical Support
Go to:   
Powered by JForum 2.1.8 © JForum Team