Connect to MSSQL from UNIX

Hi experts,
I am new in java programming. I am wana to write an application program to access MSSQL2000 from UNIX. But unfortunately, I am faile. (The program can access to MSSQL2000 from microsoft platform.). Anyone can help me to solve this program ? Thank you.
David Hunag
F.Y.I.
OS : HPUX 10.20
JDK : 1.1.8
..cshrc :
...
set mypath = ( . /usr/bin /usr/sbin /usr/local/bin )
set optpath = ( /opt/java/bin /usr/local/perl5/bin )
set hp93kpath = ( /opt/hp93000/soc/prod_env/bin )
set path=( $mypath $optpath $hp93kpath )
setenv classpath /opt/msSQL2000jdbc/lib/.msbase.jar: /opt/msSQL2000jdbc/lib/mssqkserver.jar:/opt/msSQL2000jdbc/lib/msutil.jar
...
?2004 Microsoft Corporation. All rights reserved. Terms of Use | Privacy Statement
Hi,
You need an ODBC driver middleware installed on the
UNIX box itself, so that it can talk to the SQL Server
Have a look into the old post for more more info,
http://groups.google.co.in/groups?q=...+unix&hl=en&lr
=&ie=UTF-8&selm=oopoaEevBHA.2288%40cpmsftngxa09&rnum=10
Thanks
Hari
MCDBA
"David Huang" <huangjuichung@.yahoo.com> wrote in message
news:6274A7C7-7C80-4D15-A46B-C6A8BC683EF5@.microsoft.com...
> Hi experts,
> I am new in java programming. I am wana to write an application program to
access MSSQL2000 from UNIX. But unfortunately, I am faile. (The program can
access to MSSQL2000 from microsoft platform.). Anyone can help me to solve
this program ? Thank you.
> David Hunag
> F.Y.I.
> OS : HPUX 10.20
> JDK : 1.1.8
> .cshrc :
> ...
> set mypath = ( . /usr/bin /usr/sbin /usr/local/bin )
> set optpath = ( /opt/java/bin /usr/local/perl5/bin )
> set hp93kpath = ( /opt/hp93000/soc/prod_env/bin )
> set path=( $mypath $optpath $hp93kpath )
> setenv classpath /opt/msSQL2000jdbc/lib/.msbase.jar:
/opt/msSQL2000jdbc/lib/mssqkserver.jar:/opt/msSQL2000jdbc/lib/msutil.jar
> ...
>
>
>
> 2004 Microsoft Corporation. All rights reserved. Terms of Use | Privacy
Statement
>

Confustion on ROLAP and MOLAP and HOLAP modes

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on ROLAP and MOLAP storage modes. In ROLAP mode, we store all data in source relational databases and though then we can gain near real-time data for the queries. But with MOLAP and Proactive caching, we can solve this problem by setting update notifications to the MOLAP cubes. Also, with HOLAP, we can combine ROLAP and MOLAP (store leaf data in source relational database, while aggregations in MOLAP format), thus we can actually get the near real-time data for the queries as well once there is any changes to the underlying source relational database.

I am just a bit confused about the distinct benefts we can differenciate between these aspects regarding MOLAP with proactive caching and HOLAP. (not convinced about the reason to use ROLAP storage mode).

I hope my question is clear for your help and thanks a lot in advance for your advices and help for that and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello again Helen. MOLAP is the best choice for performance. HOLAP will give you wrong results if you have aggregations in the cube because the leaf records in the fact table will change but the aggregations will not. Avoid HOLAP.

Seems like you have SSAS2005 built on top of your transaction systems(OLTP) and no data warehouse/mart?

If you need real time reports build something with Reporting Services instead of using ROLAP or proactive caching.

I am not sure that MOLAP with proactive caching is a possible scenario. I think it is ROLAP with proactive caching, else you will have a MOLAP cube that only does processing 24 hours a day.

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for your kind advices.

I thought the reason to have HOLAP is because they store the leaf data in source relational database, so once they have any changes to the source relational database, then the aggregations in the MOLAP format will be updated automatically. But then now it seemes like there is no reason to have HOLAP as well. Why not just use MOLAP, and keep the source relational database, set the proactive caching for this MOLAP to be near real-time?

Hope my thinking is right. And your further advices are most welcome. I am looking forward to hearing from you shortly.

Thanks again.

With best regards,

Yours sincerely,

|||

I'm a little confused by this thread, but here goes.

HOLAP is a wonderful option for keeping query processing times and cube population times down. Performance tends to degrade when querying at the leaf level because you are using ROLAP. With ROLAP, SSAS translates your MDX query into various SQL queries that it submits against your relational database and then uses the results to generate a cellset to return. The tradeoff is cube population times are lowest with ROLAP. MOLAP is the best for query performance but worst for cube population times.

Both MOLAP and HOLAP can get out of synch with your relational database but both can be configured to support proactive caching. MOLAP and HOLAP handle proactive caching differently. I personally find the HOLAP option more appealing, but read the Books Online topic "Choosing a Standard Storage Setting " for yourself to find what works best in your situation.

Regarding SSRS vs. SSAS, I'm not sure why the comparison. SSRS works against both relational and multidimensional database technologies, e.g. SQL Server Database Enging and SSAS. You can have data sets from both types of technologies in a single report if you need to go that route. The proactive caching and storage options above are transparent to any data consumer, be it SSRS, Proclarity, Excel, etc.

