Hi all,
We are using php to connect to a local MS SQL database, and all seems
to be fine.
We are connecting to several tables within the same database, and are
able to insert, update, delete, etc.
However, there is one table that refuses to let us update, and we can
not figure out why.
Steve:
I had to use SQL Server recently and I found it to be a pain with
things like this, especially when I have next-to-no experience with
it. I can't really suggest where to look to fix your issues directly,
but two things I found very useful in working out my own issues:
-- write a script in
Steve,
I just wanted to put it out there that you should be accessing the tables via
views and stored procedures that have permissions set up and not directly
accessing the table from the call on the php page.
Do you have query analyzer? You could drop your SQL statement into there and
run
Thanks Ross.
The person I am working with has access to the database (he's the IT
person for the company), and he should be able to get the tools and
do the looking. He has already looked at the table permissions with
whatever tools sqlserver comes with, and he doesn't see anything
I'll check on the field types and give it a whirl.
thanks!
On Nov 19, 2008, at 12:58 PM, Cheryl Hewitt wrote:
You are using MS SQL, right? If you are using a view then you can
set rights as to what the view can do (i.e. select, update, delete)
for a specific user role. It is just a level
