manualshive.com logo in svg

MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER, Руководство пользователя

Поделиться
Скачать
MACROMEDIA COLDFUSION 5 - INSTALING AND CONFIGURING SERVER Скачать руководство пользователя страница 121

Chapter 6

Managing Data Sources

ColdFusion allows you to rapidly develop dynamic Web applications—that is, 
applications that interact with databases. Before you can use a database in a 
ColdFusion application, you must register the data source in the ColdFusion 
Administrator. This chapter describes how to create and configure ColdFusion data 
sources for SQL Server, Access, and Oracle databases. For details on how to configure 
data sources for other databases, see Advanced ColdFusion Server Administration.

Contents

•

About ColdFusion Data Sources ............................................................................ 110

•

Supported Database Drivers .................................................................................. 111

•

Choosing the Correct Drivers................................................................................. 114

•

Adding Data Sources for ColdFusion..................................................................... 115

•

Verifying ColdFusion Data Sources ....................................................................... 120

•

Connecting to Microsoft SQL Server Databases................................................... 121

•

Connecting to Microsoft Access Databases .......................................................... 123

•

Connecting to Oracle Databases............................................................................ 127

install.book  Page 109  Thursday, May 10, 2001  12:59 PM

Содержание COLDFUSION 5 - INSTALING AND CONFIGURING SERVER

Страница 1: ...Macromedia Inc Installing and Configuring ColdFusion Server ColdFusion Server 5...

Страница 2: ...ation may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical recording or otherwise without the prior written permission of Macromedia Inc Cold...

Страница 3: ...ore You Begin the Installation 5 Required operating system updates 5 Installing SNMP in Windows NT 4 0 Server and Windows 2000 Server 6 Important Network Considerations 7 Upgrading from a previous ver...

Страница 4: ...rements 40 Before You Begin the Installation 41 Required operating system patches 41 Installing SNMP in Red Hat 41 Important Network Considerations 42 Upgrading from a previous version 43 Verifying th...

Страница 5: ...g Client Variable Data 74 Memory Variables 76 Locking 77 Single threaded sessions 77 Variable scope locking settings 77 Mappings 79 Mail Mail Logging 80 Data Sources 82 Verity Collections 83 Managing...

Страница 6: ...s for connecting to Microsoft Access Windows 124 Connecting to Remote Access Data Sources 125 Connecting to Oracle Databases 127 Configuring Oracle 7 3 4 8 0 x options Windows 127 Configuring Oracle 7...

Страница 7: ...nded for server administrators and anyone who is new to ColdFusion Server and needs to install and configure ColdFusion Server 5 Contents Intended Audience viii New Features viii Developer Resources x...

Страница 8: ...tandard SQL Server analysis and troublshooting Quickly detect and diagnose server errors with built in server reporting and the new Log File Analyzer Powerful business intelligence capabilities Charti...

Страница 9: ...alerts and recovery SNMP support Monitor ColdFusion applications from enterprise management systems Expanded integration Expanded Linux support Deploy on additional Linux distributions including SuSE...

Страница 10: ...Forum Access to experienced ColdFusion developers through participation in the Online Forums where you can post messages and read replies on many subjects relating to ColdFusion Installation Support...

Страница 11: ...com Book Description Installing and Configuring ColdFusion Server Describes system installation and basic configuration for Windows Solaris Linux and HP UX Advanced ColdFusion Administration Describes...

Страница 12: ...ms coldfusion com Other developers on the forum can help you figure out how to do just about anything with ColdFusion Server The search facility can also help you search messages from the previous 12...

Страница 13: ...support Macromedia offers a range of telephone and Web based support options Go to http www coldfusion com support for a complete description of technical support services You can make postings to the...

Страница 14: ...xiv Welcome to ColdFusion Server...

Страница 15: ...This chapter explains how to install and configure ColdFusion Server in Windows Contents Windows System Requirements 4 Before You Begin the Installation 5 Installing ColdFusion Server in Windows 10 Co...

