CFMX7

[ctlcal]

I have a working ODBC connection to an Oracle table (password required) that I
use with ASP pages. I am currently converting this to CF7 and although the
connection verifies in the CF admin I get the following error on line 1:

[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC driver for
Oracle]Error in row 1

The error occurred in C:\Inetpub\wwwroot\CVU\5.cfm: line 1

1 : <cfquery name="Recordset1" datasource="test2">
2 : SELECT *
3 : FROM TABLENAME




at cf52ecfm45432594.runPage(C:\Inetpub\wwwroot\CVU\5. cfm:1) at
cf52ecfm45432594.runPage(C:\Inetpub\wwwroot\CVU\5. cfm:1)


java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC driver for Oracle]Error in row 1
at macromedia.sequelink.ssp.Diagnostic.toSQLException (Unknown Source)
at macromedia.sequelink.ssp.Chain.cnvDiagnostics(Unkn own Source)
etc......


Any suggestions?

[Stephanie]

We recommend that you use a JDBC Driver to connect to databases from CFMX 7 for
performance reasons. If you are running the Enterprise version of CFMX 7 then
you will find it in the driver drop down in the ColdFusion Administrator.
Otherwise, you can take a look at the following technote which also applies to
CFMX 7: [url]http://www.macromedia.com/go/tn_18344[/url] I hope this helps, Stephanie
Juma Macromedia, Inc.

[paross1]

.....keeping in mind that the use of the JDBC Drivers is dependent on the Oracle version. Anything before 8i (8.1.7, I believe) does not support JDBC and must use ODBC.

Phil

[ctlcal]

Thanks for the info. Took about 5 minutes and everythings works great.