Coldfusion MX ? ? ?

Posted on 2002-07-23
Last Modified: 2013-12-24
Hi there,

I've been using CFServer 4.5 for a while and is now testing the Coldfusion MX Enterprise server - on a MS SQL Server 7.0 !

However I'm a bit worried about potential performance issues regarding W2000, CF MX and MS SQL 7.0/2000 !

Any comments on that ?

Here is piece of TechNote 23131 from :

Note: The ODBC SOCKET is a JDBC Type 3 driver which translates JDBC calls into the middle-tier server, which then translates the request to the database-specific native-connectivity interface. Because database-specific code must be executed in the middle-tier, the ODBC SOCKET Type 3 driver does not perform as fast as the Microsoft SQL Server Type 4 driver which converts JDBC calls into the network protocol used directly by the database.



BTW : How can you create the best datasource for MS SQL SERVER ?
Question by:kennethlowe
  • 3

Expert Comment

ID: 7172729
This question has sort of been answered in a similiar question.

SEE the following

Accepted Solution

CFXPERT earned 200 total points
ID: 7192352
The best datasource?  There is no such thing.  A datasource is a datasource.  I have offered the best suggestions you'll find and if you need any other assistance you can email me at



Author Comment

ID: 7194405

I might be a bit rusty in my's sometimes hard to express exactly what you want to know ;-)

About the datasource I realy ment somthing about how the different types of CF avaible/usable datasource performed in the kind of environment I described above.

Anyway...I decided not to go with MX at the moment...

Thank You for answering.


Expert Comment

ID: 7194414
Not a problem.

Have a good day.



Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Server specifications for web hosting 7 90
YouTube Friendly Video Addresses 3 84
Problem to Popup 37 100
spamming  on Hosted svrs? 6 72
One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following:…
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 Log into your Hosting account. IPage will be used for demonstration : Locat…

943 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

7 Experts available now in Live!

Get 1:1 Help Now