Hi all,
I'm having a problem connecting to SQL Server 2005. I've set the server properties in the repository properties' dialog box underneath Data Sources, and can ping the connection successfully.
When I try to add a new Data Source, I can navigate past the first screen (it doesn't give any connection error), but I am unable to see anything in the Task: drop-down menu.
I've tried using the MS SQL 2005 driver and the JTDS driver, but get the same results. If I change the connection information to a local Oracle database I have containing a different repository, I can see the tasks - there only seems to be a problem connecting to MS SQL 2005.
Has anyone seen anything like this before? Any help would be much appreciated.
My client env. details are:
*** System properties:
awt.toolkit=sun.awt.windows.WToolkit
birt.viewer.working.path=C:Documents and Settingsusernameworkspace.metadata.pluginsorg.eclipse.birt.report.viewer
eclipse.buildId=M20080221-1800
eclipse.commands=-os
win32
-ws
win32
-arch
x86
-showsplash
C:birt-report-designer-all-in-one-2_2_2eclipsepluginsorg.eclipse.platform_3.3.3.r33x_r20080129splash.bmp
-launcher
C:birt-report-designer-all-in-one-2_2_2eclipseeclipse.exe
-name
Eclipse
--launcher.library
C:birt-report-designer-all-in-one-2_2_2eclipsepluginsorg.eclipse.equinox.launcher.win32.win32.x86_1.0.3.R33x_v20080118eclipse_1023.dll
-startup
C:birt-report-designer-all-in-one-2_2_2eclipsepluginsorg.eclipse.equinox.launcher_1.0.1.R33x_v20080118.jar
-vm
C:SunSDKjdkbin..jrebinclientjvm.dll
eclipse.ee.install.verify=false
eclipse.product=org.eclipse.sdk.ide
eclipse.startTime=1259144712125
eclipse.vm=C:SunSDKjdkbin..jrebinclientjvm.dll
eclipse.vmargs=-Xms256m
-Xmx512m
-XX:MaxPermSize=512m
-Djava.class.path=C:birt-report-designer-all-in-one-2_2_2eclipsepluginsorg.eclipse.equinox.launcher_1.0.1.R33x_v20080118.jar
eof=eof
file.encoding=Cp1252
file.encoding.pkg=sun.io
file.separator=
java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment
java.awt.printerjob=sun.awt.windows.WPrinterJob
java.class.path=C:birt-report-designer-all-in-one-2_2_2eclipsepluginsorg.eclipse.equinox.launcher_1.0.1.R33x_v20080118.jar
java.class.version=50.0
java.endorsed.dirs=C:SunSDKjdkjrelibendorsed
java.ext.dirs=C:SunSDKjdkjrelibext;C:WINDOWSSunJavalibext
java.home=C:SunSDKjdkjre
java.io.tmpdir=C:DOCUME~1usernameLOCALS~1Temp
java.library.path=C:birt-report-designer-all-in-one-2_2_2eclipse;.;C:WINDOWSSunJavabin;C:WINDOWSsystem32;C:WINDOWS;C:SunSDKjdkbin..jrebinclient;C:SunSDKjdkbin..jrebin;C:SunSDKjdkbin;C:Program FilesCollabNet Subversion Server;C:jdk1.5.0_15;C:WINDOWSsystem32;C:WINDOWS;C:WINDOWSSystem32Wbem;C:Program FilesSASpgsqlpostgresql-8.0.3bin;C:Program FilesSASpgsqlpostgresql-8.0.3lib;C:Program FilesSlikSvnbin;C:Program FilesTortoiseSVNbin;C:Program FilesSASpgsqlpostgresql-8.0.3bin;C:Program FilesSASpgsqlpostgresql-8.0.3lib;C:Program FilesSASShared FilesFormats;C:SASsoftwareSASMetadataBridges2.1bin;C:oraclexeapporacleproduct10.2.0serverBIN;C:Sunjwsdp-2.0jwsdp-sharedbin;C:SunSDKjdkbin;C:Sunjwsdp-2.0jwsdp-sharedbin
java.runtime.name=Java(TM) SE Runtime Environment
java.runtime.version=1.6.0_16-b01
java.specification.name=Java Platform API Specification
java.specification.vendor=Sun Microsystems Inc.
java.specification.version=1.6
java.vendor=Sun Microsystems Inc.
java.vendor.url=
http://java.sun.com/
java.vendor.url.bug=
http://java.sun.com/cgi-bin/bugreport.cgi
java.version=1.6.0_16
java.vm.info=mixed mode
java.vm.name=Java HotSpot(TM) Client VM
java.vm.specification.name=Java Virtual Machine Specification
java.vm.specification.vendor=Sun Microsystems Inc.
java.vm.specification.version=1.0
java.vm.vendor=Sun Microsystems Inc.
java.vm.version=14.2-b01
line.separator=
