asked on

I can't insert row in my database on sql server 2000

On my Computer:

I have sql server 2000.
database: nucleo
i'm using the user sa to connect to the server
but when I try to insert a row in my database nucleo, my application close and any row was not insert.

On my online server MSSQL5.EASYCGI.COM

they have sql server 2000
I use other user that i created on them homepage.
database: nucleo.
same tables.

WORKS FINE.WORKS FINE.WORKS FINE.WORKS FINE.WORKS FINE ON ONLINE SERVER.

WHAT HAPPENING WHITH MY SQL SERVER 2000 IN MY COMPUTER.

Ubethatway

Hi, im just taking a stab at this, but could it be that the permissions for the useres differ betwen the two servers?? I havent done a lot with DB server, but from what ive seen with MySQL, theres a lot of different permissions options... could it simply be the user you are using on your home PC doesnt have the correct permissions?? If so, and exceptions havent been handled correctly in your code, this could be the problem.

Just an idea, Mark

rafaelrgl

ASKER

I try to give the high permissions to the user that i am using to connect to my sqlserver, and does not work. I am thinking that i forgot something behind, but I don't know what is it. That my problem and I still have it.

SOLUTION

Ubethatway

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

calinutz

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Ivanov_G

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

kenpem

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rafaelrgl

ASKER

that's is the sentence sql:

//////////////////////////////////////
UPDATE TB_HORAS SET
USADO='17:02',
RESTANTE='16:02',
STATUS='1'
WHERE (MAQ='COMP06') AND
(IDUSUARIO='48') AND
(HORAINI='7/3/2006 7:39:32 PM')
//////////////////////////////////////

That's the error when i try to update this on my server sql 2000 in my computer

//////////////////////////////////////

UPDATE FAILED

//////////////////////////////////////

BUT IF I TRY OTHER SERVER SQL THAT I HAVE ON MY WEB SITE, LIKE MSSQL5.EASYCGI.COM. THAT WORKS OK.

rafaelrgl

ASKER

BY THE WAY, I AM USING THIS TO CONECT TO DATABASE:

TDATABASE
TDATASOURCE
TQUERY
TUPDATESQL

rafaelrgl

ASKER

THAT'S HOW I TRYED:

BD.SQLHoras.ModifySQL.Clear;
BD.DSHoras.DataSet.Edit;
BD.SQLHoras.ModifySQL.Add('UPDATE TB_HORAS SET ');
BD.SQLHoras.ModifySQL.Add(' USADO=''' + tempuso + ''',');
BD.SQLHoras.ModifySQL.Add(' RESTANTE=''' + temprest + ''',');
BD.SQLHoras.ModifySQL.Add(' STATUS=''1''');
BD.SQLHoras.ModifySQL.Add(' WHERE (MAQ=''' + BD.Query_MaqMAQ.Text + ''') AND');
BD.SQLHoras.ModifySQL.Add(' (IDUSUARIO=''' + BD.Query_MaqIDUSUARIO.Text + ''') AND');
BD.SQLHoras.ModifySQL.Add(' (HORAINI=''' + BD.Query_MaqTIMER01.Text + ''')');
BD.Query_Horas.ApplyUpdates;

rafaelrgl

ASKER

I know what happening, I copy my database from this serversql on my website to my server sql on my computer, but I don't know what happening, becouse my fields identity ( ID ) IN ALL TABLES was set to no.
how can I copy my database whithout lost this information in my database?

what I did was:

I make a backup from my server on line.
After that, I restore the backup to my computer.

((((((((WRONG))))))))

HOW IS THE RIGHT WAY TO DO THAT?

rafaelrgl

ASKER

I founded, I simply transfer the objects from one server to other. that's works good.

thank you!!!!!