Hi all
I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:listener could not resolve SERVICE_NAME given in connect description"
I have read article 280106 (troubleshooting) that didn't help
I appreciate any guidance
RayThe Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:
>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray
Showing posts with label create. Show all posts
Showing posts with label create. Show all posts
Friday, March 30, 2012
Link to Oracel database
Hi all,
I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:l
istener could not resolve SERVICE_NAME given in connect description".
I have read article 280106 (troubleshooting) that didn't help.
I appreciate any guidance.
Ray
The Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:
>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:
listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray
I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:l
istener could not resolve SERVICE_NAME given in connect description".
I have read article 280106 (troubleshooting) that didn't help.
I appreciate any guidance.
Ray
The Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:
>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server to an oracle database. I have installed Oracle client on the server, but when try to test the connection using Oracle Net Configuration Assistant, I'm getting error: "TNS:
listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray
Link to Oracel database
Hi all,
I am running SQL Server 2000 Enterprise Edition and I want to create a link
server to an oracle database. I have installed Oracle client on the server,
but when try to test the connection using Oracle Net Configuration Assistant
, I'm getting error: "TNS:l
istener could not resolve SERVICE_NAME given in connect description".
I have read article 280106 (troubleshooting) that didn't help.
I appreciate any guidance.
RayThe Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:
>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server
to an oracle database. I have installed Oracle client on the server, but when try to
test the connection using Oracle Net Configuration Assistant, I'm getting error: "T
NS:
listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray
I am running SQL Server 2000 Enterprise Edition and I want to create a link
server to an oracle database. I have installed Oracle client on the server,
but when try to test the connection using Oracle Net Configuration Assistant
, I'm getting error: "TNS:l
istener could not resolve SERVICE_NAME given in connect description".
I have read article 280106 (troubleshooting) that didn't help.
I appreciate any guidance.
RayThe Net Assistant doesn't always generate correct
tnsnames.ora and listener.ora files. You most likely have
something missing in one of these files.
Make sure the Oracle home is specified correctly and that
you have a SID_LIST_LISTENER entry which specifies the sid
that the listener is listening for.
-Sue
On Wed, 9 Jun 2004 12:46:10 -0700, Ray
<anonymous@.discussions.microsoft.com> wrote:
>Hi all,
>I am running SQL Server 2000 Enterprise Edition and I want to create a link server
to an oracle database. I have installed Oracle client on the server, but when try to
test the connection using Oracle Net Configuration Assistant, I'm getting error: "T
NS:
listener could not resolve SERVICE_NAME given in connect description".
>I have read article 280106 (troubleshooting) that didn't help.
>I appreciate any guidance.
>Ray
link to mysql
I tired to create a link 'MYSQL' in a SQL Server using the following code :
EXEC sp_addlinkedserver
@.server = mysql,
@.provider = 'MSDASQL',
@.provstr = 'DRIVER={MySQL ODBC 3.51 Driver};SERVER=MySQLServer;UID=root;PWD=;'
NB: I have a DB by the name of : MYSQL
There is no errors during creation ...
The link creation is OK but I am not able to see tables from SQL Server
Any Idea ?Linked server login mappings can be added using sp_addlinkedsrvlogin and refer to books online for more information.|||No it ok for the link creation but we have the following error :
Msg 7314, Niveau 16, tat 1, Ligne 1
when execution :
select * from mysql...host
any idea ?|||When setting up the linked server you need to map your local login to appropirate remote/destination server's login.|||The mapping is OK ? really, I don't inerstant the pb ?
Did you try to to this with a MYSQL DB ?|||You shoudl use OPENQUERY method to access the data.
However, the openquery() method ALWAYS worked while the suggested method of SERVER.CATALOG.OWNER.TABLE will have some issues.
Ensure you've MyODBC installed properly on SQL server.
I don't have any issues in using MySQL as LS.|||Could you please give us an example (with MySQL Server)
Could you tell us what is :
SERVER under MySQL
CATALOG under MySQL
OWNER under MySQL
Could you give us a query example with a table from the default Mysql DB.
Indeed, I successed to have a resultat when using OPENQUERY :
But it doesn't work every time (it depends of the row nb in the table I think).
So it is OK for :
SELECT * FROM OPENQUERY (mysql,'SELECT * FROM db where 1=2')
But not for :
SELECT * FROM OPENQUERY (mysql,'SELECT * FROM db)
Error : Msg 7347
Help !!!!!!!
EXEC sp_addlinkedserver
@.server = mysql,
@.provider = 'MSDASQL',
@.provstr = 'DRIVER={MySQL ODBC 3.51 Driver};SERVER=MySQLServer;UID=root;PWD=;'
NB: I have a DB by the name of : MYSQL
There is no errors during creation ...
The link creation is OK but I am not able to see tables from SQL Server
Any Idea ?Linked server login mappings can be added using sp_addlinkedsrvlogin and refer to books online for more information.|||No it ok for the link creation but we have the following error :
Msg 7314, Niveau 16, tat 1, Ligne 1
when execution :
select * from mysql...host
any idea ?|||When setting up the linked server you need to map your local login to appropirate remote/destination server's login.|||The mapping is OK ? really, I don't inerstant the pb ?
Did you try to to this with a MYSQL DB ?|||You shoudl use OPENQUERY method to access the data.
However, the openquery() method ALWAYS worked while the suggested method of SERVER.CATALOG.OWNER.TABLE will have some issues.
Ensure you've MyODBC installed properly on SQL server.
I don't have any issues in using MySQL as LS.|||Could you please give us an example (with MySQL Server)
Could you tell us what is :
SERVER under MySQL
CATALOG under MySQL
OWNER under MySQL
Could you give us a query example with a table from the default Mysql DB.
Indeed, I successed to have a resultat when using OPENQUERY :
But it doesn't work every time (it depends of the row nb in the table I think).
So it is OK for :
SELECT * FROM OPENQUERY (mysql,'SELECT * FROM db where 1=2')
But not for :
SELECT * FROM OPENQUERY (mysql,'SELECT * FROM db)
Error : Msg 7347
Help !!!!!!!
Wednesday, March 28, 2012
Link to a table
There is a way to create a link from a SQL Server database to a table located on a MSAccess database? I mean like creating links from MSAccess to other databases. The requested table is updated many times/day, and I dont want to import the table each time an update happens.
Thanks,
Richard
Sure. You can use linked servers, which is easy to configure in Enterprise Manager. You can take a look at this link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp
|||Thanks!Link to a report with parameters
I need to create a report with some parameters for filtering data.
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is the format of link for passing parameters to filter data?
Many thanks1. Try leaving the parameter Prompt blank... This should prevent the
parameter from displaying, (but you must provide a default value...)
2. Search for URL Access in Books on line and you will get an entire list
of all of the things you can do via URL in reporting services.
Hope this helps..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pasquale" wrote:
> I need to create a report with some parameters for filtering data.
> This report must be called by URL link on an Html page.
> This link must contains the values of these parameters; I don' want
> specify the values when I see the report by clicking on View report button.
> Is it possible? How?
> What is the format of link for passing parameters to filter data?
> Many thanks|||I tried passing parameters in URL address successfully,
but I see some parameters that the user hasn't change!
Moreover, if I change the parameter property "User request"
by setting to false value, the call of report dumps!
The issue is partially solved! I need to pass a parameter by Url
and these parameters cannot change by a user.
Can I solve this problem URGENTLY?
Many thanks
"Wayne Snyder" wrote:
> 1. Try leaving the parameter Prompt blank... This should prevent the
> parameter from displaying, (but you must provide a default value...)
> 2. Search for URL Access in Books on line and you will get an entire list
> of all of the things you can do via URL in reporting services.
> Hope this helps..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Pasquale" wrote:
> > I need to create a report with some parameters for filtering data.
> > This report must be called by URL link on an Html page.
> > This link must contains the values of these parameters; I don' want
> > specify the values when I see the report by clicking on View report button.
> > Is it possible? How?
> > What is the format of link for passing parameters to filter data?
> >
> > Many thanks|||Read the rest of Wayne's post. He is telling you how to hide a parameter so
the user doesn't see it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>I tried passing parameters in URL address successfully,
> but I see some parameters that the user hasn't change!
> Moreover, if I change the parameter property "User request"
> by setting to false value, the call of report dumps!
> The issue is partially solved! I need to pass a parameter by Url
> and these parameters cannot change by a user.
> Can I solve this problem URGENTLY?
> Many thanks
>
> "Wayne Snyder" wrote:
>> 1. Try leaving the parameter Prompt blank... This should prevent the
>> parameter from displaying, (but you must provide a default value...)
>> 2. Search for URL Access in Books on line and you will get an entire
>> list
>> of all of the things you can do via URL in reporting services.
>> Hope this helps..
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''s
>> community of SQL Professionals.
>>
>> "Pasquale" wrote:
>> > I need to create a report with some parameters for filtering data.
>> > This report must be called by URL link on an Html page.
>> > This link must contains the values of these parameters; I don' want
>> > specify the values when I see the report by clicking on View report
>> > button.
>> > Is it possible? How?
>> > What is the format of link for passing parameters to filter data?
>> >
>> > Many thanks|||I have executed several tries modifying the parameter settings.
I have followed your suggests, but the solution isn't complete:
or I see the parameter or I cannot modify the parameter
that I pass via URL (an error occurs!!!)!
Many thanks
"Bruce L-C [MVP]" wrote:
> Read the rest of Wayne's post. He is telling you how to hide a parameter so
> the user doesn't see it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >I tried passing parameters in URL address successfully,
> > but I see some parameters that the user hasn't change!
> > Moreover, if I change the parameter property "User request"
> > by setting to false value, the call of report dumps!
> >
> > The issue is partially solved! I need to pass a parameter by Url
> > and these parameters cannot change by a user.
> >
> > Can I solve this problem URGENTLY?
> >
> > Many thanks
> >
> >
> > "Wayne Snyder" wrote:
> >
> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> parameter from displaying, (but you must provide a default value...)
> >>
> >> 2. Search for URL Access in Books on line and you will get an entire
> >> list
> >> of all of the things you can do via URL in reporting services.
> >>
> >> Hope this helps..
> >> --
> >> Wayne Snyder MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >>
> >> I support the Professional Association for SQL Server ( PASS) and it''s
> >> community of SQL Professionals.
> >>
> >>
> >> "Pasquale" wrote:
> >>
> >> > I need to create a report with some parameters for filtering data.
> >> > This report must be called by URL link on an Html page.
> >> > This link must contains the values of these parameters; I don' want
> >> > specify the values when I see the report by clicking on View report
> >> > button.
> >> > Is it possible? How?
> >> > What is the format of link for passing parameters to filter data?
> >> >
> >> > Many thanks
>
>|||Two different things. First is getting the parameters to work. Then making
them hidden. Do you have them working properly so you know your URL is
correct. Be sure that your parameter is with the correct case since RS is
case sensitive with parameters. Once you know your URL is correct because
your report works properly then you can deal with hidding the parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>I have executed several tries modifying the parameter settings.
> I have followed your suggests, but the solution isn't complete:
> or I see the parameter or I cannot modify the parameter
> that I pass via URL (an error occurs!!!)!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Read the rest of Wayne's post. He is telling you how to hide a parameter
>> so
>> the user doesn't see it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >I tried passing parameters in URL address successfully,
>> > but I see some parameters that the user hasn't change!
>> > Moreover, if I change the parameter property "User request"
>> > by setting to false value, the call of report dumps!
>> >
>> > The issue is partially solved! I need to pass a parameter by Url
>> > and these parameters cannot change by a user.
>> >
>> > Can I solve this problem URGENTLY?
>> >
>> > Many thanks
>> >
>> >
>> > "Wayne Snyder" wrote:
>> >
>> >> 1. Try leaving the parameter Prompt blank... This should prevent the
>> >> parameter from displaying, (but you must provide a default value...)
>> >>
>> >> 2. Search for URL Access in Books on line and you will get an entire
>> >> list
>> >> of all of the things you can do via URL in reporting services.
>> >>
>> >> Hope this helps..
>> >> --
>> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> Mariner, Charlotte, NC
>> >>
>> >> I support the Professional Association for SQL Server ( PASS) and
>> >> it''s
>> >> community of SQL Professionals.
>> >>
>> >>
>> >> "Pasquale" wrote:
>> >>
>> >> > I need to create a report with some parameters for filtering data.
>> >> > This report must be called by URL link on an Html page.
>> >> > This link must contains the values of these parameters; I don' want
>> >> > specify the values when I see the report by clicking on View report
>> >> > button.
>> >> > Is it possible? How?
>> >> > What is the format of link for passing parameters to filter data?
>> >> >
>> >> > Many thanks
>>|||My issue has two aspects:
1. passing a parameter via URL to call my report filtering data by the
parameter;
2. hide or protect parameter inside report manager to avoid any user's
changes.
The first step is solved. The report is called correctly and I see the
correct value
of parameter (the same written in the URL). I have written correctly the
name of parameter.
Now, when I set user request for the parameter, inside report manager, to
false
in order to hide the parameter, this message error occurs:
"sReadOnlyReportParameter" and I cannot the value of parameter by the value
in the URL.
This strange behaviour represents a limit of RS!
Moreover, I have specified a default value of parameter with a particular
value.
Now, is it really possible to solve completely this issue?
Do I have a particular SP (SP1, SP2, ...)?
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||I have controlled all settings of the report; then I try to set to blank
the user request string inside report manager (maintaning a default
value for the parameter): so, I can modify the parameter by passing it
via URL and simultaneously hide it in order to avoid any user's changes.
Finally, the issue is solved!!!
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||Making parameters hidden is much more straight forward in RS 2005. I don't
hide parameters so I have not had that issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:8DE20C29-CBB1-4020-93BD-6D8C71361AD2@.microsoft.com...
>I have controlled all settings of the report; then I try to set to blank
> the user request string inside report manager (maintaning a default
> value for the parameter): so, I can modify the parameter by passing it
> via URL and simultaneously hide it in order to avoid any user's changes.
> Finally, the issue is solved!!!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Two different things. First is getting the parameters to work. Then
>> making
>> them hidden. Do you have them working properly so you know your URL is
>> correct. Be sure that your parameter is with the correct case since RS is
>> case sensitive with parameters. Once you know your URL is correct because
>> your report works properly then you can deal with hidding the parameters.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>> >I have executed several tries modifying the parameter settings.
>> > I have followed your suggests, but the solution isn't complete:
>> > or I see the parameter or I cannot modify the parameter
>> > that I pass via URL (an error occurs!!!)!
>> >
>> > Many thanks
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Read the rest of Wayne's post. He is telling you how to hide a
>> >> parameter
>> >> so
>> >> the user doesn't see it.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >> >I tried passing parameters in URL address successfully,
>> >> > but I see some parameters that the user hasn't change!
>> >> > Moreover, if I change the parameter property "User request"
>> >> > by setting to false value, the call of report dumps!
>> >> >
>> >> > The issue is partially solved! I need to pass a parameter by Url
>> >> > and these parameters cannot change by a user.
>> >> >
>> >> > Can I solve this problem URGENTLY?
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >> > "Wayne Snyder" wrote:
>> >> >
>> >> >> 1. Try leaving the parameter Prompt blank... This should prevent
>> >> >> the
>> >> >> parameter from displaying, (but you must provide a default
>> >> >> value...)
>> >> >>
>> >> >> 2. Search for URL Access in Books on line and you will get an
>> >> >> entire
>> >> >> list
>> >> >> of all of the things you can do via URL in reporting services.
>> >> >>
>> >> >> Hope this helps..
>> >> >> --
>> >> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> >> Mariner, Charlotte, NC
>> >> >>
>> >> >> I support the Professional Association for SQL Server ( PASS) and
>> >> >> it''s
>> >> >> community of SQL Professionals.
>> >> >>
>> >> >>
>> >> >> "Pasquale" wrote:
>> >> >>
>> >> >> > I need to create a report with some parameters for filtering
>> >> >> > data.
>> >> >> > This report must be called by URL link on an Html page.
>> >> >> > This link must contains the values of these parameters; I don'
>> >> >> > want
>> >> >> > specify the values when I see the report by clicking on View
>> >> >> > report
>> >> >> > button.
>> >> >> > Is it possible? How?
>> >> >> > What is the format of link for passing parameters to filter data?
>> >> >> >
>> >> >> > Many thanks
>> >>
>> >>
>> >>
>>sql
This report must be called by URL link on an Html page.
This link must contains the values of these parameters; I don' want
specify the values when I see the report by clicking on View report button.
Is it possible? How?
What is the format of link for passing parameters to filter data?
Many thanks1. Try leaving the parameter Prompt blank... This should prevent the
parameter from displaying, (but you must provide a default value...)
2. Search for URL Access in Books on line and you will get an entire list
of all of the things you can do via URL in reporting services.
Hope this helps..
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Pasquale" wrote:
> I need to create a report with some parameters for filtering data.
> This report must be called by URL link on an Html page.
> This link must contains the values of these parameters; I don' want
> specify the values when I see the report by clicking on View report button.
> Is it possible? How?
> What is the format of link for passing parameters to filter data?
> Many thanks|||I tried passing parameters in URL address successfully,
but I see some parameters that the user hasn't change!
Moreover, if I change the parameter property "User request"
by setting to false value, the call of report dumps!
The issue is partially solved! I need to pass a parameter by Url
and these parameters cannot change by a user.
Can I solve this problem URGENTLY?
Many thanks
"Wayne Snyder" wrote:
> 1. Try leaving the parameter Prompt blank... This should prevent the
> parameter from displaying, (but you must provide a default value...)
> 2. Search for URL Access in Books on line and you will get an entire list
> of all of the things you can do via URL in reporting services.
> Hope this helps..
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Pasquale" wrote:
> > I need to create a report with some parameters for filtering data.
> > This report must be called by URL link on an Html page.
> > This link must contains the values of these parameters; I don' want
> > specify the values when I see the report by clicking on View report button.
> > Is it possible? How?
> > What is the format of link for passing parameters to filter data?
> >
> > Many thanks|||Read the rest of Wayne's post. He is telling you how to hide a parameter so
the user doesn't see it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>I tried passing parameters in URL address successfully,
> but I see some parameters that the user hasn't change!
> Moreover, if I change the parameter property "User request"
> by setting to false value, the call of report dumps!
> The issue is partially solved! I need to pass a parameter by Url
> and these parameters cannot change by a user.
> Can I solve this problem URGENTLY?
> Many thanks
>
> "Wayne Snyder" wrote:
>> 1. Try leaving the parameter Prompt blank... This should prevent the
>> parameter from displaying, (but you must provide a default value...)
>> 2. Search for URL Access in Books on line and you will get an entire
>> list
>> of all of the things you can do via URL in reporting services.
>> Hope this helps..
>> --
>> Wayne Snyder MCDBA, SQL Server MVP
>> Mariner, Charlotte, NC
>> I support the Professional Association for SQL Server ( PASS) and it''s
>> community of SQL Professionals.
>>
>> "Pasquale" wrote:
>> > I need to create a report with some parameters for filtering data.
>> > This report must be called by URL link on an Html page.
>> > This link must contains the values of these parameters; I don' want
>> > specify the values when I see the report by clicking on View report
>> > button.
>> > Is it possible? How?
>> > What is the format of link for passing parameters to filter data?
>> >
>> > Many thanks|||I have executed several tries modifying the parameter settings.
I have followed your suggests, but the solution isn't complete:
or I see the parameter or I cannot modify the parameter
that I pass via URL (an error occurs!!!)!
Many thanks
"Bruce L-C [MVP]" wrote:
> Read the rest of Wayne's post. He is telling you how to hide a parameter so
> the user doesn't see it.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >I tried passing parameters in URL address successfully,
> > but I see some parameters that the user hasn't change!
> > Moreover, if I change the parameter property "User request"
> > by setting to false value, the call of report dumps!
> >
> > The issue is partially solved! I need to pass a parameter by Url
> > and these parameters cannot change by a user.
> >
> > Can I solve this problem URGENTLY?
> >
> > Many thanks
> >
> >
> > "Wayne Snyder" wrote:
> >
> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> parameter from displaying, (but you must provide a default value...)
> >>
> >> 2. Search for URL Access in Books on line and you will get an entire
> >> list
> >> of all of the things you can do via URL in reporting services.
> >>
> >> Hope this helps..
> >> --
> >> Wayne Snyder MCDBA, SQL Server MVP
> >> Mariner, Charlotte, NC
> >>
> >> I support the Professional Association for SQL Server ( PASS) and it''s
> >> community of SQL Professionals.
> >>
> >>
> >> "Pasquale" wrote:
> >>
> >> > I need to create a report with some parameters for filtering data.
> >> > This report must be called by URL link on an Html page.
> >> > This link must contains the values of these parameters; I don' want
> >> > specify the values when I see the report by clicking on View report
> >> > button.
> >> > Is it possible? How?
> >> > What is the format of link for passing parameters to filter data?
> >> >
> >> > Many thanks
>
>|||Two different things. First is getting the parameters to work. Then making
them hidden. Do you have them working properly so you know your URL is
correct. Be sure that your parameter is with the correct case since RS is
case sensitive with parameters. Once you know your URL is correct because
your report works properly then you can deal with hidding the parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>I have executed several tries modifying the parameter settings.
> I have followed your suggests, but the solution isn't complete:
> or I see the parameter or I cannot modify the parameter
> that I pass via URL (an error occurs!!!)!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Read the rest of Wayne's post. He is telling you how to hide a parameter
>> so
>> the user doesn't see it.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >I tried passing parameters in URL address successfully,
>> > but I see some parameters that the user hasn't change!
>> > Moreover, if I change the parameter property "User request"
>> > by setting to false value, the call of report dumps!
>> >
>> > The issue is partially solved! I need to pass a parameter by Url
>> > and these parameters cannot change by a user.
>> >
>> > Can I solve this problem URGENTLY?
>> >
>> > Many thanks
>> >
>> >
>> > "Wayne Snyder" wrote:
>> >
>> >> 1. Try leaving the parameter Prompt blank... This should prevent the
>> >> parameter from displaying, (but you must provide a default value...)
>> >>
>> >> 2. Search for URL Access in Books on line and you will get an entire
>> >> list
>> >> of all of the things you can do via URL in reporting services.
>> >>
>> >> Hope this helps..
>> >> --
>> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> Mariner, Charlotte, NC
>> >>
>> >> I support the Professional Association for SQL Server ( PASS) and
>> >> it''s
>> >> community of SQL Professionals.
>> >>
>> >>
>> >> "Pasquale" wrote:
>> >>
>> >> > I need to create a report with some parameters for filtering data.
>> >> > This report must be called by URL link on an Html page.
>> >> > This link must contains the values of these parameters; I don' want
>> >> > specify the values when I see the report by clicking on View report
>> >> > button.
>> >> > Is it possible? How?
>> >> > What is the format of link for passing parameters to filter data?
>> >> >
>> >> > Many thanks
>>|||My issue has two aspects:
1. passing a parameter via URL to call my report filtering data by the
parameter;
2. hide or protect parameter inside report manager to avoid any user's
changes.
The first step is solved. The report is called correctly and I see the
correct value
of parameter (the same written in the URL). I have written correctly the
name of parameter.
Now, when I set user request for the parameter, inside report manager, to
false
in order to hide the parameter, this message error occurs:
"sReadOnlyReportParameter" and I cannot the value of parameter by the value
in the URL.
This strange behaviour represents a limit of RS!
Moreover, I have specified a default value of parameter with a particular
value.
Now, is it really possible to solve completely this issue?
Do I have a particular SP (SP1, SP2, ...)?
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||I have controlled all settings of the report; then I try to set to blank
the user request string inside report manager (maintaning a default
value for the parameter): so, I can modify the parameter by passing it
via URL and simultaneously hide it in order to avoid any user's changes.
Finally, the issue is solved!!!
Many thanks
"Bruce L-C [MVP]" wrote:
> Two different things. First is getting the parameters to work. Then making
> them hidden. Do you have them working properly so you know your URL is
> correct. Be sure that your parameter is with the correct case since RS is
> case sensitive with parameters. Once you know your URL is correct because
> your report works properly then you can deal with hidding the parameters.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
> >I have executed several tries modifying the parameter settings.
> > I have followed your suggests, but the solution isn't complete:
> > or I see the parameter or I cannot modify the parameter
> > that I pass via URL (an error occurs!!!)!
> >
> > Many thanks
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Read the rest of Wayne's post. He is telling you how to hide a parameter
> >> so
> >> the user doesn't see it.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
> >> >I tried passing parameters in URL address successfully,
> >> > but I see some parameters that the user hasn't change!
> >> > Moreover, if I change the parameter property "User request"
> >> > by setting to false value, the call of report dumps!
> >> >
> >> > The issue is partially solved! I need to pass a parameter by Url
> >> > and these parameters cannot change by a user.
> >> >
> >> > Can I solve this problem URGENTLY?
> >> >
> >> > Many thanks
> >> >
> >> >
> >> > "Wayne Snyder" wrote:
> >> >
> >> >> 1. Try leaving the parameter Prompt blank... This should prevent the
> >> >> parameter from displaying, (but you must provide a default value...)
> >> >>
> >> >> 2. Search for URL Access in Books on line and you will get an entire
> >> >> list
> >> >> of all of the things you can do via URL in reporting services.
> >> >>
> >> >> Hope this helps..
> >> >> --
> >> >> Wayne Snyder MCDBA, SQL Server MVP
> >> >> Mariner, Charlotte, NC
> >> >>
> >> >> I support the Professional Association for SQL Server ( PASS) and
> >> >> it''s
> >> >> community of SQL Professionals.
> >> >>
> >> >>
> >> >> "Pasquale" wrote:
> >> >>
> >> >> > I need to create a report with some parameters for filtering data.
> >> >> > This report must be called by URL link on an Html page.
> >> >> > This link must contains the values of these parameters; I don' want
> >> >> > specify the values when I see the report by clicking on View report
> >> >> > button.
> >> >> > Is it possible? How?
> >> >> > What is the format of link for passing parameters to filter data?
> >> >> >
> >> >> > Many thanks
> >>
> >>
> >>
>
>|||Making parameters hidden is much more straight forward in RS 2005. I don't
hide parameters so I have not had that issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:8DE20C29-CBB1-4020-93BD-6D8C71361AD2@.microsoft.com...
>I have controlled all settings of the report; then I try to set to blank
> the user request string inside report manager (maintaning a default
> value for the parameter): so, I can modify the parameter by passing it
> via URL and simultaneously hide it in order to avoid any user's changes.
> Finally, the issue is solved!!!
> Many thanks
>
> "Bruce L-C [MVP]" wrote:
>> Two different things. First is getting the parameters to work. Then
>> making
>> them hidden. Do you have them working properly so you know your URL is
>> correct. Be sure that your parameter is with the correct case since RS is
>> case sensitive with parameters. Once you know your URL is correct because
>> your report works properly then you can deal with hidding the parameters.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@.microsoft.com...
>> >I have executed several tries modifying the parameter settings.
>> > I have followed your suggests, but the solution isn't complete:
>> > or I see the parameter or I cannot modify the parameter
>> > that I pass via URL (an error occurs!!!)!
>> >
>> > Many thanks
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Read the rest of Wayne's post. He is telling you how to hide a
>> >> parameter
>> >> so
>> >> the user doesn't see it.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
>> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@.microsoft.com...
>> >> >I tried passing parameters in URL address successfully,
>> >> > but I see some parameters that the user hasn't change!
>> >> > Moreover, if I change the parameter property "User request"
>> >> > by setting to false value, the call of report dumps!
>> >> >
>> >> > The issue is partially solved! I need to pass a parameter by Url
>> >> > and these parameters cannot change by a user.
>> >> >
>> >> > Can I solve this problem URGENTLY?
>> >> >
>> >> > Many thanks
>> >> >
>> >> >
>> >> > "Wayne Snyder" wrote:
>> >> >
>> >> >> 1. Try leaving the parameter Prompt blank... This should prevent
>> >> >> the
>> >> >> parameter from displaying, (but you must provide a default
>> >> >> value...)
>> >> >>
>> >> >> 2. Search for URL Access in Books on line and you will get an
>> >> >> entire
>> >> >> list
>> >> >> of all of the things you can do via URL in reporting services.
>> >> >>
>> >> >> Hope this helps..
>> >> >> --
>> >> >> Wayne Snyder MCDBA, SQL Server MVP
>> >> >> Mariner, Charlotte, NC
>> >> >>
>> >> >> I support the Professional Association for SQL Server ( PASS) and
>> >> >> it''s
>> >> >> community of SQL Professionals.
>> >> >>
>> >> >>
>> >> >> "Pasquale" wrote:
>> >> >>
>> >> >> > I need to create a report with some parameters for filtering
>> >> >> > data.
>> >> >> > This report must be called by URL link on an Html page.
>> >> >> > This link must contains the values of these parameters; I don'
>> >> >> > want
>> >> >> > specify the values when I see the report by clicking on View
>> >> >> > report
>> >> >> > button.
>> >> >> > Is it possible? How?
>> >> >> > What is the format of link for passing parameters to filter data?
>> >> >> >
>> >> >> > Many thanks
>> >>
>> >>
>> >>
>>sql
Link Tables in SQL Server
Can I create Link Table in SQL Sever that links to a MS Access Table?You create a "Linked Server" to the Access database.
See Books OnLine under Linked Servers.|||You can use the OLEDB provider for Jet for MS Access database.
Link Tables in SQL Server
Can I create Link Table in SQL Sever that links to a MS Access Table?You create a "Linked Server" to the Access database.
See Books OnLine under Linked Servers.|||You can use the OLEDB provider for Jet for MS Access database.
Link tables in SQL databse
How to create links to other tables within SQL database?Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to do
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?sql
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to do
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?sql
Link tables in SQL databse
How to create links to other tables within SQL database?
Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?
|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to do
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?
Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?
|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to do
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?
Link tables in SQL databse
How to create links to other tables within SQL database?Can you define more clearly, Alan?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to d
o
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?
"Alan" <Alan@.discussions.microsoft.com> wrote in message
news:4BDE1092-1974-4958-990B-2FF2B8485DE2@.microsoft.com...
> How to create links to other tables within SQL database?|||If you want to query a table in another database, but on the same server, as
long as your login is a mapped user in the other database, all you need to d
o
is qualify the table in your FROM clause:
SELECT ...
FROM <database_name>.<owner>.<table_name|view_name>
WHERE ...
Now, if you want to query a database hosted by another server, you have
several optons:
OPENDATASOURCE
OPENRESULTSET
OPENQUERY
LINKED SERVER
Remember that these are not limited to just remote SQL Servers but any OLEDB
or ODBC compliant source where the drivers have been properly loaded on the
server in question.
Sincerely,
Anthony Thomas
"Alan" wrote:
> How to create links to other tables within SQL database?
Link Table
I am able to create a link table MS Access to an ODBC datasource using
USQL Transoft.
Is it possible to create the same 'link table' in SQL.
MS Access takes to long to run the query, but I can only see how to import
the data into SQL.
Many thanks
You may be able to use OpenRowSet and OpenDataSource. Read all about
it from the BOL.
Aramid
On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:
>I am able to create a link table MS Access to an ODBC datasource using
>USQL Transoft.
>Is it possible to create the same 'link table' in SQL.
>MS Access takes to long to run the query, but I can only see how to import
>the data into SQL.
>Many thanks
>
|||Hi Thanks aramid.
Whats BOL...sorry
"aramid" wrote:
> You may be able to use OpenRowSet and OpenDataSource. Read all about
> it from the BOL.
> Aramid
> On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
> <MMouse99@.discussions.microsoft.com> wrote:
>
>
USQL Transoft.
Is it possible to create the same 'link table' in SQL.
MS Access takes to long to run the query, but I can only see how to import
the data into SQL.
Many thanks
You may be able to use OpenRowSet and OpenDataSource. Read all about
it from the BOL.
Aramid
On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:
>I am able to create a link table MS Access to an ODBC datasource using
>USQL Transoft.
>Is it possible to create the same 'link table' in SQL.
>MS Access takes to long to run the query, but I can only see how to import
>the data into SQL.
>Many thanks
>
|||Hi Thanks aramid.
Whats BOL...sorry
"aramid" wrote:
> You may be able to use OpenRowSet and OpenDataSource. Read all about
> it from the BOL.
> Aramid
> On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
> <MMouse99@.discussions.microsoft.com> wrote:
>
>
Link Table
I am able to create a link table MS Access to an ODBC datasource using
USQL Transoft.
Is it possible to create the same 'link table' in SQL.
MS Access takes to long to run the query, but I can only see how to import
the data into SQL.
Many thanksYou may be able to use OpenRowSet and OpenDataSource. Read all about
it from the BOL.
Aramid
On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:
>I am able to create a link table MS Access to an ODBC datasource using
>USQL Transoft.
>Is it possible to create the same 'link table' in SQL.
>MS Access takes to long to run the query, but I can only see how to import
>the data into SQL.
>Many thanks
>|||Hi Thanks aramid.
Whats BOL...sorry
"aramid" wrote:
> You may be able to use OpenRowSet and OpenDataSource. Read all about
> it from the BOL.
> Aramid
> On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
> <MMouse99@.discussions.microsoft.com> wrote:
>
>
USQL Transoft.
Is it possible to create the same 'link table' in SQL.
MS Access takes to long to run the query, but I can only see how to import
the data into SQL.
Many thanksYou may be able to use OpenRowSet and OpenDataSource. Read all about
it from the BOL.
Aramid
On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:
>I am able to create a link table MS Access to an ODBC datasource using
>USQL Transoft.
>Is it possible to create the same 'link table' in SQL.
>MS Access takes to long to run the query, but I can only see how to import
>the data into SQL.
>Many thanks
>|||Hi Thanks aramid.
Whats BOL...sorry
"aramid" wrote:
> You may be able to use OpenRowSet and OpenDataSource. Read all about
> it from the BOL.
> Aramid
> On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
> <MMouse99@.discussions.microsoft.com> wrote:
>
>
Link Table
I am able to create a link table MS Access to an ODBC datasource using
USQL Transoft.
Is it possible to create the same 'link table' in SQL.
MS Access takes to long to run the query, but I can only see how to import
the data into SQL.
Many thanksYou may be able to use OpenRowSet and OpenDataSource. Read all about
it from the BOL.
Aramid
On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:
>I am able to create a link table MS Access to an ODBC datasource using
>USQL Transoft.
>Is it possible to create the same 'link table' in SQL.
>MS Access takes to long to run the query, but I can only see how to import
>the data into SQL.
>Many thanks
>|||Hi Thanks aramid.
Whats BOL...sorry
"aramid" wrote:
> You may be able to use OpenRowSet and OpenDataSource. Read all about
> it from the BOL.
> Aramid
> On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
> <MMouse99@.discussions.microsoft.com> wrote:
> >I am able to create a link table MS Access to an ODBC datasource using
> >USQL Transoft.
> >
> >Is it possible to create the same 'link table' in SQL.
> >
> >MS Access takes to long to run the query, but I can only see how to import
> >the data into SQL.
> >
> >Many thanks
> >
>sql
USQL Transoft.
Is it possible to create the same 'link table' in SQL.
MS Access takes to long to run the query, but I can only see how to import
the data into SQL.
Many thanksYou may be able to use OpenRowSet and OpenDataSource. Read all about
it from the BOL.
Aramid
On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
<MMouse99@.discussions.microsoft.com> wrote:
>I am able to create a link table MS Access to an ODBC datasource using
>USQL Transoft.
>Is it possible to create the same 'link table' in SQL.
>MS Access takes to long to run the query, but I can only see how to import
>the data into SQL.
>Many thanks
>|||Hi Thanks aramid.
Whats BOL...sorry
"aramid" wrote:
> You may be able to use OpenRowSet and OpenDataSource. Read all about
> it from the BOL.
> Aramid
> On Wed, 6 Apr 2005 05:53:03 -0700, "MMouse99"
> <MMouse99@.discussions.microsoft.com> wrote:
> >I am able to create a link table MS Access to an ODBC datasource using
> >USQL Transoft.
> >
> >Is it possible to create the same 'link table' in SQL.
> >
> >MS Access takes to long to run the query, but I can only see how to import
> >the data into SQL.
> >
> >Many thanks
> >
>sql
Monday, March 26, 2012
Link SQL Server 2005 Tables to external database through ODBC
Hi
I'm a newbie at SQL 2005 and I'm trying to create linked tables to our ERP system through ODBC. I can do this in MS Access or vb.net by using the ERP system's ODBC driver, but I am lost when it comes to SQL Server 2005.
Thanks for any help
Using a linked server, you will need to have either a OLEDB driver or a support for the OLEDB for ODBC provider. Using OPENDATASOURCE you will need to have the init string (connectionstring) for the database. You will find more information in the BOL under the topic OPENDATASOURCE.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Link SQL Server 2005 Tables to external database through ODBC
Hi
I'm a newbie at SQL 2005 and I'm trying to create linked tables to our ERP system through ODBC. I can do this in MS Access or vb.net by using the ERP system's ODBC driver, but I am lost when it comes to SQL Server 2005.
Thanks for any help
Using a linked server, you will need to have either a OLEDB driver or a support for the OLEDB for ODBC provider. Using OPENDATASOURCE you will need to have the init string (connectionstring) for the database. You will find more information in the BOL under the topic OPENDATASOURCE.
Jens K. Suessmeyer
http://www.sqlserver2005.de
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 Server settings
Hello:
I am trying to create linked server ( another SQL Server) to my SQL Server,
using Enterprise Manager, but new alias pointed me only to master database.
How can I change settings of the link server to get access to pubs database?
Thanks,
GBYou could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||You could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||What you see in Enterprise Manager is simply the default database for the
account that you are using to authenticate to the linked server. Changed th
e
default database for that user, and refresh and you will see another
databases tables.
You will still be able to access all databases to which that user has access
.
kevin
"GB" wrote:
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL Server
,
> using Enterprise Manager, but new alias pointed me only to master database
.
> How can I change settings of the link server to get access to pubs databas
e?
> Thanks,
> GB
>
>
I am trying to create linked server ( another SQL Server) to my SQL Server,
using Enterprise Manager, but new alias pointed me only to master database.
How can I change settings of the link server to get access to pubs database?
Thanks,
GBYou could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||You could change the default database for the user the linked server is
configured to use, using sp_defaultdb on the remote server.
Or, use the USE statement or proper 4-part naming to qualify the database
name you are accessing from the local server. e.g. you should not be saying
this:
SELECT <col_list> FROM LinkedServer...TableName;
You should be saying:
SELECT <col_list> FROM LinkedServer.DatabaseName.dbo.TableName;
"GB" <v7v1k3@.hotmail.com> wrote in message
news:y_zvf.57264$OU5.43252@.clgrps13...
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL
> Server,
> using Enterprise Manager, but new alias pointed me only to master
> database.
> How can I change settings of the link server to get access to pubs
> database?
> Thanks,
> GB
>|||What you see in Enterprise Manager is simply the default database for the
account that you are using to authenticate to the linked server. Changed th
e
default database for that user, and refresh and you will see another
databases tables.
You will still be able to access all databases to which that user has access
.
kevin
"GB" wrote:
> Hello:
> I am trying to create linked server ( another SQL Server) to my SQL Server
,
> using Enterprise Manager, but new alias pointed me only to master database
.
> How can I change settings of the link server to get access to pubs databas
e?
> Thanks,
> GB
>
>
Link Server questions
I create a link server from one SQL Server to another.
Why do I only see a couple of objects, mainly from one
database? I need to also see objects from other
databases. Please help.
TIA,
VicThe reason you only see a limited number of objects is because you connect
to the linked server using permissions granted to the user that is
connecting to the linked server and object in the default database for the
user.
Jim
"Vic" <vduran@.specpro-inc.com> wrote in message
news:05d701c3d568$2ed76910$a101280a@.phx.gbl...
> I create a link server from one SQL Server to another.
> Why do I only see a couple of objects, mainly from one
> database? I need to also see objects from other
> databases. Please help.
> TIA,
> Vic
Why do I only see a couple of objects, mainly from one
database? I need to also see objects from other
databases. Please help.
TIA,
VicThe reason you only see a limited number of objects is because you connect
to the linked server using permissions granted to the user that is
connecting to the linked server and object in the default database for the
user.
Jim
"Vic" <vduran@.specpro-inc.com> wrote in message
news:05d701c3d568$2ed76910$a101280a@.phx.gbl...
> I create a link server from one SQL Server to another.
> Why do I only see a couple of objects, mainly from one
> database? I need to also see objects from other
> databases. Please help.
> TIA,
> Vic
Subscribe to:
Posts (Atom)