Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

connect SQLCA

2 posts in Appeon (partner product) Last posting was on 2006-07-26 08:46:31.0Z
Clark Posted on 2006-07-24 22:20:57.0Z
Sender: 65a1.44c5453b.1804289383@sybase.com
From: Clark
Newsgroups: sybase.public.appeon
Subject: connect SQLCA
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <44c545ff.65ac.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 24 Jul 2006 15:13:19 -0700, 10.22.241.42
Lines: 24
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Jul 2006 15:13:22 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Jul 2006 15:20:57 -0700
X-Trace: forums-1-dub 1153779657 10.22.108.75 (24 Jul 2006 15:20:57 -0700)
X-Original-Trace: 24 Jul 2006 15:20:57 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1510
Article PK: 21229

Hi...!!

I'm deploying an app to appeon, this application uses n_tr
transaction object to connect.
When running, browser show a message error
MessageBox('ERROR','NO EXISTE CONEXION A LA BASE DE DATOS')

This code is

SQLCA.DBMS = 'O84 Oracle8/8i (8.x.4+)'
SQLCA.LogPass = 'CONSULTA'
SQLCA.LogId = 'CONSULTA'
SQLCA.ServerName = 'ORACLE'
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
SQLCA.of_connect()
IF SQLCA.SQLCode =0 THEN
open(w_logueo)
ELSE
MessageBox('ERROR','NO EXISTE CONEXION A LA BASE DE DATOS')
END IF


please help me!!


Sally Li Posted on 2006-07-26 08:46:31.0Z
From: "Sally Li" <sally.li@appeon.com>
Newsgroups: sybase.public.appeon
References: <44c545ff.65ac.1681692777@sybase.com>
Subject: Re: connect SQLCA
Lines: 53
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 59.37.60.2
X-Original-NNTP-Posting-Host: 59.37.60.2
Message-ID: <44c72be7@forums-1-dub>
Date: 26 Jul 2006 01:46:31 -0700
X-Trace: forums-1-dub 1153903591 59.37.60.2 (26 Jul 2006 01:46:31 -0700)
X-Original-Trace: 26 Jul 2006 01:46:31 -0700, 59.37.60.2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:1511
Article PK: 21230

Hi,

Please try the following steps to solve the problem you met.

Step1 : Open EAServer Manager to confirm if the connection cache can be
pinged successfully.

Step2 : If the connection cache is pinged successfully, please open AEM and
confirm if the "sqlca" transaction object have been set for your app in
"Transaction Object" page. Because SQLCA is necessary for all applications.

Step3 : If it is OK to above 2 steps, I suggest you to replace
"SQLCA.of_connect()" to "connect;" and redeploy application again.

If the error still exists, please check the configurations for
connection.There must be something wrong on the settings related to
connection.

If the error does not exist, please check the code in of_connect()
function.You also can provide this function and test case to us, we will
help you to solve the problem.

Regards
Sally.Li

<Clark> wrote in message news:44c545ff.65ac.1681692777@sybase.com...
> Hi...!!
>
> I'm deploying an app to appeon, this application uses n_tr
> transaction object to connect.
> When running, browser show a message error
> MessageBox('ERROR','NO EXISTE CONEXION A LA BASE DE DATOS')
>
> This code is
>
> SQLCA.DBMS = 'O84 Oracle8/8i (8.x.4+)'
> SQLCA.LogPass = 'CONSULTA'
> SQLCA.LogId = 'CONSULTA'
> SQLCA.ServerName = 'ORACLE'
> SQLCA.AutoCommit = False
> SQLCA.DBParm = ""
> SQLCA.of_connect()
> IF SQLCA.SQLCode =0 THEN
> open(w_logueo)
> ELSE
> MessageBox('ERROR','NO EXISTE CONEXION A LA BASE DE DATOS')
> END IF
>
>
> please help me!!