ExecuteNonQuery - problem

  • Thread starter Thread starter b_r
  • Start date Start date
Also, did you try closing your connection, then
re-opening it and re-querying your database for that
record you think you just added? If this works,
and it finds it, then you are indeed using a different
database from the one you think you are using.

If it doesn't work, it's a different problem.

Robin S.
------------------------------
 
Stephany,
yes, the database is in the same directoy as the executable.

Robin,
yes I tried as you suggest and after reopening the record is not found.


Your suspicion is that there is another database... but in this
situation additional database should have the same structure like
database dedicated for the project (there is no error during insert
isnruction execution)... so how it is possible that identical database
is created, automatically or any other way???

The best way to verify my project is the possiblity to send files to
someone who has the same environment (VB2005 Eexpress, SQL Express) and
run it.

RobinS napisa³(a):
 
Okay, I looked at this guy's code. It works with VS2005 and SQLServer.
So I think
it's a problem with his SQLServerExpress setup. Could the problem be
caused
by not having remote connections enabled or not having update access to
the
database or something like that? Would not having remote connections
enabled
also keep him from reading the database (I think so) ?

I've sent him back some code to try that will do what I recommended just
to
try it (with closing/opening connection and re-reading). If that
displays the
fact that the record is, in fact, not being added to the database
(which, I
suspect is the case), then it's a problem with his connection or his
database
or something like that.

Other opinions are welcome.

Robin S.
------------------------
 
Back
Top