Link with parameters

Hi,
is it possible to start a Report via Link (from Desktop) with start
parameter like an
ASP-Script
For example:
...report.rdl?Year=2007&Month=6...
Thank you
HansThat's what URL access in RS is for.
Amarnath
"Hans" wrote:
> Hi,
> is it possible to start a Report via Link (from Desktop) with start
> parameter like an
> ASP-Script
> For example:
>
> ...report.rdl?Year=2007&Month=6...
>
> Thank you
> Hans
>|||That what I mean ist to start the report from Desktop inclusive
parameters.
Hans|||ok,
so this is a sample you can use to see how it works if you have implemented
the samples and hosted the reports on localserver. copy this url from
desktop.. also you can write asp.net to mask this url and give just a
hyperlink from the page.. see the parameters also passed.
http://server/reportserver?/Sales/Northwest/Employee Sales
Report&rs:Command=Render&EmployeeID=1234
Amarnath
"Hans" wrote:
> That what I mean ist to start the report from Desktop inclusive
> parameters.
> Hans
>|||I tried this, but it doesn=B4t work. The report opens, but there=B4s not
selected parameter value.
Thanks,
Hans|||Hans,
Have you pasted my sample link as a whole URL because it is wraped in the
post.
Incase you have done this pl ignore, you said there is no parameter value,
so I thought you have not pasted the whole URL.
Amarnath, MCTS
"Hans" wrote:
> I tried this, but it doesn´t work. The report opens, but there´s not
> selected parameter value.
>
> Thanks,
> Hans
>

Link to Server via Windows Authentication

Well, then everyone who used the linked server will be
using the new account created. I want people to only use
what thier domain account has permissions to do.
Any way to do this?
>--Original Message--
>You'll need to create a domain account that has login
>permissions to SQL Server "A" and the appropriate
database
>permissions as well. Use this account for the user login
>credentials when you create the link.
>Steve
>.
>You can use delegation to accomplish this. You can find
information on this in books online under the topic:
Security Account Delegation
-Sue
On Mon, 1 Mar 2004 06:57:34 -0800, "Linda"
<anonymous@.discussions.microsoft.com> wrote:
>Well, then everyone who used the linked server will be
>using the new account created. I want people to only use
>what thier domain account has permissions to do.
>Any way to do this?
>database

Link to Different SQL Database

I had connect another SQL server VIA VPN , the server name is IP e,g
123.123.123.123
I can read the data sucessfully,
However, I want to insert some data from my local server.
sp_addlinked server '123.123.123.13'
sp_linkedserver (I can see it)
then select * from [123.123.123.123].database.dbo.myTable
I got an error said 'SQL Server does not exist or access denied'
Does any one can help , ThanksHi
You example shows two different IP addresses!!
John
"Agnes" wrote:

> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.13'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>|||Sorry, the IP in my example should be the same
"John Bell" <jbellnewsposts@.h0tmail.com> glsD:7C2DF328-79A7-4836-912F-3A2CB6D803C
3@.microsoft.com...
> Hi
> You example shows two different IP addresses!!
> John
> "Agnes" wrote:
>|||Hi!
After adding the linked server you should tell SQL server which user on
local server may access remote server with system procedure
sp_addlinkedsrvlogin (see on BOL for details).
One useful idea is to add a name to the linked server in spite of the IP
address.
Hope that helps.
Joo Arajo
"Agnes" <agnes@.dynamictech.com.hk> escreveu na mensagem
news:OU2n3EvVFHA.2700@.TK2MSFTNGP12.phx.gbl...
>I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.13'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>|||I had process sp_addlinkedserverlogin , but still got error.
BTw, how can i alias the linked server name ?
THanks
"Joo Arajo" <joaoribeiroaraujo_DOMINIOIOL_@.nospam.PT> glsD:OF7DQ8zVFHA.3704@.TK2
MSFTNGP14.phx.gbl...
> Hi!
> After adding the linked server you should tell SQL server which user on
> local server may access remote server with system procedure
> sp_addlinkedsrvlogin (see on BOL for details).
> One useful idea is to add a name to the linked server in spite of the IP
> address.
> Hope that helps.
> Joo Arajo
> "Agnes" <agnes@.dynamictech.com.hk> escreveu na mensagem
> news:OU2n3EvVFHA.2700@.TK2MSFTNGP12.phx.gbl...
>|||Hi
Try something like:
EXEC sp_addlinkedserver @.server=3D'Remote_Svr', @.srvproduct=3D'',
@.provider=3D'SQLOLEDB',
@.datasrc=3D'123.123.123.123'
You can then use Remove_Svr as the name in your query. It sounds like
the login you are using does not have the correct permissions. You may
want to make sure that DTC is running on the server (although I would
expect a different message). You could use profiler on the remote
server to see what is happening.
John
Agnes wrote:
> I had process sp_addlinkedserverlogin , but still got error.
> BTw, how can i alias the linked server name ?
> THanks
> "Jo=E3o Ara=FAjo" <joaoribeiroaraujo_DOMINIOIOL_@.nospam.PT>
=BC=B6=BCg=A9=F3=B6l=A5=F3=B7s=BBD:OF7DQ
8zVFHA.3704@.TK2MSFTNGP14.phx.gbl...
user on
the IP
e,g|||Hi
Why should u put the IP Address in SELECT Statement , u can use the link
server Name '
U can also use the OPENQUERY for this as
SELECT * FROM OPENQUERY('SQL STATAEMENT')
Renjith
"Agnes" wrote:

