Order By Param

Is there a way to have a report parameter for the selection of what field
the user wants a table to be grouped on? For instance, the parameter would
have 3 options, clientid, clientname, and clientcity. I want to be able to
select one of these and have the table group on this selection.
Or any generic ways or ideas on how to accomplish this?
Thanks!!!I am looking for the same solution. I have a client that I have promised 10
reports to and they gave me a few but want sort capability on 5 different
fields. I could say that those are 5 different reports, but there should be
an easy way to list the fields in a drop down parameter and adjust the ORDER
BY based on this. Shouldn't there?
Thanks in advance.
ANDY
"Amon Borland" wrote:
> Is there a way to have a report parameter for the selection of what field
> the user wants a table to be grouped on? For instance, the parameter would
> have 3 options, clientid, clientname, and clientcity. I want to be able to
> select one of these and have the table group on this selection.
> Or any generic ways or ideas on how to accomplish this?
> Thanks!!!
>
>|||can you pass the field to sort on into the report as a parameter and use a
CASE in your query to conditionally sort based on whatever you passed in as
a parameter?
Bill
"Andy" <Andy@.discussions.microsoft.com> wrote in message
news:C80B4FC3-FA92-4ADE-BFEA-D6B0867FDE97@.microsoft.com...
> I am looking for the same solution. I have a client that I have promised
10
> reports to and they gave me a few but want sort capability on 5 different
> fields. I could say that those are 5 different reports, but there should
be
> an easy way to list the fields in a drop down parameter and adjust the
ORDER
> BY based on this. Shouldn't there?
> Thanks in advance.
> ANDY
> "Amon Borland" wrote:
> > Is there a way to have a report parameter for the selection of what
field
> > the user wants a table to be grouped on? For instance, the parameter
would
> > have 3 options, clientid, clientname, and clientcity. I want to be able
to
> > select one of these and have the table group on this selection.
> >
> > Or any generic ways or ideas on how to accomplish this?
> >
> > Thanks!!!
> >
> >
> >|||It seems all my replied are this..
Sorting is easy
DECLARE @.sql as varchar(100)
SET @.sql = 'SELECT * FROM blah WHERE blah = blah ORDER BY '
@.paramete
EXEC sp_executesql @.sq
Grouping on the other hand I don't think you can do dynamically

oracle publication

