Open succesful in Debug but not in .exe

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Manfred - 25 Jan 2007 08:53 GMT

hello,

I've a strange problem:

In the statement :

With cmIL
.ActiveConnection = conDM
.CommandType = adCmdText
.CommandText = sQuery
.CommandTimeout = 24000
rst1.CursorLocation = adUseServer
rst1.CursorType = adOpenForwardOnly
rst1.LockType = adLockReadOnly
rst1.CacheSize = 1000
Set rst1 = .Execute
End With

This statement performs in debugging-modus, but not at runtime. it breaks
always after 10-11 minutes, but I can't see any error in error description.

Any ideas
Manfred

Reply to this Message

Paul Clement - 25 Jan 2007 15:01 GMT

¤ hello,
¤
¤ I've a strange problem:
¤
¤ In the statement :
¤
¤ With cmIL
¤ .ActiveConnection = conDM
¤ .CommandType = adCmdText
¤ .CommandText = sQuery
¤ .CommandTimeout = 24000
¤ rst1.CursorLocation = adUseServer
¤ rst1.CursorType = adOpenForwardOnly
¤ rst1.LockType = adLockReadOnly
¤ rst1.CacheSize = 1000
¤ Set rst1 = .Execute
¤ End With
¤
¤ This statement performs in debugging-modus, but not at runtime. it breaks
¤ always after 10-11 minutes, but I can't see any error in error description.

What do you mean by "breaks"?

Any error messages?

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

Manfred - 29 Jan 2007 08:39 GMT

ello,

"breaks" means, that the execution of the statement stopps and program is
going to the error handler.

When looking for ado-errors or VB err.description, there is said :

"unspecified error".

> ¤ hello,
> ¤
[quoted text clipped - 24 lines]
> ~~~~
> Microsoft MVP (Visual Basic)

Reply to this Message

Paul Clement - 29 Jan 2007 17:48 GMT

¤ ello,
¤
¤ "breaks" means, that the execution of the statement stopps and program is
¤ going to the error handler.
¤
¤ When looking for ado-errors or VB err.description, there is said :
¤
¤ "unspecified error".
¤

Are you using a persistent connection or only opening connections as needed?

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

Manfred - 30 Jan 2007 13:39 GMT

hello,

in this batch, i'm opening a connection once at the beginning and then
reusing it several times. When programm is ending, also the connection is
closed.

> ¤ ello,
> ¤
[quoted text clipped - 11 lines]
> ~~~~
> Microsoft MVP (Visual Basic)

Reply to this Message

Paul Clement - 30 Jan 2007 15:07 GMT

¤ hello,
¤
¤ in this batch, i'm opening a connection once at the beginning and then
¤ reusing it several times. When programm is ending, also the connection is
¤ closed.
¤

You may want to consider opening and closing the connection only when you need it. The longer a
connection remains open the greater the likelihood that it can be dropped in case of a network issue
(I'm assuming your database is on the network).

I would recommend trying this first to see if it resolves the problem.

Paul
~~~~
Microsoft MVP (Visual Basic)

Reply to this Message

VB Forum / Database Access / January 2007

Open succesful in Debug but not in .exe