Страница 16: ...6 512 Free Hard Disk Space MB 200 400 CD ROM Drive x x Web Servers Microsoft Personal Web Server PWS x Microsoft IIS 4 0 5 0 x x iPlanet Netscape Enterprise Server 3 6 4 1 x x Apache Server 1 3 x x x...

Страница 17: ...Service Pack 1 http www microsoft com downloads MDAC 2 5 SP1 http www microsoft com data downloads MFC MSVC 6 0 localdrive ColdFusion Image Redistrib MSVCRT setup exe NT Option Pack http www microsof...

Страница 18: ...nu select Settings Control Panel Network Service Tab Add SNMP Service 2 The installation begins When prompted insert your Windows installation CD ROM 3 Start the SNMP trap service Note If you chose to...

Страница 19: ...NT 4 0 Workstation or Windows 2000 Professional handle only ten TCP IP connections concurrently Macromedia does not recommend using those operating systems in a production environment Use Window NT 4...

Страница 20: ...eb server in your browser s Address field and press Enter For example if the file myindex htm is in your Web document root directory load the page in your browser using the localhost URL http 127 0 0...

Страница 21: ...letes restart your system To repair update ColdFusion Server Use the Repair update feature to reinstall a component of ColdFusion Server Repairing ColdFusion Server refreshes the Windows registry rese...

Страница 22: ...rmation dialog displays Enter your information including the ColdFusion Server license key You can find your ColdFusion Server license key on the product box and the CD ROM packaging The Web Server Se...

Страница 23: ...e cluster select Web Server IP Failover ClusterCATS and Application Management together The monitoring alarms and hardware load balancing features cannot be accessed using the ColdFusion Administrator...

Страница 24: ...ble click the service that you want to configure The window for that service opens 3 In the Startup Type frame select either the Automatic or Manual option 4 To save the configuration click OK SiteMin...

Страница 25: ...hat you want to configure and select Properties 2 In the Properties dialog select the General tab In the Startup Type drop down menu choose either Manual or Automatic 3 Click OK Running ColdFusion Ser...

Страница 26: ...b servers Internet Information Services IIS Apache Web server Netscape iPlanet Enterprise Web Server O Reilly WebSite Professional Internet Information Services IIS The following procedure uses Window...

Страница 27: ...ab under the Internet Information Services tree right click your Web site and select Properties The Properties dialog box displays 3 Click the Home Directory tab then Configuration Note If the Configu...

Страница 28: ...Click Browse and go to c cfusion bin iscf dll Enter cfm in the Extension text box and verify that the Script engine check box is selected Click OK 7 Repeat Step 6 substituting dbm for the extension No...

Страница 29: ...guring Netscape iPlanet Web servers for ColdFusion Server requires modifying two files obj conf and mime types in the Netscape iPlanet Web server directory such as c netscape server4 https yourserver...

Страница 30: ...WebSite Professional for ColdFusion Server 1 Select Start Programs WebSite Professional Server Properties The WebSite Pro Server Properties dialog box displays 2 In the Mapping tab click Associations...

Страница 31: ...s page of the ColdFusion Administrator and ensure that the Enable Performance Monitoring checkbox is selected Tip You can find a copy of the MIB definition in CFusion cfam Database lhmib mib Using HTT...

Страница 32: ...e Windows 2000 Professional operating system To change the ColdFusion Server user account 1 Start the MMC by selecting Start Programs Administrative Tools Computer Management a In the Tree tab expand...

Страница 33: ...g ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control console For more infor...

Страница 34: ...22 Chapter 1 Installing ColdFusion Server in Windows...

Страница 35: ...his chapter explains how to install and configure ColdFusion Server in Solaris Contents Solaris System Requirements 24 Before You Begin the Installation 25 Installing ColdFusion Server in Solaris 29 C...

