Showing posts with label alli. Show all posts
Showing posts with label alli. Show all posts

Friday, March 30, 2012

Hide only export dropdown list and "Export" link button from report toolbar in sql rep

Hi All

I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so ,

Please help me in this

Thanks

Alpesh

I think that this url can be helpuff:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

Hide only export dropdown list and "Export" link button from report toolbar in sql

Hi All

I want to hide export dropdown list and "Export" link button from reportviewer toolbar . because i create my own export function so ,

Please help me in this

Thanks

Alpesh

I think that this url can be helpuff:

http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx

sql

Wednesday, March 28, 2012

Hide Database in SQL SErver 2000

Dear All
I have a question on the security control of sql server 2000.
Now I set a specified sql account can access corresponding database only,
however, how can I hide other database that he not allowed to access, as
well as master, tempdb and other system database?
ThanksYou cannot do that in SQL Server 2000 but only in SQL Server 2005
"a" <a@.l.q> wrote in message
news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Dear All
> I have a question on the security control of sql server 2000.
> Now I set a specified sql account can access corresponding database only,
> however, how can I hide other database that he not allowed to access, as
> well as master, tempdb and other system database?
> Thanks
>|||o....thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uu$cIZIBGHA.1032@.TK2MSFTNGP11.phx.gbl...
> You cannot do that in SQL Server 2000 but only in SQL Server 2005
>
> "a" <a@.l.q> wrote in message
> news:%23ZK8tMGBGHA.1676@.TK2MSFTNGP09.phx.gbl...
only,[vbcol=seagreen]
>

Monday, March 12, 2012

Heterogeneous queries and use of OLEDB providers are not supported

Hi all
I am trying to create linked server on 2005 64bit server for 2000 32 bit.
I ran instcat.sql script as microsoft article sugested.
Still, I am having problems.
I can browse db objects using management studio.
But when i try to run sql like:
select count(*) from botserver.master.dbo.sysobjects
I am getting:
Heterogeneous queries and use of OLEDB providers are not supported in fiber
mode.
I can neither run any stored procs.
My linked server is defined as server type: sql server
Any ideas?
Why are you running in fiber mode in the first place? Unless you have a
very good reason for turning it on you should turn it back off and solve two
problems.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> Hi all
> I am trying to create linked server on 2005 64bit server for 2000 32 bit.
> I ran instcat.sql script as microsoft article sugested.
> Still, I am having problems.
> I can browse db objects using management studio.
> But when i try to run sql like:
> select count(*) from botserver.master.dbo.sysobjects
> I am getting:
> Heterogeneous queries and use of OLEDB providers are not supported in
> fiber
> mode.
> I can neither run any stored procs.
> My linked server is defined as server type: sql server
> Any ideas?
|||Hi Kelly
I have 8 cpu host and content switching is pretty high.
I read that these are indications to use light weight pooling.
If you can please educate me on this point too.
Thank you, Gene.
"Andrew J. Kelly" wrote:

> Why are you running in fiber mode in the first place? Unless you have a
> very good reason for turning it on you should turn it back off and solve two
> problems.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Gene." <Gene@.discussions.microsoft.com> wrote in message
> news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
>
|||Try to use alias name as qualifier instead of full qualifier (complete schema).
Hope this will solve your problem.

Heterogeneous queries and use of OLEDB providers are not supported

Hi all
I am trying to create linked server on 2005 64bit server for 2000 32 bit.
I ran instcat.sql script as microsoft article sugested.
Still, I am having problems.
I can browse db objects using management studio.
But when i try to run sql like:
select count(*) from botserver.master.dbo.sysobjects
I am getting:
Heterogeneous queries and use of OLEDB providers are not supported in fiber
mode.
I can neither run any stored procs.
My linked server is defined as server type: sql server
Any ideas?Why are you running in fiber mode in the first place? Unless you have a
very good reason for turning it on you should turn it back off and solve two
problems.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Gene." <Gene@.discussions.microsoft.com> wrote in message
news:DE0360F5-3A4C-47BB-9304-10D0FA789855@.microsoft.com...
> Hi all
> I am trying to create linked server on 2005 64bit server for 2000 32 bit.
> I ran instcat.sql script as microsoft article sugested.
> Still, I am having problems.
> I can browse db objects using management studio.
> But when i try to run sql like:
> select count(*) from botserver.master.dbo.sysobjects
> I am getting:
> Heterogeneous queries and use of OLEDB providers are not supported in
> fiber
> mode.
> I can neither run any stored procs.
> My linked server is defined as server type: sql server
> Any ideas?

Friday, February 24, 2012

Help: JDBC 1.22 and SQL 2000

HI, all

I need to write a program, which using VM 1.1.8.

So I need to find the JDBC driver version 1.22, Can anyone help me?

Please Reply, a link for download jdbc 1.22 or any other solutions .

Thank you!

You can take a look at the following links for Microsoft SQL Server 2005 JDBC Driver (recommended)

http://msdn.microsoft.com/data/ref/jdbc/

http://www.microsoft.com/downloads/details.aspx?FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en

For SQL Server 2000 Driver for JDBC Service Pack 1

http://www.microsoft.com/downloads/details.aspx?FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en