More likely when you installed SQL 2k, it installed itself as a named instance, and possibly on a different port. Make sure that you connect using the proper port, and proper instance name.
Russ > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Monday, September 04, 2006 3:32 PM > To: CF-Talk > Subject: RE: Database question > > > I have ColdFusion MX 7 on my local machine. I installed SQL > > server 2005 and realized that I needed Sql Server 2000 so I > > could do DTS. After uninstalling 2005 and installing 2000, > > it no longer worked. I then heard to installed SQL server > > 2000 SP4 and this got me back up and running. I have created > > my tables in the database but when I try to query them in CF, > > it blows up. When I test the datasource in Windows, it works > > fine but now I get invalid object for the table name I am > > querying. The problem as I see it is it is seeing the SQl > > server 2005 database and not the 2000 database. Any ideas? > > Well, a couple of things could be going on here. My first guess would be > that the tables are in fact there, but are owned by a user other than the > one you're using from CF. This would give you the error you mention. If > you > installed SQL Server 2005, you are not going to be able to connect to it, > so > I don't know what "seeing the SQL Server 2005 database" would mean exactly > - > SQL Server will only allow you to access the databases attached to it. > > Finally, for future reference, you can have both versions of SQL Server > installed on the same machine, so there's no need to uninstall one to get > to > the other. You will, of course, need to know which server is listening on > which port. > > 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! > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