Страница 36: ...nimum RAM MB 256 Recommended RAM MB 512 Free Hard Disk Space MB 350 CD ROM Drive x Web Server iPlanet Netscape Enterprise Server 3 6 4 1 x Apache Server 1 3 x x ColdFusion Server provides a precompile...

Страница 37: ...e sun com Operating System Patch Description Solaris 2 6 105181 17 or higher Kernel patch 105591 09 or higher LibC Shared library patch for C 105210 25 or higher LibC Shared library patch for C C 1055...

Страница 38: ...wnload 1 Uninstall the following components from your system pkgrm SUNWsacom pkgrm SUNWmibii pkgrm SUNWsadmi pkgrm SUNWsasnm 2 Install the SEA Runtime by performing the following steps a Uncompress th...

Страница 39: ...ldFusion Server automatically However keep in mind the following important instructions when upgrading from a previous release of ColdFusion Server If you are upgrading from ColdFusion Server 4 0 or e...

Страница 40: ...ument root directory load the page in your browser using the localhost URL http 127 0 0 1 myindex htm If your Web server is not running you will receive an error message Uninstalling ColdFusion Server...

Страница 41: ...sing the coldfusion 50 solaris tar gz command to a directory on your local disk Using gunzip uncompress the ColdFusion Server tar file with the following command coldfusion 50 solaris tar gz 3 Untar t...

Страница 42: ...tall ColdFusion Server documentation and examples The documentation is installed in the cfdocs directory under the Web root directory Warning Because of potential security concerns the ColdFusion Serv...

Страница 43: ...ing and stopping ColdFusion Server processes manually in Solaris opt coldfusion bin start opt coldfusion bin stop Process Purpose cfexec Starts stops the other processes and manages page scheduling cf...

Страница 44: ...s ColdFusion Server also provides the following scripts to start and stop ColdFusion Server during system startup and shutdown Script Function etc init d coldfusion Starts or stops ColdFusion Server e...

Страница 45: ...The Netscape iPlanet plug in coldfusion35 so for ColdFusion Server is in the opt coldfusion webserver nsapi directory The following procedure assumes that you installed the Netscape iPlanet server in...

Страница 46: ...Apache 1 3 x versions and it may not work with later versions if Apache Group changes MODULE_MAGIC_NUMBER_MAJOR src src include ap_mmn h in the Apache source The module provided with ColdFusion Server...

Страница 47: ...tory in the ColdFusion Server installation cd opt coldfusion webserver apache src 5 Run the apxs command to build mod_coldfusion so by entering this command make 6 Run the apxs command to add the modu...

Страница 48: ...names are invalid the MIB does not work correctly and the MIB log file grows very large Do not delete or comment out the trap section of allaire_mib acl 3 Restart the SNMP process by entering the fol...

Страница 49: ...client side database libraries to your LD_LIBRARY_PATH environment variable Examples are provided in the start script to help you After editing the start script you must stop and restart ColdFusion Se...

Страница 50: ...t After installing ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control conso...

Страница 51: ...This chapter explains how to install and configure ColdFusion Server in Linux Contents Linux System Requirements 40 Before You Begin the Installation 41 Installing ColdFusion Server in Linux 44 Confi...

Страница 52: ...anet Netscape Enterprise Server 4 1 x x Apache Server 13 6 x x All Linux distributions must be running glibc 2 1 3 11 or later gcc egcs libstdc 2 9 and 2 2 kernel or later For performance reasons the...

Страница 53: ...hird party system management tools These tools let you manage diverse components of your enterprise from a management station in your network If you want to use ColdFusion Server MIB features you must...

Страница 54: ...mpd conf_macromedia into snmpd conf to make ColdFusion MIB information accessible After finishing the ColdFusion Server installation you must configure your system to use MIB features For more informa...

Страница 55: ...g ColdFusion Server 5 these libraries are removed from your system Copy the libraries to a safe location before the uninstall Warning Before proceeding with the upgrade backup your ColdFusion Server W...

