External Data Sources

[coldfused]

How would I go about connecting to a database hosted on one server, from another.

<cfquery datasource"what does the connection look like?">

I need to pull data from a mySQL databased stored on another server.

Any help is appreciated.

----------------------------------------
Online Marketing - de·ci·phered
Always Learning...

 

[coldfused]

Nevermind guys that was a stupid question. I just realized how simple it was after I posted.

For those who would ever need this it as simple as creating the datasource in the Coldfusion administrator and pointing it to the appropriate server and port.

Sorry guys for wasted thread.

Carl



----------------------------------------
Online Marketing - de·ci·phered
Always Learning...