1. Did you try the 2 lines to see if your system can create service factory connection?
2. Important. Make sure NONE of your data source names have spaces or special characters like dots. When creating DSN follow the same rules as CF simple variable names. One of the testers had the similar problem as yours. He found discovered it was a dot in DSN.
At 12:38 PM 6/9/2004, you wrote:
I have createObject enabled in CFA. This is how I always create object references. I am running the files from the following location. Please let me know if the location is not right
http://localhost:8500/Switch_box_tools/CFSQLTool/default.cfm
Thanks
----
- -----Original Message-----
- From: Joseph Flanigan [mailto:[EMAIL PROTECTED]]
- Sent: Wednesday, June 09, 2004 10:52 AM
- To: [EMAIL PROTECTED]
- Subject: RE: [CFCDev] CFMX SQL Server Code Generation Tool
- You have a couple of choices to get the tool working.
- In CFA is the resource security, make sure the CreateObject function is enabled.
- By design, the tool uses the CreateObject function in the GenTool_SQLService.cfc. Otherwise, all objects are made with <cfinvoke just because not all host providers allow CreateObject.
- Put these to lines in a .cfm and try it. If this works, then the tool should work as well.
- <cfset factory = CreateObject("java", "coldfusion.server.ServiceFactory")>
- <cfdump var="#factory#" label="factory" expand="no">
- Also if you are on a host provider who does not allow CreateObject, then you can put add the data source name in the form the error message provides.
- Joseph
- At 11:21 AM 6/9/2004, you wrote:
- Ok, I downloaded and executed the app but got the following error on the top of the page, which is the first top right frame
The CreateObject function failed to create object for DSN.
- This is may be caused by the function not being enabled in the CFMX Administrator.
- What do I need to do on Admin side?
- Thanks
- -----Original Message-----
- From: Joseph Flanigan [mailto:[EMAIL PROTECTED]]
- Sent: Tuesday, June 08, 2004 9:46 PM
- To: [EMAIL PROTECTED]
- Subject: [CFCDev] CFMX SQL Server Code Generation Tool
- General Availability of CFMX SQL Tool Code Generation Tool, Version 1.4+
- MediaFirm's CFMX / MS SQL Server Tool is released for general use and available for download.
- Download: http://www.switch-box.org/CFSQLTool/download
- This tool sets a milestone for code generation! It is packed with features that will save many hours of coding and debugging.
- CFSQLTool is a set wizards for CF and SQL code generation and execution using SQL Server meta-data from tables, views and stored procedures
- - generates CFC, cffunctions and CF namespace variables
- - generates SQL and executes stored procedures
- - general purpose SQL batch tool for running SQL scripts.
- License is GNU-GPL, Open Source, without $ charge. The download is a zip of about 200K. -- There is lots of code to explore.
- Code generators require CFMX and SQL Server 2000. It uses CFFactory for data source name selection. The SQL Batcher feature can run with any CF data source. Minimum system is Windows 2000, IIS, CFMX 6.1 developer edition and SQL Server MSDE.
- The wizards include:
- SQL Batcher - something like Query Analyzer but uses CFQuery.
- Table Wrapper - CFC generator with cffunctions for CRUD List and Actor using CFquery.
- Table Wrapper application - Generates a CF application that uses the table wrapper CFC
- Stored Procedure Suite - Generates CRUD stored procedures and loads procedures to DB, better than Query Analyzer
- Stored Procedure Wizard - Show, Run, Drop Procedures.
- Generates CF name spaces defined by procedure variables
Generates a CFC for stored procedures with cffunctions used cfstoredproc - Table Defined Name Spaces Wizard - bangs out a collection of CF variable names defined by SQL Server data definitions
- There are several pages of documentation including a SQL name spaces style guide.
- Below is an image of the Table Wrapper Wizard Selector form. Its allows designing a suite of queries that generates a CFC using simple check boxes. It shows more detail about the table's constraints than some other DB IDE tools. The wizard counts generation iterations. This makes it easy to design multiple queries that can be cut and pasted into the Wrapper CFC.
- The Stored Procedure Suite Wizard uses a similar selector form, but generates stored procedures instead. If you do stored procedures, it will not believe how easy it is do them with this tool!
- SQL Batcher is a versatile tool just because it is easy to run SQL and see a CFDump of the results. SQL Batcher will load and run a .SQL batch file. In the download is an example contacts DB SQL batch file that SQL Batcher can run to build the data base with tables and views. It runs the same in Query Analyzer as it does with SQL Batcher. The result report, counts each batch block, reports the execution time, code block executed and results.
- ------------------------------------------
- Switch_box
- www.Switch-box.org
- MediaFirm, Inc.
- PO Box 2171
- Loveland, CO 80539
- [EMAIL PROTECTED]
- ----
- This email may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.
- To reply to our email administrator directly, send an email to
- [EMAIL PROTECTED]
- Littler Mendelson, P.C.
- http://www.littler.com
- ------------------------------------------
- Switch_box
- www.Switch-box.org
- MediaFirm, Inc.
- PO Box 2171
- Loveland, CO 80539
- [EMAIL PROTECTED]
This email may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.
To reply to our email administrator directly, send an email to
[EMAIL PROTECTED]
Littler Mendelson, P.C.
http://www.littler.com
------------------------------------------
Switch_box
www.Switch-box.org
MediaFirm, Inc.
PO Box 2171
Loveland, CO 80539
[EMAIL PROTECTED]
