Connexion à une base Sybase - Erreur JZ00L : Echec de la connexion [Résolu]

[metheorn]

Bonjour,

Après avoir installé BIRT, je souhaite accéder à une base sybase.
Pour cela :
1. j'ai installé les drivers JDBC sybase (jconn2.jar) dans le répertoire
plugins/org.eclipse.birt.report.data.oda.jdbc_2.1.0.N20060628-1351/drivers
2. dans la définition du DATA SOURCE :
a) driver class = com.sybase.jdbc2.jdbc.SybDriver (v5.5) <-- il me retrouve bien mon driver
b) database url = jdbc:sybase:Tds:mon_serveur:5011/MA_BASE
c) renseignez login/pasword

Lorsque je test ma connexion, il me met
JZ00L : Echec de la connexion

si je valide quand même et que je veux créer un dataset, toujours la même erreur mais avec plus d'explications :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
java.sql.SQLException: JZ00L: Echec de la connexion. Examinez les SQLWarnings associées à cette exception pour la ou les raisons suivantes :
	at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:547)
	at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3601)
	at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:510)
	at com.sybase.jdbc2.tds.Tds.login(Tds.java:432)
	at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:247)
	at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:223)
	at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:198)
	at com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:132)
	at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager$WrappedDriver.connect(JDBCDriverManager.java:787)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:185)
	at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:120)
	at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.getConnection(DriverLoader.java:33)
	at org.eclipse.birt.report.data.oda.jdbc.ui.provider.JdbcMetaDataProvider.connect(JdbcMetaDataProvider.java:89)
	at org.eclipse.birt.report.data.oda.jdbc.ui.provider.JdbcMetaDataProvider.connect(JdbcMetaDataProvider.java:148)
	at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.connectMetadataProvider(SQLDataSetEditorPage.java:1285)
	at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.initJdbcInfo(SQLDataSetEditorPage.java:291)
	at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.createPageControl(SQLDataSetEditorPage.java:241)
	at org.eclipse.birt.report.data.oda.jdbc.ui.editors.SQLDataSetEditorPage.createPageCustomControl(SQLDataSetEditorPage.java:210)
	at org.eclipse.datatools.connectivity.oda.design.ui.wizards.DataSetWizardPage.createControl(DataSetWizardPage.java:123)
	at org.eclipse.jface.wizard.Wizard.createPageControls(Wizard.java:180)
	at org.eclipse.jface.wizard.WizardDialog.createPageControls(WizardDialog.java:614)
	at org.eclipse.jface.wizard.WizardDialog.setWizard(WizardDialog.java:989)
	at org.eclipse.jface.wizard.WizardDialog.updateForPage(WizardDialog.java:1041)
	at org.eclipse.jface.wizard.WizardDialog.access$2(WizardDialog.java:1038)
	at org.eclipse.jface.wizard.WizardDialog$4.run(WizardDialog.java:1028)
	at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:67)
	at org.eclipse.jface.wizard.WizardDialog.showPage(WizardDialog.java:1026)
	at org.eclipse.jface.wizard.WizardDialog.nextPressed(WizardDialog.java:757)
	at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:351)
	at org.eclipse.jface.dialogs.Dialog$3.widgetSelected(Dialog.java:660)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:90)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
	at org.eclipse.jface.window.Window.open(Window.java:796)
	at org.eclipse.birt.report.designer.ui.actions.NewDataSetAction.run(NewDataSetAction.java:123)
	at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)
	at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:539)
	at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:488)
	at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:400)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:928)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3348)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:2968)
	at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:1914)
	at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:1878)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:419)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)
	at org.eclipse.ui.internal.ide.IDEApplication.run(IDEApplication.java:95)
	at org.eclipse.core.internal.runtime.PlatformActivator$1.run(PlatformActivator.java:78)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:92)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:68)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:177)
	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.core.launcher.Main.invokeFramework(Main.java:336)
	at org.eclipse.core.launcher.Main.basicRun(Main.java:280)
	at org.eclipse.core.launcher.Main.run(Main.java:977)
	at org.eclipse.core.launcher.Main.main(Main.java:952)

Merci de votre aide

[BiM]

Salut !

J'ai bien peur qu'une erreur de cette forme : "JZ00L : Echec de la connexion" soit une erreur Sybase.

Et je peux même te dire que cela veut dire Login Failed Donc je crains que ton login ne soit pas correct

Bonne chance !

[metheorn]

Yeah c'est cela.

Pourtant je pensais avoir bien vérifiéé mon url de connexion. Je me suis trompé de port .

Encore merci

[BiM]

Pas de problèmes, ca arrive a tout le monde