Connect to database on different website

[hpvic03]

Hello all,

I'm trying to write a script that can sync my database on my website with one hosted on another server. I have all the necessary login information for both databases and severs, but what is the method I would use to connect and do queries on the outside database?

Thanks in advance for your help!

 

[FALCONSEYE]

First, you would go to the cf admin and create the datasource for the other server,

Then

i would define a variable in application.cfm

<cfset application.secondDB = 'blahDB'>

Finally,

<cfquery ..... datasource="#application.secondDB#">
....
</cfquery>

hope it helps

http://www.fuzzysiberians.com