• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 220
  • Last Modified:

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.

0
rafaelrgl
Asked:
rafaelrgl
4 Solutions
 
UbethatwayCommented:
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
0
 
rafaelrglAuthor Commented:
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.
0
 
UbethatwayCommented:
Can you not use the administration tools that are bundled with the server to connect directly to it to change the permissions?

Mark
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
calinutzCommented:
What componments do you use to connect to the SQL Server? How do you do the insert? Paste some code here and perhaps it would be easyer to understand your problem.

Regards
0
 
Ivanov_GCommented:
try
  // INSERT IN DATABASE
except
  on E: Exception do
    begin
      ShowMessage(E.Message);
    end;
end;

Show us what is the error message. It will give some more information what is the problem
0
 
kenpemCommented:
Isolate SQL first.... fire up a Query Analyser and run insert a row there..... does that work? If YES, there is a problem with the Delphi side of it, dig deeper - Ivanov's error-trapping will give you a good idea what's going wrong.

If the query fails at QA level, you'll at least get a decent error message there to work with.
0
 
rafaelrglAuthor Commented:
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.
0
 
rafaelrglAuthor Commented:
BY THE WAY, I AM USING THIS TO CONECT TO DATABASE:

TDATABASE
TDATASOURCE
TQUERY
TUPDATESQL
0
 
rafaelrglAuthor Commented:
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;
0
 
rafaelrglAuthor Commented:
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?
0
 
rafaelrglAuthor Commented:
I founded, I simply transfer the objects from one server to other. that's works good.

thank you!!!!!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now