Re: problem connecting to db.

On Dec 27, 5:26 am, "Mr. X." <no_spam_please_at_nospam_please.com> wrote:
> Hello,
> In my VB 6.0 code, I have tried to connect to oracle-database,
> but program just hang (even there is no exception !!!)
> Code is :
>
> In alert.log there is a massage (it sometimes occurs when the above hang,
> but not always when the program hangs) :
> SMON: Parallel transaction recovery tried
>
> The code in brief:
> --------------------
>
> Public OraCon As New ADODB.Connection
> Public mainConnectionStr As String
> ...
>
> public sub connectToDB
>   On Error GoTo connectToDB_err
>   mainConnectionStr = ...
>   OraCon.ConnectionString = mainConnectionStr
>   Call OraCon.Open ' ***** here programs hang sometimes ******
>                                 ' ***** also, when hang - not always there
> is a line on alert.log, but sometimes there is. ******
>   goto end_proc
> connectToDB_err:
> ' ****** when the above error, this code is never reachable *******
>   msgBox "" & err.number & "," & err.description
> end_proc:
> end sub
>
> What may be the cause for the above problem ?
>
> Thanks :)

You'll need to post the connection string details and the Oracle release (all four numbers) before anyone can assist you. What you've posted is of little use in diagnosing your problem.

David Fitzjarrell Received on Thu Dec 27 2007 - 08:12:23 CST