Страница 56: ...cd command go to the resulting directory 5 cd coldfusion 50 linux 6 Run the ColdFusion Server installation script by entering the following command cfinstall The ColdFusion Server installation script...

Страница 57: ...or this option provides ColdFusion application reporting statistics and the ability to archive and deploy ColdFusion applications Monitors Alarms and Load Balancer Integration Accessed through the Col...

Страница 58: ...ion bin cfam stop Note To run the scripts you must be logged in with root privileges Process Purpose cfexec Starts and stops the other processes and manages page scheduling cfserver The main ColdFusio...

Страница 59: ...usion Starts and stops ColdFusion Server etc rc1 d K19coldfusion Stops ColdFusion Server during system shutdown etc rc3 d S90coldfusion Starts ColdFusion Server during system startup etc rc4 d S90cold...

Страница 60: ...iPlanet plug ins for ColdFusion Server are installed in the installdir coldfusion webserver nsapi directory The following procedure assumes that you installed the Netscape iPlanet server in usr netsc...

Страница 61: ...e the Apache Readme file at opt coldfusion webserver apache readme Follow the appropriate procedure according to your Linux distribution to configure Red Hat and Apache and SuSE Cobalt with Apache To...

Страница 62: ..._static c AddModule mod_vhost_alias c AddModule mod_so c AddModule mod_setenvif c AddModule mod_coldfusion c c Save the file 4 Create a symbolic link from the EAPI version of the ColdFusion Server mod...

Страница 63: ...Go to the Debug Options page of the ColdFusion Administrator and ensure Enable Performance Monitoring is selected 4 Start the SNMP Server enter the following command as root etc rc d init d snmpd star...

Страница 64: ...e changes to take effect Then you can proceed to the ColdFusion Administrator to set up your data sources Note For more information see Managing Data Sources on page 109 In Linux you must use certain...

Страница 65: ...g ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control console For more infor...

Страница 66: ...54 Chapter 3 Installing ColdFusion Server in Linux...

Страница 67: ...This chapter explains how to install and configure ColdFusion Server in HP UX Contents HP UX System Requirements 56 Before You Begin the Installation 57 Installing ColdFusion Server in HP UX 60 Confi...

Страница 68: ...inimum RAM 128 MB Recommended RAM 128 MB Free Hard Disk Space 120 MB CD ROM Drive x Web Server iPlanet Netscape Enterprise Server 3 51 4 1 x Apache Server 1 3 x x ColdFusion Server provides a precompi...

Страница 69: ...figuration file locations They will be needed during the installation Note the HP UX username under which ColdFusion Server will run It will be needed during the installation Note where you want to in...

Страница 70: ...is written to the CD ROM using the RockRidge format This format is supported by HP UX using the Portable File System PFS commands not the standard HP UX mount umount commands For more information on t...

Страница 71: ...t it using the following command usr sbin pfs_umount SD_CDROM Uninstalling ColdFusion Server 5 Use the cfremove utility to remove an installed version of ColdFusion Server To uninstall ColdFusion Serv...

Страница 72: ...l 5 When prompted enter the ColdFusion Server registration ID license key Note You can find your ColdFusion Server license key on the product box and the CD ROM packaging 6 After entering the install...

Страница 73: ...script for configuring the Apache Web server or see Configuring Web servers manually on page 62 ColdFusion Server processes The ColdFusion Server installation creates the following processes in HP UX...

Страница 74: ...ns for ColdFusion Server are installed in the opt coldfusion webserver nsapi directory The following procedure assumes that you installed the Netscape iPlanet server in usr netscape server4 on the sys...

Страница 75: ...rsion of Apache is built with EAPI run the following command httpd V If the output contains the line D EAPI you are running an EAPI version of Apache 3 ColdFusion Server includes a version of the Cold...

Страница 76: ...API sl b In the section AddModule add the following line AddModule mod_coldfusion c c Save the file 8 Restart Apache Configuring databases After the install is completed but before you can set up a da...

