> 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.
Odd...I was using the "default" values for port (1433), and the server name was exactly the same for each datasource, because I checked that. What I wound up doing, was creating a NEW database, and calling it "JMH2005". Then I used the Import/Export tool to create a DTS package that copied databases and objects between "JMH" and "JMH2005". Then I went into CFAdmin, and created a new datasource, named it "JMH2005" and pointed it to the new database that I just created. It worked like a charm. Once I went into my Application.cfm and changed my datasource to "JMH2005" it all...just...well, worked. I still wonder what happened. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:212001 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
