I previously used MS's JDBC for SQL, but went back to CF's implementation. I didn't see much difference in performance by using MS's drivers. There was also the hassle of maintaining yet another third-party item.
By going back to CF's drivers, I only have to worry about MACR's updates. If there are other issues, then I have not yet encountered them. Also, the JDBC with CF allows you to pass-through authentication rather than specify a username and password. As long as you run your CF service(s) as an account, with the correct permissions, that same account can connect to the database. The JDBC URL may be different for each provider. I have only setup SQL and AS400/DB2, so I'm not sure exactly what the other providers look like.. Regardless of my preference on which driver, here are the settings you requested. Driver: Other JDBC URL: jdbc:microsoft:sqlserver://10.0.0.1:1433;databaseName=DBNameHere Driver Class: com.microsoft.jdbc.sqlserver.SQLServerDriver Driver Name: [Anything you want to describe the DSN] Username/password: [An account on the SQL server with access to the DB.] -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: Saturday, November 05, 2005 9:51 AM To: CF-Talk Subject: Using SQL Server JDBC Drivers with MX7? Is anyone using the Microsoft JDBC drivers for SQL Server with CFMX7? If so, are there any advantages in using the MS JDBC drivers over the ones that ship with MX? Followup question, when setting up an "other" type of DSN in CF Administrator, what do you use for the "JDBC URL" setting? I'll assume that the username and password are for the SQL Server account that is being used... Thanks Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223324 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
