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