[thelist] SQL Server and Cold Fusion (fwd)

[Joshua OIson]

You should be able to do something like that was remote ODBC connections.
We did it with a Sybase database.  I don't know all the particulars, but
basically what will need to happen is that you will need to install a client
driver on the machine that has the CF which will make remote connections to
the machine with the database.

I run an NT box, and the process is kinda simple for the Sybase Stuff I use.
I create an ODBC connection with the Sybase Driver, and set it up to read
from the network instead of a local database on the Network Tab in the
administrator.  I select the Protocol (TCP/IP) and tell it
"host=xxx.xxx.xxx.xxx".  I setup the login account, the server name, and
bingo it is ready to go.  The process may be very similar to that for MSSQL.

Once you get an ODBC driver that reference the remote datasource the rest
should be very typical to setting up a local datasource within Cold Fusion
Administrator.

However, if you are looking to get into it from a *nix box.... hmm, dunno.
Sorry!  :)

HTH,

-joshua

: Date: Sat, 2 Jun 2001 11:32:27 -0700 (PDT)
: From: Josh Spiegel <joshsquared at yahoo.com>
: To: thelist-admin at lists.evolt.org
: Subject: SQL Server and Cold Fusion
:
: Hi,
: 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?
: Thanks,
: Josh