> 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.
My guess, based on your error message, is that you're using different values for either the database server or the port. With SQL Server 2000, you can run multiple instances of SQL Server on the same machine. Each one will listen on a different port, and have a different name, although the name isn't especially important outside of Enterprise Manager. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:211992 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