hi, i am trying to add an oracle publisher but i get the following
error
TITLE: Distributor Properties
Oracle server instance 'PS4289' cannot be enabled as a Publisher
because of the following error:
ADDITIONAL INFORMATION:
Unable to connect to Oracle database server 'PS4289' using the
Microsoft OLEDB provider MSDAORA. For addition information, see SQL
Server Error 21627 in Troubleshooting Oracle Publishers in SQL Server
Books Online. (Microsoft SQL Server, Error: 21627)
i do have an oracle 9i client installed on my machine and i can connect
to the oracle server through SQL PLUS.
any ideas?
i did find one difference in the requirements
my HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI shows
OracleOciLib = oct.dll
OracleSqlLib = SQLLib80.dll
OracleXalib = xa80.dll
while it requires
OracleOciLib = oci.dll
OracleSqlLib = orasql9.dll
OracleXaLib = oraclient9.dll
Udit Ghai wrote:
> hi, i am trying to add an oracle publisher but i get the following
> error
> TITLE: Distributor Properties
> --
> Oracle server instance 'PS4289' cannot be enabled as a Publisher
> because of the following error:
> --
> ADDITIONAL INFORMATION:
> Unable to connect to Oracle database server 'PS4289' using the
> Microsoft OLEDB provider MSDAORA. For addition information, see SQL
> Server Error 21627 in Troubleshooting Oracle Publishers in SQL Server
> Books Online. (Microsoft SQL Server, Error: 21627)
> i do have an oracle 9i client installed on my machine and i can connect
> to the oracle server through SQL PLUS.
> any ideas?
|||Sounds like you have not configured the oracle drivers correctly on your sql
server distributor. Ensure you can connect through the odbc drivers, and if
so, try to connect using the same servername, acccount and password in the
oracle publishing wizard.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Udit Ghai" <ghai.udit@.gmail.com> wrote in message
news:1163153354.699793.317120@.e3g2000cwe.googlegro ups.com...
> hi, i am trying to add an oracle publisher but i get the following
> error
> TITLE: Distributor Properties
> --
> Oracle server instance 'PS4289' cannot be enabled as a Publisher
> because of the following error:
> --
> ADDITIONAL INFORMATION:
> Unable to connect to Oracle database server 'PS4289' using the
> Microsoft OLEDB provider MSDAORA. For addition information, see SQL
> Server Error 21627 in Troubleshooting Oracle Publishers in SQL Server
> Books Online. (Microsoft SQL Server, Error: 21627)
> i do have an oracle 9i client installed on my machine and i can connect
> to the oracle server through SQL PLUS.
> any ideas?
>
|||suppose i have my TSN name as abc_server and the username and password
are
scott and tiger
then i use the server instance as abc_server and the username and
password as i have mentioned above and it does not connect to it and
sends the above error message.
then how do i connect to it. should i only mention the servername?
can u tell me which kind of connection string to use or a particular
driver if i also want it as a linked server?
Hilary Cotter wrote:[vbcol=seagreen]
> Sounds like you have not configured the oracle drivers correctly on your sql
> server distributor. Ensure you can connect through the odbc drivers, and if
> so, try to connect using the same servername, acccount and password in the
> oracle publishing wizard.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Udit Ghai" <ghai.udit@.gmail.com> wrote in message
> news:1163153354.699793.317120@.e3g2000cwe.googlegro ups.com...
|||Please can you post up the relevant bit of your TNSNames.ora file and
details of what you've entered in the ODBC settings dialogue.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||If you newly installed the oracle client on the distributor make sure you
reboot the machine.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23%23EJNfNBHHA.4844@.TK2MSFTNGP02.phx.gbl...
> Please can you post up the relevant bit of your TNSNames.ora file and
> details of what you've entered in the ODBC settings dialogue.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
>
|||thanks for your reply,
here is the TSNnames.ora entry
MEENU_PS4289.PERSISTENT.CO.IN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PS4289)(PORT = 1521))
)
(CONNECT_DATA =
(SID = meenu)
(SERVER = DEDICATED)
)
)
i didnt get the part about the ODBC settings. doesnt SQL SERVER use the
microsoft OLEDB provider MSDAORA in adding the oracle publisher
i use the following settings
server instance "meenu_PS4289"
"oracle standard authentication"
username "scott"
password "tiger"
do i have to set any other properties execpt these properties
Gopal Ashok[MSFT] wrote:[vbcol=seagreen]
> If you newly installed the oracle client on the distributor make sure you
> reboot the machine.
>
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:%23%23EJNfNBHHA.4844@.TK2MSFTNGP02.phx.gbl...
|||i also created a naming service for the oacle database on my server by
the name meenu and tried it out on SQL*PLUS and it works fine and if i
create a linked server
EXEC sp_addlinkedserver @.server = N'meenu', @.srvproduct=N'Oracle',
@.provider=N' MSDAORA', @.datasrc=N'meenu'
GO
sp_addlinkedsrvlogin 'meenu', false, 'sa', 'scott', 'tiger'
and then if i query
select * from meenu..scott.aaaa;
it gives the following error
"Msg 7403, Level 16, State 1, Line 5
The OLE DB provider " MSDAORA" has not been registered."
Udit Ghai wrote:[vbcol=seagreen]
> thanks for your reply,
> here is the TSNnames.ora entry
> MEENU_PS4289.PERSISTENT.CO.IN =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = PS4289)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = meenu)
> (SERVER = DEDICATED)
> )
> )
> i didnt get the part about the ODBC settings. doesnt SQL SERVER use the
> microsoft OLEDB provider MSDAORA in adding the oracle publisher
> i use the following settings
> server instance "meenu_PS4289"
> "oracle standard authentication"
> username "scott"
> password "tiger"
> do i have to set any other properties execpt these properties
> Gopal Ashok[MSFT] wrote:
|||Please try using "MEENU_PS4289.PERSISTENT.CO.IN" as the server name in the
OLEDB name.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||So you can connect from the SQL Server system to the Oracle System using
SQL*Plus? Just need to confirm that you arte not talking about the client
tools on the Oracle Server. If connection formm the SQL Server box is
successful, that removes the issue of firewalls at any rate.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Oracle linked server error