> I had connect another SQL server VIA VPN , the server name is IP e,g
> 123.123.123.123
> I can read the data sucessfully,
> However, I want to insert some data from my local server.
> sp_addlinked server '123.123.123.13'
> sp_linkedserver (I can see it)
> then select * from [123.123.123.123].database.dbo.myTable
> I got an error said 'SQL Server does not exist or access denied'
> Does any one can help , Thanks
>
>sql

Link Server to MySQL Database

Hi

I ma trying to create a linked server to a MySQL database via ODBC. I am running SQL 2005 on Windows 2003 R2 (64-bit). Can any one point me in the right direction .

Any ideas|||MSDASQL (provider shipped with SS2005 which serves as OLEDB-ODBC bridge) is not supported in 64-bit. Check if there is an 64-bit OLEDB provider for MySQL that you can use directly.|||

Thanks for that i will look into it.

|||

Hi James,

Were you able to do that? I am having the trouble doing the same. If you have done, could you please post the procedure.

Thanks,

Neelesh:)

|||Unfortunatly I have not had much time to look at it. I have not managed to find a free / cheap OLE MYSQL driver. Sorry I was not much help|||Can you guys post your email? I can send you a documentation for creating linked servers with MySQL|||

My email address is jamesholmes@.greggs.co.uk

Thanks

|||

Have you tried email me ?

Thanks

Link Server to MySQL Database

Hi

I ma trying to create a linked server to a MySQL database via ODBC. I am running SQL 2005 on Windows 2003 R2 (64-bit). Can any one point me in the right direction .

Any ideas|||MSDASQL (provider shipped with SS2005 which serves as OLEDB-ODBC bridge) is not supported in 64-bit. Check if there is an 64-bit OLEDB provider for MySQL that you can use directly.|||

Thanks for that i will look into it.

|||

Hi James,

Were you able to do that? I am having the trouble doing the same. If you have done, could you please post the procedure.

Thanks,

Neelesh:)

|||Unfortunatly I have not had much time to look at it. I have not managed to find a free / cheap OLE MYSQL driver. Sorry I was not much help|||Can you guys post your email? I can send you a documentation for creating linked servers with MySQL|||

My email address is jamesholmes@.greggs.co.uk

Thanks

|||

Have you tried email me ?

Thanks

Link Access to SQL via MSDE

I have an MSDE database with a linked SQL server defined in it.
Is it possible to create a table in an Access database which is linked to a
table in the SQL server by going through the MSDE linked server.
I can easily create linked tables in Access to a db defined in MSDE, or SQL
Server, but I cannot find the magic bullet to let Access link through MSDE
to the linked SQL server.
Thanks,
Howard
No. Create the linked table directly to the SQL Server you are
interested in, or create a view in MSDE that pulls the data in the SQL
Server and link to that.
--Mary
On Fri, 27 Aug 2004 10:47:22 -0400, "Howard" <howardpo@.hotmail.com>
wrote:

>I have an MSDE database with a linked SQL server defined in it.
>Is it possible to create a table in an Access database which is linked to a
>table in the SQL server by going through the MSDE linked server.
>I can easily create linked tables in Access to a db defined in MSDE, or SQL
>Server, but I cannot find the magic bullet to let Access link through MSDE
>to the linked SQL server.
>Thanks,
>Howard
>
|||A view wouldn't work because the client needs it to be updatable.
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:uiavi05gjd1mt1dagti4c2rm80fhi3tfqr@.4ax.com... [vbcol=seagreen]
> No. Create the linked table directly to the SQL Server you are
> interested in, or create a view in MSDE that pulls the data in the SQL
> Server and link to that.
> --Mary
> On Fri, 27 Aug 2004 10:47:22 -0400, "Howard" <howardpo@.hotmail.com>
> wrote:
a[vbcol=seagreen]
SQL[vbcol=seagreen]
MSDE
>
|||Views can be updateable if you tell Access what the PK/unique index
is, but I would recommend linking directly to the SQLS table instead
of trying to go through linked servers. If that is not possible, a
second option would be to not use links at all for the updates. Write
stored procedures in the MSDE database that update the SQLS database,
and pass parameters to the MSDE stored procedures from your Access FE.
More work, and you need to handle possible concurrency conflicts
yourself, but it eliminates the linked-servers-from-Access potential
boondoggle you are contemplating.
--Mary
On Sat, 28 Aug 2004 09:34:11 -0400, "Howard" <howardpo@.hotmail.com>
wrote:

>A view wouldn't work because the client needs it to be updatable.
>"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
>news:uiavi05gjd1mt1dagti4c2rm80fhi3tfqr@.4ax.com.. .
>a
>SQL
>MSDE
>

Limit? Rowid?

