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:251979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
