How to reference a table without specifying database.owner?
Posted on 2005-05-05
We've installed a new database on an existing SQL Server 2000 instance. We're using this same database locally on the same version of SQL Server. On our local site, we can reference the tables in the database simply by table name (select * from info). However, on the new installation, we can only reference the tables by databasename.dbo.table_name (select * from mydb.dbo.info). We've checked the permissions of the user set up in the ColdFusion Datasource on both installations and they appear to be the same (they're both DBO's of the databases). We've got the databasename in the JDBC URL of the datasource also. The ONLY difference that we can find between the two installations is that one is ColdFusion 6.1 and the other is ColdFusion 7 (not sure if that helps, just wanted to mention it).
Any ideas on if this is a permissions problem and how to solve it or is there something we need to set up in ColdFusion?