Adobe 38000827 Administration Guide - Page 43

Data source names should be all one word., When adding data sources to ColdFusion MX

Get Adobe 38000827 - Macromedia ColdFusion MX Standard Edition PDF manuals and user guides
UPC - 718659577186
View all Adobe 38000827 manuals
Add to My Manuals
Save this manual to your list of manuals

Page 43 highlights

11 (Optional) To verify this data source later, click the verify icon: Note: To check the status of all data sources available to ColdFusion, click Verify All Connections. Specifying connection string arguments You can use the ColdFusion Administrator to specify connection string arguments for data sources that use the Microsoft Access,ODBC Socket, MYSQL, or DB2 drivers. In the Advanced Settings page for one of these drivers, enter name=value pairs separated by a semicolon in the Connection String field. The following figure shows how to specify the application name and workstation ID for an ODBC Socket connection to SQL Server: The Administrator configures the following ODBC connection string: DSN=odbcdsnname;APP=RaiseGenerator;WSID=TWriter01 In the preceding string, odbcdsnname is the name of the ODBC DSN. This is the string that the Microsoft Access or ODBC Socket driver uses to connect to the data source at runtime. Note: The connectstring tag attribute is not supported in ColdFusion MX. Adding data source notes and considerations When adding data sources to ColdFusion MX, keep these guidelines in mind: • Data source names should be all one word. • Data source names can contain only letters, numbers, and the underscore. • Data source names should not contain special characters. • Although data source names are not case-sensitive, you should use a consistent capitalization scheme. A data source must exist in the ColdFusion Administrator before you use it on an application page to retrieve data. Adding data sources 35

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
Adding data sources
35
11
(Optional) To verify this data source later, click the verify icon:
Note:
To check the status of all data sources available to ColdFusion, click Verify All
Connections.
Specifying connection string arguments
You can use the ColdFusion Administrator to specify connection string arguments for
data sources that use the Microsoft Access,ODBC Socket, MYSQL, or DB2 drivers. In
the Advanced Settings page for one of these drivers, enter name=value pairs separated by
a semicolon in the Connection String field. The following figure shows how to specify
the application name and workstation ID for an ODBC Socket connection to SQL
Server:
The Administrator configures the following ODBC connection string:
DSN=odbcdsnname;APP=RaiseGenerator;WSID=TWriter01
In the preceding string,
odbcdsnname
is the name of the ODBC DSN. This is the string
that the Microsoft Access or ODBC Socket driver uses to connect to the data source at
runtime.
Note:
The
connectstring
tag attribute is not supported in ColdFusion MX.
Adding data source notes and considerations
When adding data sources to ColdFusion MX, keep these guidelines in mind:
•
Data source names should be all one word.
•
Data source names can contain only letters, numbers, and the underscore.
•
Data source names should not contain special characters.
•
Although data source names are not case-sensitive, you should use a consistent
capitalization scheme.
A data source must exist in the ColdFusion Administrator before you use it on an
application page to retrieve data.