Ask a Question related to Coldfusion Database Access, Design and Development.
-
cfpaez #1
DataSource Linked Servers
How can i create a datasource from a linked server in SQL Server
cfpaez Guest
-
Frontend Web Servers connect to Coldfusion Servers
I need some help getting a front end web server cluster (iis) talking with the backend colfusion app cluster (j2ee install). Do I have to install... -
Join a query datasource and oledb datasource?
Using CF5 here. I have a query that I'm creating on the fly using the QueryNew() and QueryAddRow() functions. Then I run my query using... -
Mac OSX servers?
Is this a longshot here? has there ever been any thought from Macromedia to develope Flash Communication Server to run from a Mac xServer - or am I... -
Update one datasource using a 2nd datasource?
I have a CF app using an Access 2000 DB, Treasury. One of the tables holds user data (i.e. location, city, state, supervisor, etc.). This data is... -
statically linked tcl conflict with dynamically linked tcl error
My solaris 8 computer have a dynamically linked tclsh as the default. After another statically linked tclsh is executed, the computer environment... -
cfpaez #2 datasource linked servers
How can i create a datasource from a linked server in SQL Server
cfpaez Guest
-
philh #3 Re: DataSource Linked Servers
The linked server can be accessed through a four-part naming convention or an OPENQUERY statement. Just create the datasource to link to the parent SQL instance.
philh Guest
-
jeffcg2 #4 Re: datasource linked servers
Guessing you have you have a datasource setup on one sql server and you are
trying to connect to another sql server as a linked server. One way would be to
setup a datasource on the first sql server. Then write the query like:
<cfquery name="qry" datasource="firstserverdatasource">
select * from openquery(linkedservername,'select * from linkedservertable')
</cfquery>
I didn't try this but it should work.
jeffcg2 Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
