Okay, here's what I've done so far. I have a datasource called JMH. It's the ONLY one that's not working. SO I clicked on JMH, and pointed it to another database. I got the following error:
Connection verification failed for data source: JMH []java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. The root cause was that: java.sql.SQLException: SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested instance is either invalid or not running. So I thought, "hmmm...I wonder if I can just create everything from scratch?" So I went to enterprise manager, created a database, called it "Jeff" and then switched over to CFAdmin. I created a new SQL Server datasource, named it "Jeff", filled out all the appropriate username/password (same as for JMH...sa) and viola! It worked. So then, I thought, "well, can I point my bad JMH datasource at what I now know is a good, clean, new database that I already know can work in CF?". So I clicked on JMH, pointed the *database* to "Jeff" and clicked "submit" and got the exact same error message as above. Now I'm really stumped. -- Jeff Small LHWH Advertising Myrtle Beach, SC 29577 843-448-1123 Ext 254 ----- Original Message ----- From: "Jeff Small" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, July 15, 2005 10:17 AM Subject: Why does only one datasource throw an error? >I have a SQL server here for development, and all the other datasources >that > the CF Admin are pointing to that reside on that server are coming back as > good (Verify all Connections...ok) but one is throwing an error. I deleted > it, and tried to reinstall the datasource, but I got the following error: > > Connection verification failed for data source: JMH > []java.sql.SQLException: SQLException while attempting to connect: > java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]The requested > instance is either invalid or not running. > The root cause was that: java.sql.SQLException: SQLException while > attempting to connect: java.sql.SQLException: [Macromedia][SQLServer JDBC > Driver]The requested instance is either invalid or not running. > > I don't understand...*what* instance is either invalid or not running? The > SQL Server is there, it's running, the database is there, it's okay, the > tables are there, they have data in them...*other* tables are there and > are > working...where should I go next? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211988 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
