Drivers and dbtypes in CFMX 7

[TrevJames]

I have my <cfquery dbtype="ODBC"> in our CF 5.1 applications. We moved these
applications to our CF MX 7 server for testing and I'm getting some invalid
data errors when using these applications. The drivers are set to MySQL (3.x)
in our CF MX admin. Do I need to change these drivers back to ODBC socket in
CFMX 7?

-Trevor James
--
Trevor James
Web Site Manager
Hood College
Office of Marketing and Communications
Frederick, MD 21701

Phone: (301) 696-3846
Email: [email]james@hood.edu[/email]

[mpwoodward *TMM*]

TrevJames wrote:

> I have my <cfquery dbtype="ODBC"> in our CF 5.1 applications. We moved these
> applications to our CF MX 7 server for testing and I'm getting some invalid
> data errors when using these applications. The drivers are set to MySQL (3.x)
> in our CF MX admin. Do I need to change these drivers back to ODBC socket in
> CFMX 7?

Can you provide the exact error you're getting? What version of MySQL
are you using? If you're using MySQL 4.1 or higher, the driver that
ships with CF 7 will not work and you'll have to download and use the
JDBC driver from the MySQL web site. There are explicit instructions on
how to go about doing this on macromedia.com. You don't want to use an
ODBC socket because the performance will be poor compared to JDBC.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[TrevJames]

Here's the error I'm receiving. We're running MySQL version 3.23.38-1:

Invalid data For more information contact . for CFSQLTYPE CF_SQL_VARBINARY.

The error occurred in
E:\Inetpub\wwwroot\news\admin\form_add_featureActi on.cfm: line 11

9 : <cfelse>
10 :
11 : <cfinsert datasource="newsInfo" tablename="features">
12 : <cflocation url="index.cfm?pageID=_list_features.htm" addtoken="No">
13 :