Skip to main content
Participant
December 28, 2007
Question

Reading Datasource on another computer

  • December 28, 2007
  • 1 reply
  • 272 views
Is it possible for CF to read the database that sits on another computer within the same domain? How would the coding be for this?
This topic has been closed for replies.

1 reply

Inspiring
December 28, 2007
quote:

Originally posted by: fusor
Is it possible for CF to read the database that sits on another computer within the same domain? How would the coding be for this?


Yes. For a DBMS such as MS SQL Server or DB2 configure provide data for the Server text when adding your data source in the CFIDE administrator.

I'm not sure for file based databases such as MS Access. I assume you would provide a network path to the location of the file and the account running the ColdFusion service would need access to this location.

fusorAuthor
Participant
December 28, 2007
Could this also be configured in the "other" datasources in CF Admin?
Inspiring
December 28, 2007
quote:

Originally posted by: fusor
Could this also be configured in the "other" datasources in CF Admin?


You would use "other" datasource if you need to use a JDBC driver not provided out of the box.
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_01.html#1235436