Hi,
I've created a new database on SQL7 and have been able to verify connection with CF Administrator. However, any queries based on this database is returning Base Table Not Found. Now obviously I've checked spelling and everything, but when I ran a quick query via CF on the sysobjects table, the tables I have created are not listed...
I just wondered if there was a default that means new tables in new databases are not seen, I wouldn't have thought so, but I am stuck big time...
Cheers,
Kev
I've created a new database on SQL7 and have been able to verify connection with CF Administrator. However, any queries based on this database is returning Base Table Not Found. Now obviously I've checked spelling and everything, but when I ran a quick query via CF on the sysobjects table, the tables I have created are not listed...
I just wondered if there was a default that means new tables in new databases are not seen, I wouldn't have thought so, but I am stuck big time...
Cheers,
Kev