Install the driver onto your machine and then choose "other" when creating a dsn in cfadmin. You may also need to add the path to the jar file in the classpath section of Java and JVM settings in CFAdmin.
Then you just fill in the JDBC URL and Driver Class for the SQL jdbc. This is what I have done for MySQL so I am guessing it will be similar. Anyone else? HTH Dave SStewart wrote: > Is there any way to change the JDBC driver that ColdFusion uses. IE: > Microsoft has come out with a new JDBC Driver (in beta) for SQL 2000/2005. > I'd like to uses this instead of the SQL Server Driver that comes with CF to > see if it'll solve some of the problems we've been having. > > Thanks > > sas > > Scott A. Stewart, > Web Application Developer > > Engineering Consulting Services, Ltd. (ECS) > 14026 Thunderbolt Place, Suite 300 > Chantilly, VA 20151 > Phone: (703) 995-1737 > Fax: (703) 834-5527 > > "Many thousands of years ago, a blue faced Pict stepped on a bloated sheep > carcass... and thus the Pipes were born" > > .... the Scottish Rogues > > > -----Original Message----- > From: Marlon Moyer [mailto:[EMAIL PROTECTED] > Sent: Monday, May 09, 2005 04:11 pm > To: CF-Talk > Subject: Re: Creating Windows GUIDs with Cold Fusion > Importance: Low > > Sorry, gmail hiccup. > > On 5/9/05, Marlon Moyer <[EMAIL PROTECTED]> wrote: > >>Like this? >> >>http://www.cflib.org/udf.cfm?ID=54 >> >>or do you mean something else... >> >>On 5/9/05, SStewart <[EMAIL PROTECTED]> wrote: >> >>>All, >>> >>>Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with >>>Cold Fusion? >>> >>>sas >>> >>>Scott A. Stewart, >>>Web Application Developer >>> >>>Engineering Consulting Services, Ltd. (ECS) >>>14026 Thunderbolt Place, Suite 300 >>>Chantilly, VA 20151 >>>Phone: (703) 995-1737 >>>Fax: (703) 834-5527 >>> >>>-- >>>No virus found in this outgoing message. >>>Checked by AVG Anti-Virus. >>>Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 05/09/2005 >>> >>> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213584 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