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:225341 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