Страница 77: ...nformix 7and 9 Yes Tested Informix 9 and with 2 40 client Clientless driver available for Informix9 Yes Tested Informix 9 and with 2 40 client Cannot be used simultaneously with ODBC connections IBM D...

Страница 78: ...After installing ColdFusion Server and configuring your installation you must perform some initial administration tasks using the ColdFusion Administrator ColdFusion Server s Web based control consol...

Страница 79: ...inistration tasks Contents Initial Administration Tasks 68 The ColdFusion Administrator 69 Server Settings 70 Caching 71 Client Variables 72 Memory Variables 76 Locking 77 Mappings 79 Mail Mail Loggin...

Страница 80: ...rmation use the Debug Settings pages of the Administrator For more information see Debug Settings on page 88 Set up e mail E mail lets ColdFusion Server and ColdFusion applications send automated mail...

Страница 81: ...n Server 5 ColdFusion Administrator or In any operating system open the administrator by entering http hostname CFIDE administrator index cfm in a Web browser where hostname is the name of the server...

Страница 82: ...unresponsive requests at which the service is restarted The service restarts within the time specified in Timeout Request above Restart when requests terminate abnormally Enable this option if you wan...

Страница 83: ...ched database connection inactive time to n minutes Enable this option by entering a value to limit the time that ColdFusion Server allows a cached database connection to remain inactive before discon...

Страница 84: ...dvantage Disadvantage System registry Simple implementation Good performance Registry can be exported easily to other systems Server side control Possible restriction of the registry s maximum size li...

Страница 85: ...following table If you do not want to make changes return to the Client Variables screen using one of the arrows on the page 4 Click Submit Changes Option Description Purge data for clients that rema...

Страница 86: ...les Creating client variable tables Use this example ColdFusion page as a model for creating client variable database tables in your own database However keep in mind that not all databases support th...

Страница 87: ...CDATA cfid app CFQUERY CFQUERY NAME global1 DATASOURCE DSN CREATE TABLE CGLOBAL cfid char 20 data memo lvisit date CFQUERY CFQUERY NAME global2 DATASOURCE DSN CREATE INDEX id2 ON CGLOBAL cfid CFQUERY...

Страница 88: ...able in the Memory Variables page you cannot use them in a ColdFusion application You can specify maximum and default timeout values for session and application variables Unless you define a timeout v...

Страница 89: ...s is enabled in the Administrator you do not need to the use the cflock tag for session scope variables In addition single threaded sessions can prove valuable to debugging a ColdFusion application If...

Страница 90: ...e attribute of the cflock tag to specify locks If you specify the name attribute with full checking enabled ColdFusion Server responds with an error on a variable accessed within the scope of a cflock...

Страница 91: ...ore in your cfinclude and cfmodule tags In order for ColdFusion Server to find those pages you must add a mapping for store that points to e store To add a mapping 1 In the Logical Path text box enter...

Страница 92: ...ColdFusion Applications book To configure a mail server 1 On the ColdFusion Administrator Mail page enter a mail server for sending dynamic SMTP mail messages You can enter an Internet address such a...

Страница 93: ...ble describes the e mail log files Setting Description Error Log Severity From the drop down list box select the type of SMTP related error message to write to a log file The options are Warning Infor...

Страница 94: ...tion see Managing Data Sources on page 109 Create and manage native data sources The Native Data Sources page lets you establish modify and delete native data source connections for ColdFusion Server...

Страница 95: ...st of multiple words and spaces 2 In the Path field specify a path for the collection files 3 From the drop down Language list box select a language for the collection 4 Click an option 5 Click Submit...

Страница 96: ...corresponding Verity Language Pack The Verity Language Packs are included on the ColdFusion Server CD ROM 8 Click Submit Changes ColdFusion Server populates the collection with data from the specified...

