Error instaling JDBC for linux

hi group, i downloaded the jdbc tar file for linux, i uncompressed it and i
followed the instructions on
http://download.microsoft.com/downlo...nGuide_SP2.txt
but when i should type install.ksh
the script file doesnt works =(, it just do nothing
i cant install the jdbc i tried it as root and as normal user and the script
doesnt works
im using linux suse 9.1 on p4 2.80ghz, 512 ram
who can help me please?
Rick,
I tested the SP 3 installer on a SuSe 9.0 machine and am not able to
reproduce this behavior. I am able to run the installer from bash,
csh, ksh and sh shells. Please post your environment variables so I
can see if something else might be causing this issue.
Thanks,
Brian

Error in using DTUTIL /Exists

hi group,

i have to check whether SSIS package is present in MSDB or not.

I am using DTUTIL for this perpose . Command goes like this.

dtutil /SQL Package_for_testing /Exists

Error(0xC0014014) while checking for the existence of package "Package_for_testing" on SQL server

this is giving the error "The specified package does not exist.
Description: The ExistsOnSQLServer method has encountered OLE DB error code 0x80
004005 (Login timeout expired). The SQL statement issued has failed.
Source:"

But the package is there in MSDB when i checked manually.

I want to know what this error signify? and how i can solve it.

With advance thanks

Srinivasa Mahendrakar

It means that simply that package doesn't exist at all.

error in reports

Hi group
Finally I got it installed... ;0)
when I try to access the http://server/reports/ I get the following error
Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer
I tryid to give it a seperate appPool...
I have a sharepoint on theres as well
anyone that can assist ?On Sep 11, 4:24 am, "Wiper" <taenke...@.gmail.com> wrote:
> Hi group
> Finally I got it installed... ;0)
> when I try to access thehttp://server/reports/I get the following error
> Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer
> I tryid to give it a seperate appPool...
> I have a sharepoint on theres as well
> anyone that can assist ?
You may want to check the web.config file for Reporting Services
(normally located at: C:\Program Files\Microsoft SQL Server\MSSQL.
2\Reporting Services\ReportManager -or- C:\Program Files\Microsoft SQL
Server\MSSQL.2\Reporting Services\ReportServer; however, MSSQL.2 could
be MSSQL.3) and add:
partitionResolverType="" in the sessionState key.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Error in Bulk Insert after Windows 2003 Upgrade

My production support group upgraded the version of Windows Server from 2000 to 2003 on a stand-alone SQL 8.0 development server. I am using a bulk insert command in a stored procedure that is now failing as a result of the upgrade.

The error message is: Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'BULKIMPORTSTREAM'.
OLE DB error trace [Non-interface error: CoCreate of DSO for BULKIMPORTSTREAM returned 0x8007045a].

We have checked the following based on other posts we have seen.

1) Re-registered impprov.dll
2) We are at SP 3
3) We are at MDAC 2.8

We also verified by copying the DB to a dev server that has not been upgraded it still works. Does anyone have any other suggestions or experience that may help?

Thank you,
KellyJust being curious, did they do an upgrade without scratch and rebuild the server? If that's the case, your server would have registry problems. If your dev box is a dedicated db box, you can simply run the rebuild registry with sql 2000 installation CD and patch up with sp3 after that. If you still have problem, since it's a dev box, I would recommand that you take backups, sratch the box, install Windows 2003, install sql 2000, patch up to sp3, and then reload the database on to the server.|||Well, I made the suggestion that the server be rebooted after the unregister and re-resgister process and that seems to have done the trick. The DBA thinks that restarting SQL Server may have been enough. Thanks for the idea Joe.

Kelly

Error in add count Expression

Dear All,
I'm creating a report in the CRM , i'm using group by clause and i need to
add count Expression in the group footer depending on the details area of
the group , i've added this code in a textbox :
= count(fieldname.value, scope)
it didn't work & it generates an error that the name of the scope that i
have entered is not valid group details area
i've entered the scope as string
could anyone help me ?
thanks in advanceIf the code you entered is literal and not an example, I would say it is a
syntax error first. I would not think that you would need to specify the
"scope" if this is simply a group footer, as it should know the count
expression is in the scope of the group it is in, but maybe I am missing
something from your description.
I would try:
=count(Fields!FieldName.Value)
Rodney Landrum
"Karim Mohamed" <k_a_r_i_m_._m_o_h_a_m_e_d@.link.net> wrote in message
news:O3pEyFaWGHA.4572@.TK2MSFTNGP03.phx.gbl...
> Dear All,
> I'm creating a report in the CRM , i'm using group by clause and i need to
> add count Expression in the group footer depending on the details area of
> the group , i've added this code in a textbox :
> = count(fieldname.value, scope)
> it didn't work & it generates an error that the name of the scope that i
> have entered is not valid group details area
> i've entered the scope as string
> could anyone help me ?
> thanks in advance
>

Error Handling in SQL

Hello Group,
I need help on handling an error. I am trying to handle errors raised by
DBCC DBREINDEX. To force a test I have SET ARITHABORT OFF and SET
QUOTED_IDENTIFIER OFF and issued the statement against a table with a
calculated column.
That raised the "DBCC failed because the following SET options have
incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'." error.
My problem is that procedure exits after this error and no statement is
executed after it. I cannot catch it, check its number or continue on the
procedure. How can I do that?
Thanks!
Giovanni BassiAs the batch terminates, there's not much you can do at the TSQL level when you've hit the error. So
you need to prevent it. DBCC USEROPTIONS will show you the value for these options.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Giovanni Bassi" <gbassi@.coair.com> wrote in message news:%234sQc0frDHA.2556@.TK2MSFTNGP09.phx.gbl...
> Hello Group,
> I need help on handling an error. I am trying to handle errors raised by
> DBCC DBREINDEX. To force a test I have SET ARITHABORT OFF and SET
> QUOTED_IDENTIFIER OFF and issued the statement against a table with a
> calculated column.
> That raised the "DBCC failed because the following SET options have
> incorrect settings: 'QUOTED_IDENTIFIER, ARITHABORT'." error.
> My problem is that procedure exits after this error and no statement is
> executed after it. I cannot catch it, check its number or continue on the
> procedure. How can I do that?
> Thanks!
> Giovanni Bassi
>