very cool. Checking 'em out now. Thanks Mark.
On 11/27/05, Mark Fuqua <[EMAIL PROTECTED]> wrote: > Hey, > > There are two posts on: > > http://weblogs.macromedia.com/mxna/index.cfm?query=byCategory&categoryId=1&c > ategoryName=ColdFusion > > about this exact topic. Pretty timely eh? > > Mark > > -----Original Message----- > From: Dirk De Bock - Lists [mailto:[EMAIL PROTECTED] > Sent: Sunday, November 27, 2005 10:00 AM > To: CF-Talk > Subject: Re: SQL Server 2005 and CF? > > > I think the driver class name should be > > com.microsoft.sqlserver.jdbc.SQLServerDriver > > if you drop the jar in the cf lib dir you do not need to change the > classpath > > ----- Original Message ----- > From: "Charlie Griefer" <[EMAIL PROTECTED]> > To: "CF-Talk" <[email protected]> > Sent: Sunday, November 27, 2005 1:36 PM > Subject: SQL Server 2005 and CF? > > > > OS: WinXP Professional (SP2) > > CF: CFMX 6.1 Professional > > DB: SQL Server 2005 Express > > > > Having issues getting a DSN set up (without resorting to ODBC via the > > OS). Anybody successfully gotten this working? > > > > I downloaded the SQL Server 2005 JDBC Driver Beta 2 from > > http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/jdbc.mspx. > > > > Installed to C:\Program Files (the default install). > > > > In the CF Administrator, under datasources, I entered the datasource > > name ('comix'), and selected 'Other' for Driver. > > > > Here are the settings that I've tried on the screen that followed: > > > > JDBC URL: jdbc:sqlserver://localhost:1433;databaseName=comix > > Driver Class: com.microsoft.sqlserver.jdbc > > Driver Name: com.microsoft.sqlserver.jdbc > > > > Error message is: > > Connection verification failed for data source: comix > > []java.sql.SQLException: No suitable driver available for comix, > > please check the driver setting in resources file, error: > > com.microsoft.sqlserver.jdbc > > The root cause was that: java.sql.SQLException: No suitable driver > > available for comix, please check the driver setting in resources > > file, error: com.microsoft.sqlserver.jdbc > > > > I've found bits and pieces of information that are almost relevant, > > but none that are 100%. For example: > > > > Kola Oyedeji has a blog posting that discusses JDBC logging with > > P6spy and CFMX. Not relevant to SQL Server 2005 (or any version of > > SQL Server), but had some good info about JDBC drivers. > > > (http://64.233.187.104/default?q=cache:27tXDmhYjhkJ:coolskool.blog-city.com/ > +meaning+of+blog&hl=en) > > > > MM themselves have a tech note, but it's regarding SQL Server 2000, not > > 2005. > > (http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18652) > > > > I also looked at the documentation that came with the driver. The > > settings that I've posted above are kind of an amalgam of what I was > > able to glean from the 3 sources combined. > > > > Oh...the other variable in the equation is the classpath. > > > > I've tried: > > C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.0\enu > > C:\Program Files\Microsoft SQL Server 2005 JDBC > > Driver\sqljdbc_1.0\enu\sqljdbc.jar > > F:\CFusionMX\lib\sqljdbc.jar > > > > the first two were the location of the jar file by the default driver > > installation (tried both with and without the filename itself). The > > last was due to a suggestion that Kola had made regarding placing the > > jar file in the CFusion\lib directory (I copied the file over > > over...wasn't sure if that would require a classpath variable, but > > figured it wouldn't hurt to try). CFMX service was cycled after each > > time I modified the classpath var. > > > > Been at this for a while, and really ready to give up and take a nap > > (it's 7:30 am Sunday morning). Anybody have any info they can share? > > > > Oh, and yes, I've made sure that SQL Server is using TCP on port 1433 :) > > > > Thanks > > > > -- > > Charlie Griefer > > > > ================================================ > > "...All the world shall be your enemy, Prince with a Thousand Enemies, > > and whenever they catch you, they will kill you. But first they must catch > > you, digger, listener, runner, prince with a swift warning. > > Be cunning and full of tricks and your people shall never be destroyed." > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:225342 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
