[RESOLVED] New SQL Server DB Table

[obrienkev]

Hi,

training_notes is a new table but the code doesn't seem to see it.

Why is this? Using Enterprise Manager. Other tables are ok.

Thanks.

[DoctorWho]

uh, what's the code?

[Doug_G]

SQL Server permissions may be causing this problem. If you created the table using EM as, say, the su user, and then connect from php as a different user you may not be able to see the table. If that's the case use EM to set the permissions on the table to allow your code to get to the table.