What port were you using for 2005 and what port are you using for 2000? I have both installed at the same time. The only difference is the port. 2005 Express by default assisgns a dynamic port, where as 2000 is set to 1433.
Teddy On 9/4/06, Rusty Owens <[EMAIL PROTECTED]> wrote: > > 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? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:251986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4