Solved

ODBC or JDBC

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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now