Invalid object when table exists..

[baps]

Hi all,

I'm having a strange problem with one table in my DB. All queries on it give the error stated below. The table appears in my table list and creation appears to run fine but I cannot insert any data into it without getting the error which appears to me to say the table doesn't exist.

Any ideas would be welcomed.

Baps.

Table creation query :

CREATE TABLE student_bio (id INT IDENTITY(1,1) NOT NULL PRIMARY KEY, username
VARCHAR(30), fullname VARCHAR(80), firstname VARCHAR(50), surname VARCHAR(50),
email VARCHAR(50), homeInst VARCHAR(30), info VARCHAR (400), pic VARCHAR(100))

Insertion query :

INSERT INTO student_bio
('username','fullname','firstname','surname','email','homeInst','in
fo') VALUES
('$user','$fullname','$firstname','$surname','$email','$homeInst','
$info')

Error :

Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
object name 'student_bio'., SQL state S0002 in SQLExecDirect in
D:\inetpub\care\editStudentBio.php on line 55

[maxpup979]

try this for the insert--

INSERT INTO student_bio
(username,fullname,firstname,surname,emai
l,homeInst,in
fo) VALUES
('$user','$fullname','$firstname','$surname','$ema
il','$homeInst','
$info')

The obvious caveat being I know very little about mssql 🙂 So this could be completely wrong

[baps]

Sorry, neglected to mention its a MS SQL server 7 Dbase.

All the rest of the queries work fine with the field names encapsulated in quotes. It just appears to be this one table that's playing up with insertion. Thanks for trying though.

Any other suggestions welcome.

Baps.