That's cool, I appreciate the input. thanks
sas Craig Dudley wrote: > Had a good look but can't find the examples, it's fairly easy to set up > anyway. > > The MS SQL Server JDBC driver is three/jar fiels I think? Just drop them > into \ColdFusion8\runtime\jre\lib\ext and restart CF, the .jar should then > appear in the big CF Server Java Class Path box in settings summary in CF > Admin. > > When you add a datasource, elect other from the driver dropdown it will ask > you for a JDBC URL, Driver Class and Driver Name. All of which is standard > JDBC stuff but there are docs in the MS download package I think, it's not > complex either way but sorry I couldn't find my examples as it might have > saved some time. > > Craig. > > -----Original Message----- > From: Scott Stewart [mailto:[EMAIL PROTECTED] > Sent: 11 August 2008 17:14 > To: CF-Talk > Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 > Driver > > Thanks Craig.... > > The higher ups have deemed this a "last resort"... so if it comes to > this I'll put up some results. > I'm pursuing what could be an issue with cfqueryparam > > Craig Dudley wrote: > >> Not for a while, from memory you just drop the three MS .jar's somewhere >> > in > >> CF's classpath and restart CF to install and creating datasources becomes >> > a > >> bit more dificult, I'll see if I can dig up an example for you. >> >> I seem to remember that performance wasn't all that great, in fact, CF7's >> built in drivers were faster in most of my test cases. Sorry I haven't >> > tried > >> them on CF8. >> >> The MS drivers don't cause any issues with CF's built in drivers though so >> why not give it a try on your dev box? >> >> Craig. >> >> -----Original Message----- >> From: Scott Stewart [mailto:[EMAIL PROTECTED] >> Sent: 11 August 2008 15:10 >> To: CF-Talk >> Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3 >> > Driver > >> Hey all, >> >> I've run into an issue that I need opinions on. We've run into some SQL >> server issues, where MS is saying "patch the driver". >> Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place of the >> one shipped with CF8? >> Has it cleared up 8180 errors? >> Any performance gains/losses? >> Any "gotchas"? >> >> thanks >> >> sas >> >> >> > > -- -- Scott Stewart ColdFusion Developer Office of Research Information Systems Research & Economic Development University of North Carolina at Chapel Hill Phone:(919)843-2408 Fax: (919)962-3600 Email: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
