[thelist] SQL not performing all inserts

[Robert Vreeland]

Mystery solved, sort of. The client's machine had a non-US regional setting.
Once we set it to US English it worked fine. It appears as if an internal
Access date time stamp was causing the problem, but we are not sure. In any
event it is working, thanks for the help.

Robert Vreeland

-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Robert Vreeland
Sent: Friday, August 12, 2005 16:49
To: thelist at lists.evolt.org
Subject: [thelist] SQL not performing all inserts

Hello List,
Hope some one will have an idea, so here goes.
I wrote a windows app that migrates the access databases we use in our
application to ms sql databases. We have run the updater on six different
machines - to update ourselves and clients, with no problem. But on our most
recent attempt - another client, only partial success. The application can
connect and read / write from both the access databases and the ms sql
database but only inserts a few record before stopping. I'm not getting any
connection errors, and we have tried the updater locally with a copy of the
clients db with no problems - everything migrates. We duplicated our ms sql
server config options on the client machine - including the query and
connection timeout params, with no apparent difference. Ultimately, I
wouldn't even care if the updater failed as we can do a manual import of the
data, a pain as there are over a hundred databases involved, but the problem
seems to be extending to the application itself, which is relying on at
least one database to store user variable for sharing between asp and
asp.net and that write seems to be failing as well. 
So any suggestions on where I can look for settings that might prevent lots
of inserts? It seems as if something is timing out or blocking the inserts
after x number.
 
Thanks in advance for any help
Robert Vreeland
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester and archives
of thelist go to: http://lists.evolt.org Workers of the Web, evolt !