>I am trying to set up a datasource using JDBC instead of ODBC with CF8.
Why not just use the built in jdbc drivers? On the datasource page, select "MS SQL Server" from the driver list and enter the settings for your database. Here is an example. Your settings may differ: Server: 127.0.0.1 Port: 1433 (** default) Database: MyTestDatabaseName User: mySQLServerUserName Password: mySQLServerPassword >I have downloaded and installed the sqljdbc.jar and placed it in >C:\ColdFusion8\lib (This is a localhost/test server) I am using the MS SQL 2005 driver on a test machine. Here are my settings. (Be aware the driver class _is_ case sensitive) JDBC URL: jdbc:sqlserver://127.0.0.1:1433;DatabaseName=MyDatabaseName Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver Driver Name: com.microsoft.sqlserver.jdbc.SQLServerDriver User name: mySQLServerUserName Password: mySQLServerPassword ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3164 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