Hope that helps,
Bryan

|||

Hello helen. You already have another answere but I thought I should make some comments.

HOLAP does not include any automatic updates of aggregations so when the fact data changes the leaf transactions and the aggregations will be out of synch. If you have a data warehouse that is updated every day, but only once, then this will be no problem but you can choose MOLAP anyway.

MOLAP with proactive caching means that you will have a new version of the cube being built in the background when ever SSAS2005 detects a change in the data. Another way to do the same is to run an incremental update of the cube and the dimensions in a scheduled job that runs several times during the day.

With SSRS2005 you can write SQL-queries against a relational data store and have a real time report if you query your ERP-system(an approach that I do not recommend).

HTH

Thomas Ivarsson

|||

Hi, Brian,

Thanks a lot for your very advanced and helpful advices.

With best regards,

Yours sincerely,

|||

Hi, Thomas,

Again, your suggestions have been really helpful as well. It gave me more ideas on the OLAP cubes storage modes and help me to have more ideas on choosing very interesting storage modes.

With best regards,

Yours sincerely,

Confusion on Time Intelligence

Hi, all experts here,

Thank you for your kind attention.

Just really confused about Time Intelligence. Would please any experts here shed me any light on Time Intelligence? What are the main concern or benefits of creating Time Intelligence? Any disavantages of using it?

Thank you very much in advance for your kind advices and help for that and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello Helen!

Here is a link to Moshas Blog about Time Intelligence: http://www.sqljunkies.com/WebLog/mosha/archive/2006/10/25/time_calculations_parallelperiod.aspx

The are also additional links to more information in that Blog entry.

And Chris Webb have written a few posts on this subject here: http://cwebbbi.spaces.live.com/

HTH

Thomas Ivarsson

Configuring reporting services

hello experts

I was always told that the only dumb question is the one not asked, so here goes

I am trying to start reporting services, but it does not even show up on the configuration panel in the start menu

During the installation of SQL 2005 Express, one warning I recieved is that Internet Information Services

(ISS) is not installed or disabled. Upon checking the control panel, I did not find it. Googling it brought me

back to MicroSoft, where I can download it (for a nominal fee) Is this what I am going to need to do or am I

missing something here?

thanks

IIS is on your Windows install disc. To install it, go to Add/Remove Programs, Add/Remove Windows components and tick Internet Information Services, the rest is obvious, and you will be prompted for your install disc.

If you already have it installed it will already show as ticked here, or you can try and run iis.msc which should be located in %system32%\inetsrv\iis.msc.

Sorry, but i can't tell you what you will have to configure in RS once you have installed IIS, it might be just simpler to reinstall RS.

|||

Thanks for your response

I tried this but there is no listing for internet information services in the Add/Remove Windows Components. Is this because I am using Windows XP Home Edition?

thanks again

Configuring reporting services

Hello Experts,

I have this problem when i go to http://<servername>/reprots

"The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible "

I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.

i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....

would be great if someone suggests.

regards,

lakshman.

Hi Lakshman,

Is it RS 2000 or 2005? In RS 2005, you can use RS config tool to see if all sections are correctly configured. If not, fix the problems using the config tool and try again.

Thanks,
Sharmila

|||

Hi Sharmila,

Thanks for the reply.

Its RS2005. I am pretty new to the subject, can you please guide about using the RSConfig tool. Or resources where i can find the subject.

Best Regards,

Lakshman.

|||

Hi Sharmila,

At the command prompt, I have done the following actions:

C:\>rsconfig -c -s iplserver -d iplserver -a SQL -u sa -p P@.ssword123445
The command completed successfully

C:\>iisreset
Attempting stop...
Internet services successfully stopped
Attempting start...
Internet services successfully restarted

C:\>

when i try to access the report manager, the error persists.

pl let me know if i have to do something else.

many thanks,

lakshman.

|||

Hi Lakshman,

To access the config tool, go to Start ->All Programs -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration. Make sure that all sections are configured properly. You should see a green check mark. Please try this and let me know.

Thanks,
Sharmila

|||

Lakshman Pilaka wrote:

Hello Experts,

I have this problem when i go to http://<servername>/reprots

Is it safe to assume the mispelling of Reports is only here in the forums?

|||

oops, i wrote it wrong here in the thread, but i was spelling it correctly when i am testing...

Sharmila, thanks for the msg, I have checked that one and got to see that there is a blue exclamation for the "Encryption Keys". and the initialization is not done, i find a red cross. but rest all are okay with a green check mark.

i am not even able to access it the Initialization tab as its giving an error message,

plz help, or just guied me to a resource where i can have all this information..

i appreciate all your time and efforts,

lakshman.

|||

Hi,

I have installed the SQL SP2 on the server, and now the server is properly initialized. now i see a green check mark on all the tabs.

But unfortunately the problem still persists. I am seeing the same error:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

when i attempt to go to http://<reportserver>/reports

what could be the problem?

many thanks,

lakshman.

|||

Hi Lakshman,

Can you please take a look at the RS logs located here - %programfiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\LogFiles and see what you can find around the same time you see the error or can you include information from the logs?

Thanks,
Sharmila