Страница 97: ...Verity Collections table 2 Click Optimize A message prompts you to verify the process which can occur over several minutes 3 Click OK When the optimization is complete a confirmation statement display...

Страница 98: ...Document Type Format or Program Version Text HTML CFML DBM SGML XML ANSI ASCII Plain Text Not applicable Word processing Adobe Acrobat PDF All Applix Words 4 2 Lotus AMI Pro 2 3 Lotus AMI Pro Write P...

Страница 99: ...Verity Collections 87 Presentation Corel Presentations 7 0 8 0 Lotus Freelance 96 97 Microsoft PowerPoint 4 0 95 97 2000 Document Type Format or Program Version Not Supported in Linux...

Страница 100: ...ms that do not support the NT Performance Monitor a command line utility cfstat displays the same information Enable CFML Stack Trace Displays the CFML tags that were executing at the time of the exce...

Страница 101: ...and debugging options are active debug output displays for all users To allow debug output to an IP address 1 On the Debugging IPs page enter an IP address Click Add 2 To add the IP address of the co...

Страница 102: ...onthly You can run a scheduled task daily at a specified interval or between specified dates You create scheduled tasks and set automation options on these pages On the Automation Settings page you se...

Страница 103: ...For the task to execute successfully the date and time must be set at least 15 minutes in the future Recurring Runs the scheduled task according to the frequency specified in the drop down list You c...

Страница 104: ...e scheduled task 2 A verification message warns you that deleting the task cannot be undone Click Yes The scheduled task disappears Setting Description Username Specifies whether the server to which t...

Страница 105: ...is Linux and HP UX Initial Heap Size JVM initial heap memory size Max Heap Size JVM maximum heap memory size Load JVM When Starting ColdFusion Loads the JVM when ColdFusion Server starts up If not sel...

Страница 106: ...subclass Must be relative to the code base URL The class extension is optional Code Base Base URL of the applet directory that contains the applet components The applet class files must be located wit...

Страница 107: ...er and manage ColdFusion custom tags built with C and Java You build CFX tags Using C as a dynamic link library DLL in Windows as shared objects so sl on Solaris Linux and HP UX Using Java interfaces...

Страница 108: ...FX Tags page To delete a CFX tag registration In the Registered CFX Tags table click the Delete Applet icon in the Controls column of the row for the CFX tag you want to delete The CFX tag disappears...

Страница 109: ...ter CORBA connectors before using them in your ColdFusion applications ColdFusion Server loads Orb libraries dynamically using a connector which does not tie ColdFusion customers to a specific Orb ven...

Страница 110: ...ect the Load ORB on Startup check box Click Submit CORBA Settings To modify a CORBA connector registration 1 In the Registered CORBA Connectors table on the CORBA Connections page click a CORBA Connec...

Страница 111: ...Security it requires custom development For more information see Basic Security on page 100 For more information about implementing security measures in your ColdFusion applications see Developing Co...

Страница 112: ...3 Click Submit Changes Tag Restrictions You use the Tag Restrictions page of the Administrator to enable and disable tags and tag attributes and to specify a directory where tag restrictions are not...

Страница 113: ...d access to server resources within ColdFusion Studio using Remote Development Services RDS and to change the password Warning Enabling Use ColdFusion Studio Authentication in the Advanced Security pa...

Страница 114: ...The site archiving features let you easily back up and deploy site configuration information files and or applications For more information see the Advanced ColdFusion Administration book Monitor reso...

Страница 115: ...message for reporting purposes enabling users to report problems This setting can be overridden in the Application cfm file Log Directory Directory to which error log files are written Log Slow Pages...

Страница 116: ...Files table click the View Search Log File icon The Log Viewer displays In the Log Viewer page the log file displays You can filter the log by keyword severity application thread ID and time frame or...

Страница 117: ...ing in the ColdFusion Remote Development Services RDS This service provides remote HTTP based access to files and databases application log Records every ColdFusion Server error reported to a user App...

