Solved

ODBC or JDBC

Posted on 2004-10-07
4
330 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

Create the perfect environment for any meeting

You might have a modern environment with all sorts of high-tech equipment, but what makes it worthwhile is how you seamlessly bring together the presentation with audio, video and lighting. The ATEN Control System provides integrated control and system automation.

Question has a verified solution.

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

Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

628 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