![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
All, I am testing JasperSoft Business Intelligence Suite, I downloaded the trial version and I am able to run the demo application, my next step in the evaluation is to be able to configure a Datasource for my SQL Anywhere databsae, so i can define domains, and start creating repoorts, dashboards, etc. Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL here is the info i am using Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver URL: jdbc:ianywhere river=SQL Anywhere 10,DSN=LFI_StaffCom_QAwhere LFI_StaffCom_QA is the name of my ODBC datasource in the computer where the JasperSoft Server is running I am sure i am missing something here, any help will be greatly appreciated. Thanks Jorge |
#3
| |||
| |||
|
URL: jdbc:ianywhere river=SQL Anywhere 10,DSN=LFI_StaffCom_QA |
river=SQL Anywhere 10;DSN=LFI_StaffCom_QA|
All, I am testing JasperSoft Business Intelligence Suite, I downloaded the trial version and I am able to run the demo application, my next step in the evaluation is to be able to configure a Datasource for my SQL Anywhere databsae, so i can define domains, and start creating repoorts, dashboards, etc. Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL here is the info i am using Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver URL: jdbc:ianywhere river=SQL Anywhere 10,DSN=LFI_StaffCom_QAwhere LFI_StaffCom_QA is the name of my ODBC datasource in the computer where the JasperSoft Server is running I am sure i am missing something here, any help will be greatly appreciated. Thanks Jorge |
#4
| |||
| |||
|
|
Is the URLs use of the comma simply a typo? What specifically is the behaviour when you attempt to connect to SQL Anywhere using this configuration? Do you get an error or message? -chris Jorge Quintana wrote: All, I am testing JasperSoft Business Intelligence Suite, I downloaded the trial version and I am able to run the demo application, my next step in the evaluation is to be able to configure a Datasource for my SQL Anywhere databsae, so i can define domains, and start creating repoorts, dashboards, etc. Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL here is the info i am using Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver URL: jdbc:ianywhere river=SQL Anywhere 10,DSN=LFI_StaffCom_QAwhere LFI_StaffCom_QA is the name of my ODBC datasource in the computer where the JasperSoft Server is running I am sure i am missing something here, any help will be greatly appreciated. Thanks Jorge |
#5
| |||
| |||
|
|
I think this URL: jdbc:ianywhere river=SQL Anywhere 10,DSN=LFI_StaffCom_QAmust be this URL: jdbc:ianywhere river=SQL Anywhere 10;DSN=LFI_StaffCom_QAGlenn Jorge Quintana wrote: All, I am testing JasperSoft Business Intelligence Suite, I downloaded the trial version and I am able to run the demo application, my next step in the evaluation is to be able to configure a Datasource for my SQL Anywhere databsae, so i can define domains, and start creating repoorts, dashboards, etc. Jaspersoft provides only JNDI, Bean and JDBC for datasources, so I want to use JDBC but i can't get it to work, jaspersoft is asking for Driver and URL here is the info i am using Driver: ianywhere.ml.jdbcodbc.jdbc3.IDriver URL: jdbc:ianywhere river=SQL Anywhere 10,DSN=LFI_StaffCom_QAwhere LFI_StaffCom_QA is the name of my ODBC datasource in the computer where the JasperSoft Server is running I am sure i am missing something here, any help will be greatly appreciated. Thanks Jorge -- Glenn Paulley Director, Engineering (Query Processing) Sybase iAnywhere Blog: http://iablog.sybase.com/paulley EBF's and Patches: http://downloads.sybase.com choose SQL Anywhere Studio >> change 'time frame' to all To Submit Bug Reports: http://case-express.sybase.com SQL Anywhere Studio Supported Platforms and Support Status http://my.sybase.com/detail?id=1002288 Whitepapers, TechDocs, and bug fixes are all available through the Sybase iAnywhere pages at http://www.sybase.com/products/datab...chnicalsupport |
![]() |
| Thread Tools | |
| Display Modes | |
| |