Страница 118: ...ages related to the security server proxy cfadmin log Records Administrator operations install log Records installation information server stdout Records the standard output of the cfserver process rd...

Страница 119: ...n Progress Timed Out Requests Throughput Settings Summary Settings Change Log When you click on a report the right pane of the Server Reports page displays your choices The Settings Summary and Settin...

Страница 120: ...lists the options Click Update to apply your changes Parameter Option Timeframe Anytime Specified Range used in conjunction with Dates option Today Last Two Days Last Three Days One Week Two Weeks One...

Страница 121: ...e and configure ColdFusion data sources for SQL Server Access and Oracle databases For details on how to configure data sources for other databases see Advanced ColdFusion Server Administration Conten...

Страница 122: ...dFusion Administrator Note On the Win32 platform you can also configure ODBC data sources with the ODBC Data Source Administrator The specific databases that you can configure for ColdFusion depend on...

Страница 123: ...ASE FoxPro DataDirect Connect ODBC MERANT 3 7 P P P E E IBM DB2 UDBc DataDirect Connect ODBC MERANT 3 7 E E E E Informix 7 x 9 xd DataDirect Connect ODBC MERANT 3 7 E E E E Informix Dynamic Server for...

Страница 124: ...x 6 2 and 7 0 SuSE Linux 7 0 Cobalt RAQ3 XTR and RAQ4 Linux b P ColdFusion Professional Edition E ColdFusion Enterprise Edition c DB2 for Windows NT and DB2 Common Server requires either IBM DB2 Clien...

Страница 125: ...to connect to other databases see Advanced ColdFusion Server Administration The following sections apply to all databases and operating systems Section and location Description Choosing the Correct D...

Страница 126: ...32 platforms The main role of the odbc ini file is to map a data source name DSN to a particular ODBC driver and options For detailed information about options specific to your ODBC drivers see the do...

Страница 127: ...data source to ColdFusion 1 Open the ColdFusion Administrator 2 Under Data Sources click a link to specify a type of data source to add ODBC OLE DB available only on Windows NT 2000 Native The Data So...

Страница 128: ...a source The information that you enter depends on the platform on which you installed ColdFusion and on the driver you specify For information about options for your driver see the section for your s...

Страница 129: ...ck Create to create the data source ColdFusion automatically verifies that it can connect to the data source If ColdFusion cannot verify the data source the Status displays Failed You can run a cfquer...

Страница 130: ...number of simultaneous connections to allow for the current data source Note If you enable Limit Connections without specifying a limit for simultaneous connections ColdFusion defaults to unlimited co...

Страница 131: ...the columns in your select statement with the long text fields referenced last ColdFusion retrieves the column with the long text field and subsequent columns in the select statement as unbound data...

Страница 132: ...ne a username and password for a data source edit the properties for the data source To verify a ColdFusion data source 1 Open the ColdFusion Administrator 2 Under Data Sources click the link that spe...

Страница 133: ...to use If the SQL Server database is local and you are using the Microsoft SQL Server driver enclose the word local in parentheses local Use Trusted Connection Allows SQL Server to authenticate users...

Страница 134: ...options when you configure a ColdFusion data source Option Description Data Source Name A name for your ODBC data source Description Descriptive information about the data source Database Name The nam...

Страница 135: ...on about using OLE DB drivers with ColdFusion data sources see Advanced ColdFusion Server Administration Note OLE DB and ODBC connections to Access function identically at the programmatic level but O...

Страница 136: ...bat file If you receive an Operation must use an updateable query error message when you attempt to run a ColdFusion template that updates or deletes from an Access database see Knowledge Base Article...

Страница 137: ...a Domain User Account that has permission to run ColdFusion and has permission to read and write to the mdb file The following steps describe how you can set up ColdFusion to access the remote data s...

Страница 138: ...data source pointing to the remote database In the Database File field of the Create Data Source page type do not browse to the name of your database in Universal Naming Convention UNC format Note The...