Hi,
I am writing a "universal" db-Interface and just finished the postgres
and mysql part. I got somehow stuck on the MS SQL Server part (via
ODBC).
I have no access to the SQL Server CD or the machine where it is
running, I access the database only via a VPN tunnel and ODBC.
My question is:
How can I use something like the "LIMIT " command?
How can I get the actual "_rowid" (not the primary key, but the row-id
of the result set.)
Something like:
Select * from article Limit 5,10
Select _rowid from article where id = "XYZ-123"
Update article set amount = 15 where _rowid = 23
And how to get the table definition, something like "Describe article;"
oder "Show create table article;" ?
Is there a simple online reference for this SQL dialect that SQL Server
via ODBC uses?
Thank you for your help
RobertRobert
What vesrion are you using?
SQL Server 2005
There is new function ROW_NUMBER()
SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY score DESC) AS rownum,
columns
FROM Table
) AS Der WHERE rownum BETWEEN 5 AND 10
SQL Server 2000
SELECT * FROM Table WHERE (SELECT COUNT(*) FROM Table t WHERE
t.PK<=Table.PK)
BETWEEN 5 AND 10
pk-Primary keys
Actualy if it does not help you ,please post DDL+ sample data + an expected
result
"Robert Eisig" <quantumchaos666@.gmx.net> wrote in message
news:1143380427.955422.222930@.u72g2000cwu.googlegroups.com...
> Hi,
> I am writing a "universal" db-Interface and just finished the postgres
> and mysql part. I got somehow stuck on the MS SQL Server part (via
> ODBC).
> I have no access to the SQL Server CD or the machine where it is
> running, I access the database only via a VPN tunnel and ODBC.
> My question is:
> How can I use something like the "LIMIT " command?
> How can I get the actual "_rowid" (not the primary key, but the row-id
> of the result set.)
> Something like:
> Select * from article Limit 5,10
> Select _rowid from article where id = "XYZ-123"
> Update article set amount = 15 where _rowid = 23
> And how to get the table definition, something like "Describe article;"
> oder "Show create table article;" ?
> Is there a simple online reference for this SQL dialect that SQL Server
> via ODBC uses?
> Thank you for your help
> Robert
>|||Robert Eisig wrote:
> Hi,
> I am writing a "universal" db-Interface and just finished the postgres
> and mysql part. I got somehow stuck on the MS SQL Server part (via
> ODBC).
> I have no access to the SQL Server CD or the machine where it is
> running, I access the database only via a VPN tunnel and ODBC.
> My question is:
> How can I use something like the "LIMIT " command?
> How can I get the actual "_rowid" (not the primary key, but the row-id
> of the result set.)
> Something like:
> Select * from article Limit 5,10
> Select _rowid from article where id = "XYZ-123"
> Update article set amount = 15 where _rowid = 23
> And how to get the table definition, something like "Describe article;"
> oder "Show create table article;" ?
> Is there a simple online reference for this SQL dialect that SQL Server
> via ODBC uses?
> Thank you for your help
> Robert
There is no such "rowid" concept in SQL Server. An exposed row number
based on anything other than values in the table violates the
relational Information Principle. So it's not a feature we should
expect or desire from a well-designed SQL DBMS - something you should
bear in mind if you want to create an app that is portable across many
database products.
SQL Server 2005 does support the ANSI standard RANK() and ROW_NUMBER()
functions, which derive their values from the column(s) specified with
the ORDER BY syntax. Make sure you specify a unique key for ORDER BY so
as to guarantee a deterministic result.
See my signature for a link to the SQL Server docs.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Limit is what we use in MYSQL no?
We can consider TOP clause of Sql Server similar to LIMIT.
Like,
Select * from article Limit 5
select top 5 * from article
For a specific range...
Select * from article Limit 5,10
Playing with 'IN' clause you can get LIMIT 5-10.
select TOP 5 * from article where articleid in (Select TOP 10 articleid
from article ) ORDER BY DESC
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Robert Eisig" wrote:
> Hi,
> I am writing a "universal" db-Interface and just finished the postgres
> and mysql part. I got somehow stuck on the MS SQL Server part (via
> ODBC).
> I have no access to the SQL Server CD or the machine where it is
> running, I access the database only via a VPN tunnel and ODBC.
> My question is:
> How can I use something like the "LIMIT " command?
> How can I get the actual "_rowid" (not the primary key, but the row-id
> of the result set.)
> Something like:
> Select * from article Limit 5,10
> Select _rowid from article where id = "XYZ-123"
> Update article set amount = 15 where _rowid = 23
> And how to get the table definition, something like "Describe article;"
> oder "Show create table article;" ?
> Is there a simple online reference for this SQL dialect that SQL Server
> via ODBC uses?
> Thank you for your help
> Robert
>|||The concept of rowid or recid on other database products and row_number() in
SQL Server have nothing in common. rowid is permanent on a record event after
database shutdown. row_number() in SQL Server is just a sequential number
within a partition of a result set.
Ben Nevarez, MCDBA, OCP
Database Administrator
"David Portas" wrote:
> Robert Eisig wrote:
> > Hi,
> >
> > I am writing a "universal" db-Interface and just finished the postgres
> > and mysql part. I got somehow stuck on the MS SQL Server part (via
> > ODBC).
> >
> > I have no access to the SQL Server CD or the machine where it is
> > running, I access the database only via a VPN tunnel and ODBC.
> >
> > My question is:
> >
> > How can I use something like the "LIMIT " command?
> >
> > How can I get the actual "_rowid" (not the primary key, but the row-id
> > of the result set.)
> >
> > Something like:
> >
> > Select * from article Limit 5,10
> >
> > Select _rowid from article where id = "XYZ-123"
> >
> > Update article set amount = 15 where _rowid = 23
> >
> > And how to get the table definition, something like "Describe article;"
> > oder "Show create table article;" ?
> >
> > Is there a simple online reference for this SQL dialect that SQL Server
> > via ODBC uses?
> >
> > Thank you for your help
> > Robert
> There is no such "rowid" concept in SQL Server. An exposed row number
> based on anything other than values in the table violates the
> relational Information Principle. So it's not a feature we should
> expect or desire from a well-designed SQL DBMS - something you should
> bear in mind if you want to create an app that is portable across many
> database products.
> SQL Server 2005 does support the ANSI standard RANK() and ROW_NUMBER()
> functions, which derive their values from the column(s) specified with
> the ORDER BY syntax. Make sure you specify a unique key for ORDER BY so
> as to guarantee a deterministic result.
> See my signature for a link to the SQL Server docs.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Ben Nevarez wrote:
> The concept of rowid or recid on other database products and row_number() in
> SQL Server have nothing in common. rowid is permanent on a record event after
> database shutdown. row_number() in SQL Server is just a sequential number
> within a partition of a result set.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
That's correct. A permanent "rowid" violates the Information Principle.
A ROW_NUMBER() function (provided it is generated deterministically
from data in the table) does not.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--