Hello,
sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
Oracle 9i client installed.
We have set up a linked server to an Oracle instance using the 'Microsoft
OLE DB Provider for Oracle', this works for a while without any problems and
then for an unknown reason ceases to work.
The only error messages I have been able to get is by running the t-sql query
SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
Server:Msg 7399, Level 16, State 1, Line 1
OLE DB Provider MSDAORA reported an error.
[OLE/DB provider returned message: Oracle error occured but error message
could not be retrieved from Oracle.}
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005:].
However using the Oracle client on the server I can still connect to any
Oracle instance but I have to stop and start the sql service to get the
linked server to work again, becuase I have to stop and start sql server I'm
presuming that the fault is with sql server.
Did you check out that article before ?
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
http://support.microsoft.com/dXefaul...en-us;Q280X106
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
> Hello,
> sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
> Oracle 9i client installed.
> We have set up a linked server to an Oracle instance using the 'Microsoft
> OLE DB Provider for Oracle', this works for a while without any problems
> and
> then for an unknown reason ceases to work.
> The only error messages I have been able to get is by running the t-sql
> query
> SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
> Server:Msg 7399, Level 16, State 1, Line 1
> OLE DB Provider MSDAORA reported an error.
> [OLE/DB provider returned message: Oracle error occured but error message
> could not be retrieved from Oracle.}
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
> returned 0x80004005:].
> However using the Oracle client on the server I can still connect to any
> Oracle instance but I have to stop and start the sql service to get the
> linked server to work again, becuase I have to stop and start sql server
> I'm
> presuming that the fault is with sql server.
>
>
|||Yes, I've seen this document and it has been of help to me before but not in
this case as the linked server works and then stops without notice
"Jens Sü?meyer" wrote:

> Did you check out that article before ?
> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
> http://support.microsoft.com/dXefau...n-us;Q280X106
>
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
> Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
>
>

Oracle linked server error

Hello,
sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
Oracle 9i client installed.
We have set up a linked server to an Oracle instance using the 'Microsoft
OLE DB Provider for Oracle', this works for a while without any problems and
then for an unknown reason ceases to work.
The only error messages I have been able to get is by running the t-sql quer
y
SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
Server:Msg 7399, Level 16, State 1, Line 1
OLE DB Provider MSDAORA reported an error.
[OLE/DB provider returned message: Oracle error occured but error messag
e
could not be retrieved from Oracle.}
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005:].
However using the Oracle client on the server I can still connect to any
Oracle instance but I have to stop and start the sql service to get the
linked server to work again, becuase I have to stop and start sql server I'm
presuming that the fault is with sql server.Did you check out that article before ?
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
http://support.microsoft.com/d_efau...;en-us;Q280_106
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
> Hello,
> sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
> Oracle 9i client installed.
> We have set up a linked server to an Oracle instance using the 'Microsoft
> OLE DB Provider for Oracle', this works for a while without any problems
> and
> then for an unknown reason ceases to work.
> The only error messages I have been able to get is by running the t-sql
> query
> SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
> Server:Msg 7399, Level 16, State 1, Line 1
> OLE DB Provider MSDAORA reported an error.
> [OLE/DB provider returned message: Oracle error occured but error mess
age
> could not be retrieved from Oracle.}
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005:].
> However using the Oracle client on the server I can still connect to any
> Oracle instance but I have to stop and start the sql service to get the
> linked server to work again, becuase I have to stop and start sql server
> I'm
> presuming that the fault is with sql server.
>
>|||Yes, I've seen this document and it has been of help to me before but not in
this case as the linked server works and then stops without notice
"Jens Sü?meyer" wrote:

> Did you check out that article before ?
> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
> http://support.microsoft.com/d_efa...en-us;Q280_106
>
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb
im
> Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
>
>

oracle and sql

