Gennadiy.Skuha
-
Posts
9 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by Gennadiy.Skuha
-
-
I glad to tell you that I decided my problem.
My MSSQL 2000 was required to install SP3(or higher)
My OS is WINXP and it had problem with MSSQL TCP connection on the default port 1433. I meen that command "telnet 127.0.0.1 1433" must perform successfully.
More info about this problem you could find here: http://support.microsoft.com/kb/313100
Thanks to all. ;)
-
I glad to tell you that I decided my problem.
My MSSQL 2000 was required to install SP3(or higher)
My OS is WINXP and it had problem with MSSQL TCP connection on the default port 1433. I meen that command "telnet 127.0.0.1 1433" must perform successfully.
More info about this problem you could find here: http://support.microsoft.com/kb/313100
Thanks to all. ;)
-
Yes, I have the problem with Mondrian Connection.
JDBC Data Source settings:
Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
URL: jdbc:microsoft:sqlserver://127.0.0.0:1433;DatabaseName=pubs
-
Please, help to setup MSSQL datasource.
I have the problem:
"SQL Problems: [Microsoft][sqlServer 2000 Driver for JDBC] Error establishing socket. ....."
size=399]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/sock_error-784f255e14a723915dbff21b73291ec2.gif
But i have not any problem with MSSQL Query Analyzer connecting.
Has anybody do that successfully? (connect to the MSSQL server).
It seems impossible
-
Has anybody resolved this problem?
Connect to the MSSQL socket error:
"SQL Problems: [Microsoft][sqlServer 2000 Driver for JDBC] Error establishing socket. ....."
size=399]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/sock_error.gif
Post edited by: Gennadiy.Skuha, at: 2007/02/27 13:28
-
This is the MDX query (a sample from "JasperServer-Pro-User-Guide.pdf"):
select {[Measures].[Total Sale Amount], [Measures].[Number of Sales], [Measures].[Avg Sale Amount], [Measures].[Avg Time To Close (Days)], [Measures].[Avg Close Probablility]} ON COLUMNS, NON EMPTY {([Account Categorization].[All Accounts], [Close Period].[All Periods])} ON ROWS from [salesAnalysis] where [sale State].[All Types].[Closed Won]
It is for SugarCRM DB.
-
Had anybody ever this problem?
Creating an Analysis view with a Mondrian Connection.
When Enter an MDX Query and click "next",
appear message "The following is not a valid MDX Query: Internal error: Error while creating SQL dialect".
Thanks a lot for every helps.
-
Is there JasperETL for JAVA (not for PERL) anywhere?
OLAP Problem
in Products
Posted
I glad to tell you that I decided my problem.
My MSSQL 2000 was required to install SP3(or higher)
My OS is WINXP and it had problem with MSSQL TCP connection on the default port 1433. I meen that command "telnet 127.0.0.1 1433" must perform successfully.
More info about this problem you could find here: http://support.microsoft.com/kb/313100
Thanks to all. ;)