Another BlogCFC Update

This post is more than 2 years old.

First off - the zip from this morning was missing the updated CFC. Sorry folks. Secondly, I found another oddity with queryparam under BlueDragon. The filters for day/month/year all used a queryparam using type="cf_sql_integer". This worked ok under CFMX/Access. In BD/Access, it gave me an "optional feature not implemented" error. When I switched the type to cf_sql_numeric, it worked ok in both platforms.

Anyway - the zip is updated (for real this time).

Big thanks to Rey Bango for helping me debug this!

Raymond Camden's Picture

About Raymond Camden

Raymond is a senior developer evangelist for Adobe. He focuses on document services, JavaScript, and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA https://www.raymondcamden.com

Archived Comments

Comment 1 by Rey Bango posted on 5/28/2005 at 12:58 AM

My pleasure Ray. Thank for your awesome support and great software.

Rey////

Comment 2 by jeff gladnick posted on 8/31/2005 at 5:03 PM

I am getting this same error, but under cfmx 7 with SQL server

Comment 3 by jeff posted on 8/31/2005 at 5:05 PM

And the error

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented

The error occurred in C:\CFusionMX7\wwwroot\blogcfc\org\camden\blog\blog.cfc: line 933
Called from C:\CFusionMX7\wwwroot\blogcfc\client\includes\pods\recent.cfm: line 18
Called from C:\CFusionMX7\wwwroot\blogcfc\client\tags\layout.cfm: line 123
Called from C:\CFusionMX7\wwwroot\blogcfc\client\index.cfm: line 189
Called from C:\CFusionMX7\wwwroot\blogcfc\client\index.cfm: line 86
Called from C:\CFusionMX7\wwwroot\blogcfc\client\index.cfm: line 1
Called from C:\CFusionMX7\wwwroot\blogcfc\org\camden\blog\blog.cfc: line 933
Called from C:\CFusionMX7\wwwroot\blogcfc\client\includes\pods\recent.cfm: line 18
Called from C:\CFusionMX7\wwwroot\blogcfc\client\tags\layout.cfm: line 123
Called from C:\CFusionMX7\wwwroot\blogcfc\client\index.cfm: line 189
Called from C:\CFusionMX7\wwwroot\blogcfc\client\index.cfm: line 86
Called from C:\CFusionMX7\wwwroot\blogcfc\client\index.cfm: line 1

931 :
932 : order by tblblogentries.#arguments.params.orderBy# #arguments.params.orderByDir#
933 : <cfif structKeyExists(arguments.params,"maxEntries") and instance.blogDBType is "MYSQL">limit #arguments.params.maxEntries#</cfif>
934 : </cfquery>
935 :

Comment 4 by Raymond Camden posted on 8/31/2005 at 5:08 PM

It looks like you are using the ODBC DSN and not the native SQL Server drive. Why?

Comment 5 by Akbar posted on 4/6/2008 at 8:28 PM

I am getting the same error and am using ODBC connection for MSSQL Server 2000

‘[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented'

I am using the blogCFC latest version (Last Updated: January 14, 2008 (BlogCFC 5.9.002) as per in the readme.txt file in the install folder). I am using ODBC because for a long time I’m having the issue of creating Datasource as MS SQL Server as drive.

‘Connection verification failed for data source: CFBlog
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver] Error establishing socket to host and port: AKBAR-DE746B0A1:1433. Reason: Connection refused: connect The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: AKBAR-DE746B0A1:1433. Reason: Connection refused: connect’

I tried lot of Blog entries and answers to fix this problem but I’m not able to fix ?
Please give me some suggestion to fix ‘Optional feature not implemented’ issue.

Comment 6 by Raymond Camden posted on 4/6/2008 at 8:30 PM

Well from the error, it says connection refused. Go to your CF Admin and if you verify the dsn, you will most likely get the same issue. It is a problem connecting to your db from CF.

Comment 7 by Akbar posted on 4/6/2008 at 8:52 PM

But i'm able to connect my db from CF using ODBC it's working.
I'm able to create categories in my BlogCFC using Admin login it's working great but at the content side i'm getting this issue even i'm getting the calender and Latest from MXNA Feed above this error.

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver]Optional feature not implemented

The error occurred in E:\Projects\AkbarsCFBlog\org\camden\blog\blog.cfc: line 1341
Called from E:\Projects\AkbarsCFBlog\includes\pods\recent.cfm: line 22
Called from E:\Projects\AkbarsCFBlog\tags\getpods.cfm: line 32
Called from E:\Projects\AkbarsCFBlog\tags\layout.cfm: line 100
Called from E:\Projects\AkbarsCFBlog\index.cfm: line 47
Called from E:\Projects\AkbarsCFBlog\index.cfm: line 31
Called from E:\Projects\AkbarsCFBlog\index.cfm: line 1
Called from E:\Projects\AkbarsCFBlog\org\camden\blog\blog.cfc: line 1341
Called from E:\Projects\AkbarsCFBlog\includes\pods\recent.cfm: line 22
Called from E:\Projects\AkbarsCFBlog\tags\getpods.cfm: line 32
Called from E:\Projects\AkbarsCFBlog\tags\layout.cfm: line 100
Called from E:\Projects\AkbarsCFBlog\index.cfm: line 47
Called from E:\Projects\AkbarsCFBlog\index.cfm: line 31
Called from E:\Projects\AkbarsCFBlog\index.cfm: line 1

1339 : <cfif instance.blogDBType is "ORACLE" and structKeyExists(arguments.params,"maxEntries")>
1340 : )
1341 : WHERE rownum <= <cfqueryparam cfsqltype="cf_sql_integer" value="#arguments.params.maxEntries#"><!--- #arguments.params.maxEntries# --->
1342 : </cfif>
1343 : </cfquery>

Comment 8 by Raymond Camden posted on 4/7/2008 at 2:23 AM

I see you are using the ODBC Socket. Don't. Use the SQL Server driver.