May 27, 2005 (This post is more than 2 years old.)

Another BlogCFC Update

misc

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!

Support this Content!

If you like this content, please consider supporting me. You can become a Patron, visit my Amazon wishlist, or buy me a coffee! Any support helps!

Want to get a copy of every new post? Use the form below to sign up for my newsletter.

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#">
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.

Support this Content!

Archived Comments

Webmentions