is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnxThey both sure can be installed on the same machine. But I would only do
that on a development machine, not in production.
In a typical production scenario, both the RDBMSes will be competing for the
resources on the machine. Even from a maintenance point of view, if you have
to reboot the machine for the sake of applying an Oracle patch, you will
unnecessarily impact SQL Server users.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnx|||Hi,
I also agree with Vyas on this. Earlier I had a non critical production
server which has both SQL Server and Oracle.
For applying any pathes on SQL Server or Oracle needs a reboot and will
cause a downtime.
As well as the resource usage also will be high. So I recommend you to have
either one of this RDBMS installed in a single server.
Thanks
Hari
SQL Server MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the
> oracle server service more than 10 users max
> what issues could arise with such a setup
> thnx
>|||> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the orac
le
> server service more than 10 users max
> what issues could arise with such a setup
> thnx
OK
thnx for your input
it'll be an older server that will be used then
grtz

oracle and sql

is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnx
They both sure can be installed on the same machine. But I would only do
that on a development machine, not in production.
In a typical production scenario, both the RDBMSes will be competing for the
resources on the machine. Even from a maintenance point of view, if you have
to reboot the machine for the sake of applying an Oracle patch, you will
unnecessarily impact SQL Server users.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnx
|||Hi,
I also agree with Vyas on this. Earlier I had a non critical production
server which has both SQL Server and Oracle.
For applying any pathes on SQL Server or Oracle needs a reboot and will
cause a downtime.
As well as the resource usage also will be high. So I recommend you to have
either one of this RDBMS installed in a single server.
Thanks
Hari
SQL Server MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the
> oracle server service more than 10 users max
> what issues could arise with such a setup
> thnx
>
|||> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the oracle
> server service more than 10 users max
> what issues could arise with such a setup
> thnx
OK
thnx for your input
it'll be an older server that will be used then
grtz

oracle and sql

is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnxThey both sure can be installed on the same machine. But I would only do
that on a development machine, not in production.
In a typical production scenario, both the RDBMSes will be competing for the
resources on the machine. Even from a maintenance point of view, if you have
to reboot the machine for the sake of applying an Oracle patch, you will
unnecessarily impact SQL Server users.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
is it possible to have an oracle server (runtime) and an sql server on
the same machine, or better said, is it wise?
the instance of sql server is not that heavily used, neither will the
oracle server service more than 10 users max
what issues could arise with such a setup
thnx|||Hi,
I also agree with Vyas on this. Earlier I had a non critical production
server which has both SQL Server and Oracle.
For applying any pathes on SQL Server or Oracle needs a reboot and will
cause a downtime.
As well as the resource usage also will be high. So I recommend you to have
either one of this RDBMS installed in a single server.
Thanks
Hari
SQL Server MVP
"chriske911" <chriske911nospam@.yahoo.com> wrote in message
news:mn.fa317d5a865c2693.36062@.yahoo.com...
> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the
> oracle server service more than 10 users max
> what issues could arise with such a setup
> thnx
>|||> is it possible to have an oracle server (runtime) and an sql server on the
> same machine, or better said, is it wise?
> the instance of sql server is not that heavily used, neither will the oracle
> server service more than 10 users max
> what issues could arise with such a setup
> thnx
OK
thnx for your input
it'll be an older server that will be used then
grtz

Oracle 9i Database Administration in 10 Minutes

The Topics Covered In This Book Are: Understanding the Oracle
Environment; Understanding the Oracle Instance; Understanding the
working of Oracle Instance; Understanding the Oracle Database; Oracle
9i Software Installation; Oracle 9i Database Design using DBCA;
Enabling other computers to access Oracle Server; Oracle Enterprise
Manger Oracle Backup & Recovery -Simple Technique; Oracle Performance
Tuning. Everything in this book is covered in a step by step manner
by
first building reader's concept using analogies, real world examples
and then taking him/her to the steps of design implementation. The
book covers Oracle 9i Database Server. The concepts and most of the
stuff discussed in this book are equally good for other Oracle
versions including 10g. For advance user please check Oracle Database
Administration Concepts & Implementation Made Simple, ISBN:
0977073904.

The link is provided below:

http://www.lulu.com/takveentakveen@.gmail.com wrote:

Quote:

Originally Posted by

The Topics Covered In This Book Are: Understanding the Oracle
Environment;

This book is worthless spam in the Oracle usenet groups. It is
appalling here.

--
Daniel A. Morgan
University of Washington
damorgan@.x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org