Loading in 2 Seconds...
Loading in 2 Seconds...
64-bit Cold Fusion 9 and MS Access: problems and possible solutions . Simon Kingston Russ DenBleyker. Agenda. Introduce Main Problem and Solution Introduce Secondary Problem and Solution Tips on using ColdFusion with SQL Server. The Main Problem.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Introduce Main Problem and Solution
Introduce Secondary Problem and Solution
Tips on using ColdFusion with SQL Server
Sometime this year, I&M Websites are moving to 64-bit servers running 64-bit ColdFusion 9 (CF9)
64-bit CF9 doesn’t natively support MS Access as a data source
Therefore, I&M websites that are currently running CF with MS Access data sources will need to be updated to use a supported data source
Deliver MS Access databases to NRPC
Convert MS Access Databases to SQL Server
Create a new CF9 Data Source using the SQL Server database
Update CF to work with SQL Server data source
The current CF app. publication model is as follows
Create MS Access (or other) CF Data Source locally
Build CF app. locally using the Data Source
Send in database to NRSS Ft. Collins IT Team
Wait for IT team to create CF Data Source
Post CF code to production server
Post CF code to DEV server and get CF working
Move CF code to TEST server and do QA checks, corrections
Submit Help Desk ticket to get CF code published to Production
Install Cold Fusion Development Server – downloaded for free from Adobe
Install SQL Server (note that WASO is using SQL 2008, NOT SQL 2008 R2)
Open SQL Server Network Configuration and verify that the TCP/IP service is enabled.
Application databases can be developed in Access and then converted to SQL Server using the upsizing wizard.
Create new SQL Server Cold Fusion data sources
Convert Cold Fusion web pages from Access SQL to Transact-SQL (T-SQL)
Move application to WASO server
Clean up database by removing unnecessary tables and queries, removing linked tables, and cleaning up indexes
Submit Access database for upsizing to WASO SQL Server
Copy pages to WASO development server
Convert Cold Fusion web pages from Access SQL to T-SQL
Part 1: Upsizing Wizard data type conversion
Part 2: Functions and Null Concatenation
Part 3: Getting Date and Time
Part 4: Referring to Date Literals
Part 5: Formatting Dates