MSSQL to Oracle

hello,

I built my application using SQLClient classes and MSSQL database

i have another version of the database with Oracle, is changing to OracleClient classes the only change i have to do in order to run the program and the connection string?

Thanks

Nope...You also have to install the Oracle client, and give the accountthat your ASP.Net application is running under access to the directorythat the Oracle client is in.

MSSQL Stored procedure Query using SELECT TOP

Is there a way to do a SELECT TOP # using a variable for the #?

In other words I'm doing a SELECT TOP 50* FROM DATATABLE

If I pass an @.value for the number

SELECT TOP @.value* FROM DATATABLE doesn't work

I am generating a random sampling of data and I want to allow the user to select the number of results they choose to have.

Thanks in advance.

I believe that is possible in 2005 and not in 2000. You can however use SET ROWCOUNT in 2000.

DECLARE @.tintSET @.t = 10SET ROWCOUNT @.tSELECT *FROM YourTableSET ROWCOUNT 0

|||

In 2005, the following works:

DECLARE @.t int
SET @.t = 20
SELECT TOP(@.t) * FROM yourTable

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer case
and a green arrow) from appearing in the status area of the taskbar? I’m
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.
Remove it from the startup group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>
|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:

> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I’m
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer cas
e
and a green arrow) from appearing in the status area of the taskbar? I’m
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.Remove it from the startup group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer c
ase
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:

> Is there a method to prohibit the server icon (the one with the computer c
ase
> and a green arrow) from appearing in the status area of the taskbar? I’m
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSSQL status icon

Is there a method to prohibit the server icon (the one with the computer case
and a green arrow) from appearing in the status area of the taskbar? Iâ'm
attempting to lockdown a terminal services desktop and want to avoid a
curious user from playing point and click with the icon.
Many thanks for all of you being there to help.
SQL 2000 running on a 2003 server.Remove it from the startup group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:5F8F1072-2D0B-490D-9F7B-69B899ACCFF4@.microsoft.com...
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? I'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>|||Hi coenzyme,
Remove it out of the Programs\Startup menu for users.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"coenzyme" wrote:
> Is there a method to prohibit the server icon (the one with the computer case
> and a green arrow) from appearing in the status area of the taskbar? Iâ'm
> attempting to lockdown a terminal services desktop and want to avoid a
> curious user from playing point and click with the icon.
> Many thanks for all of you being there to help.
>
> SQL 2000 running on a 2003 server.
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech Znaniecki
Is SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegro ups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>

MSsql Standard connect error

Hello
I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
instance name "mssql" ( hostname ="DBServer". Now I can only connect
from localhost with path "DBServer\mssql". From all other computers in
my network i cannot connect ( error "Mssql server does not exist...").
I cant even connect from localhost with path "localhost\mssql".
Previous I had Mssql 2000 Developer Edition installed on other Win2003
SP1 and I had no problems with connecting.
What can be wrong ?
Best Regards
Wojciech ZnanieckiIs SP3 or higher installed on the Win2K3 server? Is the instance listening
on TCP? Check the SQL Server errorlog to find out...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"wojtas_z" <wojtas_z@.poczta.fm> wrote in message
news:1131012588.047990.42900@.g14g2000cwa.googlegroups.com...
> Hello
> I have installed Mssql 2000 standard Edition on windows 2003 sp1 with
> instance name "mssql" ( hostname ="DBServer". Now I can only connect
> from localhost with path "DBServer\mssql". From all other computers in
> my network i cannot connect ( error "Mssql server does not exist...").
> I cant even connect from localhost with path "localhost\mssql".
> Previous I had Mssql 2000 Developer Edition installed on other Win2003
> SP1 and I had no problems with connecting.
> What can be wrong ?
> Best Regards
> Wojciech Znaniecki
>