I run SQL Express 9.0 with CF version 8 without difficulties. Perhaps I can help. Email me privately and I can show you some of my setting. I am using ODBC and not JDBC.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Aaron Renfroe [mailto:[email protected]] Sent: Tuesday, December 16, 2008 1:53 PM To: sql Subject: JDBC Driver With CF 8 Hello All! I am trying to set up a datasource using JDBC instead of ODBC with CF8. I have downloaded and installed the sqljdbc.jar and placed it in C:\ColdFusion8\lib (This is a localhost/test server) Inside of the CF Administrator/Datasources Its asking me for information that I'm not sure how to answer: CF Data Source Name: Griffin JDBC URL: C:\ColdFusion8\lib ??? is that right? Driver Class: Not sure what it wants or where to get it Username: SQL username? Password: SQL Password? I have lost a day and half my hair to trying to set up a ODBC with SQL Express 08 and CF Server. Please Help J ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3162 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
