Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

ODBC or JDBC

Posted on 2004-10-07
4
Medium Priority
?
344 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
  • 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 200 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

What You Need to Know when Searching for a Webhost Provider
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
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…

972 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