Adobe Community: Message List - cf builder 2.0.1 has MS SQL 2008 connection error

Re: cf builder 2.0.1 has MS SQL 2008 connection error

forums_noreply@adobe.com — Wed, 17 Sep 2014 01:09:48 GMT

FIX FOR SQL SERVER ONLY!!!

I wrote this simple script to get the names of all the system views in SQL server - I'm sure M$ add new tables and as Terry appears to no longer develop apptacular he won;t be aware of the new views. Simply run the script and copy and paste the list of views it creates. Instructions will be displayed after running the script........

<cfdbinfo name="dbi" datasource="yourdatasource" type="Tables">
<cfquery name="dbi" dbtype="query" >
select * from dbi where table_type='VIEW'
</cfquery>
<cfoutput>
Copy the quoted values below and paste them at the bottom of /handlers/cfc/db/datasource.cfc just below the last excludedTableList (About line 455)<br><br>
excludedTableList = excludedTableList & ",#replace(listQualify(valuelist(dbi.table_name), "'"), ",'", ", '", "all")#";
</cfoutput>

Hope it helps

Re: cf builder 2.0.1 has MS SQL 2008 connection error

forums_noreply@adobe.com — Fri, 08 Feb 2013 19:48:35 GMT

I am so glad to see someone else has this very same issue. I really would like to use the extension as it works perfectly with access datasources but I cannot get it to function with SQL 2008 R2.

I will try with sql 2012 and see if that is of any help with this problem.

Terrence, where are you??? Could you respond please? We would all appreciate it very much!!

cf builder 2.0.1 has MS SQL 2008 connection error

forums_noreply@adobe.com — Wed, 06 Feb 2013 15:03:05 GMT

when i try to create Apptacular generation with Mssql 2008 and msAccess : on CfBuilder2.0.1

An Error has occured.

Message:Element IDENTITY.IDENTITY is undefined in a CFML structure referenced as part of an expression.

Details:

this issue written on Github by the apptacular app creator, and has some solutions(not clearly described as solution) and app writers solution didnt worked for me...

I need correct solution, if its possible by correct files?(2 years ago this product was same condition and purchased it 2013 february, its has still same error...)???