Solved

ODBC or JDBC

Posted on 2004-10-07
4
317 Views
Last Modified: 2013-12-24
If I have the option of using a JDBC driver or an ODBC driver, which one is best for Coldfusion?
0
Comment
Question by:psenn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 21

Expert Comment

by:pinaldave
ID: 12249199
JDBC.
Coldfusion itself use this driver for connection.
If you want to use ODBC then you need extra pluginfor JDBC which can work for ODBC.
Regards,
---Pinal
0
 
LVL 21

Expert Comment

by:pinaldave
ID: 12249238
if you want to use odbc then you need bridge... http://www.easysoft.com/products/2003/coldfusion.phtml
0
 
LVL 1

Expert Comment

by:Wasistdas
ID: 12270933
No JDBC, no bridges. CF5, Access2000, Win98.
0
 
LVL 5

Accepted Solution

by:
elvistheprince earned 50 total points
ID: 12285762
I think the answer is probably "it depends", coldfusion (MX that is) is generaly better using the JDBC drivers (i.e. when you drop down "driver" in cf administrator and it gives you the variouse options), however as far as I am aware CFMX 6.1 can't do intergrated security to SQL Server for instance, in this circumstance createing a DSN on the server [Data Sources(ODBC) in control panel or administrative tools] and using ODBC sockets is best as you can at least gthen use intergrated security.

Stephen
0

Featured Post

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
AWS New EC2 Instance and EBS Storage 2 93
Systems talking to each other 5 146
Ways to assess https/ssl websites 3 112
Stream live video from Raspberry Pi camera 22 253
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question