943,553 Members | Top Members by Rank

Ad:
  • ColdFusion Discussion Thread
  • Marked Solved
  • Views: 3667
  • ColdFusion RSS
Jul 12th, 2008
0

Connecting Coldfusion to SQL Server

Expand Post »
Hello,

I am currently having problems getting Coldfusion and SQL Server 2005 to connect on my home laptop. I have both installed correctly, I just cant seem to get the connection part down I keep getting this error from the Coldfusion Administrator.

Connection verification failed for data source: GTOTDsite
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running.


Any help would be appreciated. Thanks

Cody
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vagettoanima is offline Offline
2 posts
since Jul 2008
Jul 13th, 2008
0

Re: Connecting Coldfusion to SQL Server

Update:

Hello again,

I worked on this problem all night and found several "solutions". None of those worked completely but I did make progress.

The first problem I was having was making a connection to the SQL Server, which is what I am still having problems with. I get this error now when I try to make a database connection.

Connection verification failed for data source: GTOTDsite
java.sql.SQLException: No suitable driver
The root cause was that: java.sql.SQLException: No suitable driver


I was also having problems logging in to the server but I did get that working completely now.

As I said I found sevral solutions but the one that helped me the most is here http://www.fusioncube.net/index.php/...server-express

Near the end of this article it says that I need to download a driver/jar for the SQL Server 2005 and put it in a specific coldfusion directory which I do not have in my coldfusion files. This is where I could use some help again,

Once again any help is appreciated.

Cody
Reputation Points: 10
Solved Threads: 0
Newbie Poster
vagettoanima is offline Offline
2 posts
since Jul 2008
Jul 18th, 2008
0

Re: Connecting Coldfusion to SQL Server

hello,
Please Configure you Sql Server NetWork Configuration
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jinu is offline Offline
4 posts
since Jun 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ColdFusion Forum Timeline: Confusion on CF form finding CSV database
Next Thread in ColdFusion Forum Timeline: does dreamweaver MX can create forum?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC