The above was different a while ago. Yes, Microsoft used Data Direct.
Now Microsoft Ships their OWN JDBC Type IV Driver.
When i tested both back last year
J2SE = 1.4.1
MS JDBC Driver = 30 - 50 ms
Data Direct JDBC Driver = 200-500ms (Very IN-CONISTENT)
The above says MS has got something different than DataDirect.
Also MS Does NOT support SQL Server 7.0 and Data Direct supports SQL Server 7.0
Joe Eugene
----- Original Message -----
From: Calvin Ward
To: CF-Talk
Sent: Tuesday, October 21, 2003 4:59 AM
Subject: Re: DataDirect JDBC drivers (shipped with CFMX)..
How do we know that the Microsoft provided driver is from DataDirect?
- Calvin
----- Original Message -----
From: Vince Bonfanti
To: CF-Talk
Sent: Monday, October 20, 2003 10:31 PM
Subject: RE: DataDirect JDBC drivers (shipped with CFMX)..
The Microsoft SQL Server JDBC driver is OEM'd from DataDirect, the same
people who provide the CFMX drivers. If you're having problems with the
DataDirect drivers (either Microsoft's OEM'd version or the one provided
with CFMX), you may want to look for another commercial driver. You can find
a list from Sun's web site:
http://servlet.java.sun.com/products/jdbc/drivers
You should stick with the J2EE-certified drivers. Here's one that I can
personally recommend:
http://www.newatlanta.com/products/jturbo/index.jsp
BTW, this driver (JTurbo) is provided free with BlueDragon.
Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com
-----Original Message-----
From: Joe Eugene [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 9:07 PM
To: CF-Talk
Subject: RE: DataDirect JDBC drivers (shipped with CFMX)..
This has been discussed Serveral times here..
Use your Vendor Specific JDBC Driver. MM Provides Some Drivers for Ease of
Client use, i dont think this necessarily means the Best Driver.
MS-SQL Server Specific.
When i tested the Microsoft released JDBC Type IV Driver, this performed
very well
and was very Stable compared to any other.
They Key is always Go With the Vendor Specific Stuff... most likely this
will be LESS Headache.
http://www.microsoft.com/downloads/details.aspx?FamilyID=4f8f2f01-1ed7-4c4d-
8f7b-3d47969e66ae&DisplayLang=en
There were some concerns here that the above Driver was not compatible with
J2SE 1.4....
For the stuff in CFMX.. Everything works well.
Joe Eugene
-----Original Message-----
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 5:07 PM
To: CF-Talk
Subject: DataDirect JDBC drivers (shipped with CFMX)..
Apparently whichever way you go there's going to be an issue to deal with
on the JDBC drivers, has anyone else worked through these? This is on
Windows 2000, with SQL Server 2000.
===============================
DataDirect 3.1 Old (CFMX Updater 3)
- cfstoredproc: Could not find prepared statement with handle
DataDirect 3.1 New (CFMX 6.1)
- 100% CPU Utilization
DataDirect 3.2
- no more data to read
- sql insufficient memory to complete this query
===============================
Thanks,
Calvin
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
