[thelist] SQL Server and Cold Fusion (fwd)

[Michael Roberto]

>Does anybody know if there is a way to have your cold
>fusion server running on one machine and your sql
>server running on another machine and still have them
>able to talk to each other? 

You bet!  First, I'm going to make the assumption that both machines are
Windows(NT/2000) but even if they're not, this is how the setup works.

On your web server(Running Cold Fusion) in the CF Administrator control
panel, when you add your ODBC or OLE DB datasource you will need to tell
CF what type of database you're connecting to and where that datasource
is located.  

So, you'll specify the datasource name you want to use for the datasource
in the text box and select MS SQL Server Driver from the dropdown.  And
add it.  Next you'll add the specifics.  

If both servers are windows machines, the "Server" text box can be filled
in with a Windows machine name(If they're on the same network), or(For a
non-windows webserver, or machines on different networks) it can be the 
IP address of the machine.  You'll enter the login info for the DB server
and whatever other preferences you need for the DB.

Because Cold Fusion knows what port to use, when accessing a SQL 
Server(1433), as long as the webserver knows how to connect with the SQL
server(Name or IP) the machines will be able to talk balk and forth, 
sending and receiving the data they need.

Hope that helps...

mike.

Michael Roberto
< LinkZero >
<e> mjr at linkzero.com
<w> www.linkzero.com