How to pass parameters for OPENDATASOURCE

Posted by Rapunzo on Stack Overflow See other posts from Stack Overflow or by Rapunzo
Published on 2010-05-31T14:28:06Z Indexed on 2010/05/31 14:33 UTC
Read the original article Hit count: 201

Filed under:

linked-server

|

parameter-passing

I can connect to a linked server with this:

SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.150.42;User ID=readerUser;Password=1').akreditasyon.dbo.tblPerfCevap

But I have to pass the password as parameter. and I try like this:

SET @connectionString = 'Data Source=192.168.150.42;User ID=readerUser;Password='+@pw

SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo FROM OPENDATASOURCE('SQLOLEDB', @connectionString ).akreditasyon.dbo.tblPerfCevap

and

SELECT testNo, soruTuruId, soruNo, cevap , degerlendirenTcNo, degerlendirilenTcNo FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.150.42;User ID=readerUser;Password='+@pw ).akreditasyon.dbo.tblPerfCevap

but didnt work:S

does anyone have an idea?

© Stack Overflow or respective owner

Related posts about linked-server

Can we have Linked Servers when using NTLM?

as seen on Server Fault - Search for 'Server Fault'
I don't have access to the Active Directory settings, nor do I have access to change anything on the linked server. From everything I've read, it seems like this means I cannot use Kerberos - which is a big problem, because I don't know how to use a linked server without it. Is there any way to… >>> More
How do I create a Linked Server in SQL Server 2005 to a password protected Access 95 database?

as seen on Server Fault - Search for 'Server Fault'
I need to create a linked server with SQL Server Management Studio 2005 to an Access 95 database, which happens to be password protected at the database level. User level security has not been implemented. I cannot convert the Access database to a newer version. It is being used by a 3rd party… >>> More
How to Name Linked Servers

as seen on SQL Team - Search for 'SQL Team'
I did another SQL Server migration over the weekend that dealt with linked servers. I’ve seen all kinds of odd naming schemes and there are a few I like and a few I suggest you avoid. Don’t name your linked server for its IP address. At some point whatever is on the other end of that IP address… >>> More
Faster way to transfer table data from linked server

as seen on Stack Overflow - Search for 'Stack Overflow'
After much fiddling, I've managed to install the right ODBC driver and have successfully created a linked server on SQL Server 2008, by which I can access my PostgreSQL db from SQL server. I'm copying all of the data from some of the tables in the PgSQL DB into SQL Server using merge statements… >>> More
How to optimize simple linked server select query?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have a table called Table with columns: ID (int, primary key, clustered, unique index) TEXT (varchar 15) on a MSSQL linked server called LS. Linked server is on the same server computer. And: When I call: SELECT ID, TEXT FROM OPENQUERY(LS, 'SELECT ID, TEXT FROM Table') It takes… >>> More

Related posts about parameter-passing

BIEE Answer Parameter Passing

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A little off BIP topic today but I spent some time researching how to pass parameters between Answer reports and knocked up a document for a client this morning and thought, what the heck someone might find it useful. If you have a source Answer request and you want to link to another Answer in another… >>> More
Parameter passing become pointer for integer

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on a c/Linux app for a device. I consume a web service (in WCF/c#) and use gSOAP for the same. The issue is that the parameters in the service methods become pointers for simple data types like int, short etc also. I initially used the same service exposed as ASMX web service and the… >>> More
Actionscript multiple file upload, with parameter passing is not working

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey everyone, First off, I am very bad at flash/actionscript, it is not my main programming language. I have created my own file upload flash app that has been working great for me up until this point. It uses PHP to upload the files and sends back a status message which gets displayed in a status… >>> More
Autocomplete and Dynamic Parameter Passing

as seen on Stack Overflow - Search for 'Stack Overflow'
The code below works fine using jQuery UI 1.8 and jQuery 1.4.2 $("#sid_entry_box").autocomplete( {source:"autocomplete_sid.php?database="+database_name, minLength:4, delay:1000, enable:true, cacheLength:1 }); The database name is passed as a get parameter of the php call… >>> More
javascript parameter passing in dynamic action handler

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to create several Divs dynamically, and I need to add "onmouseover" event to them. However, the JAVASCRIPT "div.onmouseover = handler" can't pass in parameters. how can I pass parameters in those dynamic event handlers? >>> More