> I am having trouble setting up a connection from Coldfusion > MX7 to SQL Server 2005. > > After several hours of tinkering with settings that I know > and searching the internet for the things I didn't, I found a > very helpful guide to setting it up (here ---> > http://www.fusioncube.net/index.php/coldfusion-sql-server-expr > ess ). That was a very good guide. However on of the last steps > he says to do is to download a .jar driver so that cold > fusion can make the JDBC connection, and he gives a link > (http://www.fusioncube.net/index.php/%20http://www.microsoft.c > om/downloads/details.aspx?familyid=e22bc83b-32ff-4474- > a44a-22b6ae2c4e17&displaylang=en) > which doesn't work. He also says to put that file into a > folder in my coldfusion directory that does not exist. > > I ended up tinkering around with it for about two hours and > stopped when I couldn't figure out this error. > > Connection verification failed for data source: GTOTDsite > java.sql.SQLException: No suitable driver The root cause was > that: java.sql.SQLException: No suitable driver
First, you can just search the Microsoft site for SQL Server 2005 JDBC drivers. Download those, and run the setup. If I recall correctly, the setup just unpacks the jar files you need to some directory; you'll then need to put them in your lib directory. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:309010 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
