Hello, I am having trouble setting up a connection from Coldfusion MX7 to SQL Server 2005 on my home laptop. 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-express ). 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.com/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 If any one has any ideas, let me know. Any help is appreciated. Thanks! CW
Why are you using a custom driver? Are you doing something special that would keep you from using the built-in jdbc driver for MSSQL that is bundled with ColdFusion?
Honetly - I was just doing what the directions said, because as I was reading up I saw several sources say that Coldfusion cant make a connection to SQL Server 2005 express with out a special driver. Since this post however I have tinkered around with it enough that I ended up doing it the way I'm used to, just using the normal SQL Server driver that Coldfusion provides. It works now thankfully. It was just way more of a hassle then it should have been. Thank you for your reply. CW
I use cfmx7 with SQL 2005 database, In your coldfusion administrator you only need to select "Microsoft SQL Server" from the drop down menu when you are adding a new datasource. here is a link to the livedocs: http://livedocs.adobe.com/coldfusio...xt=ColdFusion_Documentation&file=00001743.htm here is a link to the new driver for mssql 2005 and 2000 http://www.microsoft.com/downloads/...3b-32ff-4474-a44a-22b6ae2c4e17&displaylang=en heres a good blog on Ben Fortas website http://www.forta.com/blog/index.cfm/2006/1/10/ColdFusion-And-SQL-Server-2005 Good luck, Try a search on "cfmx7 Sql 2005 driver" if you havent done to already.
You might also want to insure your SQL 2005 server is allowing remote connections by default it doesn't To resolve these problems, you have 2 majors task. One is to enable both SQL Server and Windows authentication mode on SQL Server and the other is to allow remote connection and SQL Server Browser.
Ok, I am having a similar problem, I have CF 8 and SQL Sever 2005 express on my laptop and cannot set up a datasource. What is it exactly that I need to do to correct the problem? When I open my SQL server management studio, I have the option of using windows auth or sql server auth so I am assuming they are both enabled how do I check the remote connection and SQL browser seems to be working. Tia