App gobbling memory

I am using VB6, SP5, ADO 2.7, SQL Server

I have this unusual problem that I will try to explain.

I developed an application that every X seconds polls certain folders to
see if
any files have been placed there. If they have, it reads them and
imports them
into the database.

The application was installed on a Windows 2000 Adv. Server PC, but when
it is executed it starts using more and more memory resources. When it
reaches
400MB it crashes and closes.

My first thought was a memory leak, but when I ran the same program (exe
file)
in the same PC, but from a different source folder in another computer,
the memory
problem did not present itself. I then copied the executable to my PC
and ran
it again. The memory usage went up to 11MB, then gradually went down and
settled at around 2.5MB. The problem only seems to occur when the
executable
is started at the server and the executable file is located on the
server itself.

I am baffled by this behavior. The only difference that I see is that
there is a
INI file at the remote location and there is none on the server. The app
simply
takes default values of the database server and database if this file is
not
found, but I can't find any relation with the presence or lack thereof
of the INI
file and the memory problem.

Any ideas or recommendations are welcomed. Thank you for your time.
Saga

"Saga" <antiSpam@somewhere.com> wrote in message
news:er8kH5cvEHA.1976@TK2MSFTNGP09.phx.gbl...
> I am using VB6, SP5, ADO 2.7, SQL Server
>
> I have this unusual problem that I will try to explain.
>
> I developed an application that every X seconds polls certain folders to
> see if
> any files have been placed there. If they have, it reads them and
> imports them
> into the database.
>
> The application was installed on a Windows 2000 Adv. Server PC, but when
> it is executed it starts using more and more memory resources. When it
> reaches
> 400MB it crashes and closes.
>
> My first thought was a memory leak, but when I ran the same program (exe
> file)
> in the same PC, but from a different source folder in another computer,
> the memory
> problem did not present itself. I then copied the executable to my PC
> and ran
> it again. The memory usage went up to 11MB, then gradually went down and
> settled at around 2.5MB. The problem only seems to occur when the
> executable
> is started at the server and the executable file is located on the
> server itself.
>
> I am baffled by this behavior. The only difference that I see is that
> there is a
> INI file at the remote location and there is none on the server. The app
> simply
> takes default values of the database server and database if this file is
> not
> found, but I can't find any relation with the presence or lack thereof
> of the INI
> file and the memory problem.
>
> Any ideas or recommendations are welcomed. Thank you for your time.
> Saga
>
>
>

How are you importing the files into the database.  Using ADO into BLOBs?
Double check to make sure you are closing and unreferencing the recordsets.

Also are you 100% sure that the same version of MDAC is loaded on all of the
machines your testing with?  You might want to attempt doing a clean OS load
(preferably Win2000 Adv. Server) on a test box, then load 2.7 and test your
application.  If there is no problem, see if updating MDAC on the problem
server fixes your issue.  If there is a problem try updating to 2.8 and see
if your problem goes away.

Finally also try copying that INI on the server.  Maybe your defaults aren't
set "exactly" the same.

How can I tell what version of ADO is installed? WIthout using the VB
IDE.

Also, a file was detected in the temp folder that I use to store the
files that
I am going to import. Apparently, my import routine was (and still is)
choking on that file. I will do more testing.

Thank you for your reply, I believe that I do need to determine what
version of ADO is installed on the server.

Saga


"Paul Bobrowski" <nospam@msdiscussion.com> wrote in message
news:e8rD5vdvEHA.3080@TK2MSFTNGP12.phx.gbl...
> "Saga" <antiSpam@somewhere.com> wrote in message
> news:er8kH5cvEHA.1976@TK2MSFTNGP09.phx.gbl... 
>
> How are you importing the files into the database.  Using ADO into
> BLOBs?
> Double check to make sure you are closing and unreferencing the
> recordsets.
>
> Also are you 100% sure that the same version of MDAC is loaded on all
> of the
> machines your testing with?  You might want to attempt doing a clean
> OS load
> (preferably Win2000 Adv. Server) on a test box, then load 2.7 and test
> your
> application.  If there is no problem, see if updating MDAC on the
> problem
> server fixes your issue.  If there is a problem try updating to 2.8
> and see
> if your problem goes away.
>
> Finally also try copying that INI on the server.  Maybe your defaults
> aren't
> set "exactly" the same.
>
>