CANNOT ADD DATA

Question

Post reply

CANNOT ADD DATA

ranjita prasad

SSC Veteran

Points: 281
More actions
July 20, 2006 at 6:08 pm

#171608

I AM NOT ABLE TO ADD NEW DATA IN MY CLIENT TABLE.
BEFORE I WAS ABLE TO ADD

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

David Webb-CDS SSCoach Points: 17398 More actions · Answer 1

How are you trying to add the data and what, if any, error message are you getting?

And then again, I might be wrong ...
David Webb

ranjita prasad SSC Veteran Points: 281 More actions · Answer 2

i had a client server application made in delphi

i do not get any error messages

it just does not add new clients

David Webb-CDS SSCoach Points: 17398 More actions · Answer 3

Can you turn on a profiler trace, or an odbc trace, to trap the sql and any associated errors?

Can you log in to the sql server OK?

Do you know of anything that might have been done to the server or database recently?

Are you the DBA?

Without some additional information, I'd just be guessing as to what might be wrong.

And then again, I might be wrong ...
David Webb

ranjita prasad SSC Veteran Points: 281 More actions · Answer 4

i can log in the sql server

the puzzling part is that i can add other information except this ones.

a additional database was added to the server, nothing much

no i am not a dba

David Webb-CDS SSCoach Points: 17398 More actions · Answer 5

Check with the DBA to make sure you still have permissions to insert to the table. If the permissions are OK, ask him or her to run the traces mentioned before to see what is really happening on the server.

And then again, I might be wrong ...
David Webb

Sreejith Sreedharan SSCertifiable Points: 5403 More actions · Answer 6

Does the table have a trigger that is failing on insert? Cos that is one kind of error that will be tuff to troubleshoot.

Razvan-Mihai Dudu SSC Enthusiast Points: 161 More actions · Answer 7

First of all, check the status of the account your app uses to connect to the database... and then what permissions are in place for that table.

See if you can run this in QA (or other query tool you use):

GRANT ALL ON {your_troublesome_table} TO {security_account_4_your_app}

For that to work the account you use to connect to your database should be in sysadmin role (see BOL on "GRANT")

If you're not in sysadmin role (most likely), then try

GRANT SELECT, INSERT, DELETE, UPDATE ON {your_troublesome_table} TO {security_account_4_your_app}

If that doesn't work either, then trouble your DBA

Good luck

To learn is not to know.