Страница 139: ...a Solaris server you can configure an Oracle data source using a native driver Native drivers Oracle 7 3 4 and 8 0 x options UNIX The following table describes ColdFusion native driver options for Or...

Страница 140: ...uses If the libclntsh so file was built in the CFHOME lib using a script that you downloaded from http www coldfusion com the LD_LIBRARY_PATH variable should contain an entry for CFHOME lib before the...

Страница 141: ...cle7 Set library search path NOTE Add your database client library directory to the FRONT of this list Example LD_LIBRARY_PATH ORACLE_HOME lib SYBASE lib usr dt lib lib usr openwin lib CFHOME lib This...

Страница 142: ...onfig is correct but the connection test fails then seek assistance from your Oracle 8 database administrator DBA You should first check the basic connection information hostname SID username and pass...

Страница 143: ...environment The error occurred while processing an element with a general identifier of cfquery occupying document position 3 1 to 3 50 This problem might occur with the Oracle 7 3 4 native driver in...

Страница 144: ...ORACLE_HOME The library path set in LD_LIBRARY_PATH To install the Oracle 8 Client 1 Install the Oracle 8 Client software 2 Select the Database Administrator or Application User option This example us...

Страница 145: ...racle 8 database resides The following figure shows the default for the port number 5 After entering a host name enter the Database SID which identifies your specific Oracle database instance The defa...

Страница 146: ...nt ones for a successful connection Host string Enter the exact database alias that you created using the Oracle Net8 Easy Config utility ColdFusion Login username and password These options display w...

Страница 147: ...tware based load balancing features included with ColdFusion Server 5 Enterprise Edition Read the following sections to learn more about preparing your server for clustering and post installation task...

Страница 148: ...uration Protocol DHCP You must assign a unique IP address to each Web server Understanding DNS servers When you enter a URL into a Web browser the browser can locate the Web site that you want to visi...

Страница 149: ...ation from the local DNS server s table However if a user enters a URL for a site that the browser on that computer has never visited the local DNS server must access the primary DNS server on the Int...

Страница 150: ...usterCATS load management and failover features automatically take over and ensure that your Web applications remain up and running Using ClusterCATS with round robin DNS For high volume sites you sho...

Страница 151: ...ding or receiving packets from the network another member assumes its IP address and therefore its HTTP requests and picks up all HTTP traffic originally addressed to the failed server Server failover...

Страница 152: ...me as the IP of your Web server setting up your site for ClusterCATS dynamic IP addressing can involve reinstalling your Web server software and resetting your TCP IP settings You must carefully consi...

Страница 153: ...work protocols and click OK 6 Close the Network dialog box Windows NT prompts you to restart your computer Click No You restart your system at the end of this procedure 7 Open the Devices icon in the...

Страница 154: ...e certain that the addresses you are translating which should correspond to the outside DNS but not the round robin entries contain forward and reverse DNS entries corresponding to FQHN Modify the DNS...

Страница 155: ...either server with a Web browser Hit the round robin name and test its ability to serve Note If you are using static IP addresses with ClusterCATS fail over the failing server encounters an IP conflic...

Страница 156: ...ewall with a direct connection to the Internet You must open and configure the appropriate communication ports on your firewalls to allow server to server communication in a distributed setting and se...

Страница 157: ...for each Web server in the cluster should be the same on all cluster members for example set the default document to default jsp Considering domain controllers Windows NT only If you are using Window...

Страница 158: ...threshold no new sessions can start on that server If another server in the cluster has the capacity to handle additional users requests are redirected to that server The load management activation t...

Страница 159: ...Explorer pages For more information see Advanced ColdFusion Administration Administrative authentication Password protect administrative access to your cluster members using domain accounts Windows NT...

Страница 160: ...148 Appendix Preparing Your Server for ClusterCATS...

Отзывы:

Нет отзывов

Бренды по названию

Популярные бренды

Загрузить еще бренды