Checking the status oracle connection PB9.0 Oracle 9i(9.2.0.50) Lost connection problem (LAN and WAN)

Cheers to all.

We want to know if there is a way to get the status of the connection with 
oracle databse (online way), we use native driver for

Oracle9i. Some times we get some lan and wan problems that produce small 
lost connection in seconds, but we dont any action that describe the success 
problem.


we need to put some code in the application that help us to know the exactly 
moment when these happen to

take some decision something loke a monitor tool.

we appreciate any suggestions.

Thanks in advance

Eduardo Primera
from: Venezuela 


0
Eduardo
5/8/2007 8:22:43 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

0 Replies
1123 Views

Similar Articles

[PageSpeed] 10

Reply:

Similar Artilces:

Does ODAC 9.2.0.7.0 work with Oracle database version 9i 9.2.0.6.0 using VS2005?
I am using VS2005 and need to connect to an Oracle database. The Oracle database version is Oracle 9i 9.2.0.6.0 I have taken a look at the Oracle site (http://www.oracle.com/technology/software/tech/windows/odpnet/index.html). I can download the Oracle Data Access Component - Oracle9i Release 2 ODAC 9.2.0.7.0, but will this work with our current Oracle database version 9i 9.2.0.6.0 ? Any help appreciated. Regards, Paul. Apsolutely.Install it, it will work w/o problems. Regards,Dejan VesićMCAD for .Net technologies | http://www.vesic.org/english/ | Blog: http://www.vesic.org...

Problem connecting to oracle database in powerbuilder 9.0 desktop version
I am not able to connect to oracle database using odbc in powerbuilder 9.0 desktop version.I am getting error message which says 'Inavlid or unsupported datasource' Ershad, Have you verified that you have the required Oracle ODBC drivers? The latest set of drivers is available at: http://www.oracle.com/technology/software/tech/windows/odbc/index.html\ Could you also please post the attributes of the transaction object (except the password) that you use to try and connect to the oracle db? Sanjiv. <Ershad Ali Mohammad> wrote in message news:41aea458.51d5...

Error: Database connection PB8.0.2 & Oracle 9.2
Hi, In PB 8.0.2 development environment, I am getting the following error when I try to connect to Oracle 9.2.0.4 database using native connection (PB9080.DLL)? 'Oracle Library OCI.DLL could not be loaded' Any idea what's missing here? Thanks, Mahesh The Oracle client layer. Mahesh wrote: > > Hi, > > In PB 8.0.2 development environment, I am getting the > following error when I try to connect to Oracle 9.2.0.4 > database using native connection (PB9080.DLL)? > 'Oracle Library OCI.DLL could not be loaded' > Any idea what'...

PowerBuilder 9.0.2 native Oracle driver for Oracle 10g database
We are migrating from Oracle 8i to 10g. The PowerBuilder 9.0.2 application is extremely slow using PowerBuilder Oracle 8.4 or 9.0 native driver to connect to Oracle 10g database, We had to use 7.3 driver. After using trace we found that the SQL scripts with index hint cause slow down, but they are working ok using Oracle 8.4 driver with Oracle 8i database. Any suggestion which is best way to connect from PowerBuilder 9.0.2 to Oracle 10g database? We have tried the Oracle 8.1.7 client and Oracle 9.0 client. I found a solved case on Sybase support web site, but we do not have support...

PB Version to connect to Oracle Client 9.2.0.6.0
Does PB 8.0 can work ok connected to Oracle Client 9.2.0.6.0? Which build do I need? There was a document in Sybase site but I can=b4t find it. Thanks in advance It's still available in the Google cache: http://tinyurl.com/ckbow Doug Porter DailyAccess Corporation <Marcelo Dias> wrote in message news:43bbb05c.5fea.1681692777@sybase.com... Does PB 8.0 can work ok connected to Oracle Client 9.2.0.6.0? Which build do I need? There was a document in Sybase site but I can�t find it. Thanks in advance ...

Oracle 8.0/Oracle 7.1.4 & PB 5.0 connection problem
I am using native database interfaces 7.2 to connect with the Oracle database 7.1.4 (UNIX) from PB 5.0(windows 95), it works well. But after I installled Personal Oracle8 on my desktop, everytime it goes to the local oracle 8 database(oracle8 database autobatically starts ) with the same profile, not the remote 7.1.4. I tried to use Oracle Home Selector to switch the oracle home to 7.1.4, nothing happened, Oracle home stayed at Oracle 8. Is there any way that can let me specify the database? Thanks What are you using as your servername string? Is your tnsnames.ora file still corr...

Make error: DBD-Oracle-1.14 , DBI-1.39, Oracle rdbms 9.2.0.0.0 , solaris 9
------=_NextPart_000_0025_01C3BE5A.4F6A0C70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, When I make DBD-Oracle 1.14 , Makefile.PL generates a Makefile with "-o build" in the compiler string before blib/arch/auto/DBD/Oracle/Oracle.so and prevents Oracle.so from being built correctly. demo_rdbms.mk appears to be to supplying this: Attempting to discover Oracle OCI build rules^M gcc -B/usr/ccs/bin/ -c DBD_ORA_OBJ.c^M by executing: (make -f /export/home/oracle/ora9idbms/rdbms/demo/demo_rdbms.mk bu ild ECHODO=echo EC...

install_driver(Oracle) failed while connecting to oracle 10.2.0.2
------_=_NextPart_001_01C754F1.5B924345 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable HI Could u pls help on this issue. =20 Presently we are using the following versions=20 =20 Perl version -------- perl, v5.6.1 built for sun4-solaris DBD::ORACLE --------- 1.15 DBI version ---------- 1.28 ORACLE -------- oracle 10.2.0.2 =20 =20 =20 THE BELOW CODE WAS WORKING FINE WITH ORACLE 9.2.0.8 =20 =20 =20 use DBI; print "hi"; =20 print "\n"; =...

DBD::Oracle for Oracle 9i versoin 9.2.0 (64 bit Oracle)
I am unable to compile/build DBD::Oracle with Oracle 9i (64-bit Oracle RDBMS) library. Could someone please help? Thanks. regards surjit This message contains information from Equifax Inc. which may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify by e-mail postmaster@equifax.com. On Thu, Jul 22, 2004 at 05:14:03PM -0400, Surjit.Sahoo@equifax.com wrote: ...

Connection Problem using ADOConnection to Oracle 10g Express Edition Release 10.2.0.1.0
Hello, I am using Delphi 2007 with the ADOConnection and ADOQuery objects to read and write data to an Oracle 10g Express Edition Release 10.2.0.1.0 database. Reading and writing all goes fine when running from the IDE. On a random basis however, when the ADO connection is first attempted to the remote Oracle server, the IDE will stop (event though no break points were assigned) at the following location: ntdll.DbgBreakPoint: 77337DFE CC int 3 --> 77337DFF C3 ret ntdll.RtlInitString: 77337E00 57 push...

EAServer 5.3.0, Oracle 8.1.7 Database with Oracle 10.1.0.2 client VARCHAR2(4000) problem
Hello! I'm having some problems in this configuration on Windows XP. I am developing websites on an Oracle database (8.1.7), with EAServer 5.3.0 (build 53016), Java objects using JSP as a front end. Here is my problem, I have a table with 2 VARCHAR2(4000), and when I access the webpage, the they are displayed as '?????????????'. If I debug the PB component, when I affect the DW field to a variable, it displays it as it doesn't "understand" a thing (each character is replaced by a square). The codeset of EAServer is UTF8, and on my client, it is AM...

Problems connecting ASA 9.0.0 on SuSE 9.0
Hi, I found several threads about this, but it's still not running :-( What's working: - all IP-connections are OK with IP-address and host-name - the db-server is starting: I. 03/28 00:36:31. Database server started at Sun Mar 28 2004 00:36 I. 03/28 00:36:31. Trying to start SharedMemory link ... I. 03/28 00:36:31. SharedMemory link started successfully I. 03/28 00:36:31. Trying to start TCPIP link ... I. 03/28 00:36:31. Starting TCP listener on IP address 0.0.0.0:2638 I. 03/28 00:36:31. Starting on port 2638 I. 03/28 00:36:31. Looking for serve...

PB803/PB9 and offical support oracle 9.2.0.2.0
Hello, 1) is Sybase offical supporting Oracle 9.2.0.2.0 with PB 8.0.3 and/or PB 9.0 2) are there know problems with PB and Oracle 9.2 ... (till now we use PB 8.0.3 with 9.0.1) TIA Heino Hellmers Leader Engineering S&F Datentechnik, Germany Officially 9.2 is not supported. But it does work. http://www.sybase.com/detail?id=1011566 -- Terry Dykstra (TeamSybase) http://powerbuilder.codeXchange.sybase.com/ http://www.pb9books.com product enhancement requests: http://www.isug.com/cgi-bin/ISUG2/submit_enhancement "Heino Hellmers" <heino@hellmers...

RE: install_driver(Oracle) failed while connecting to oracle 10.2.0.2
------_=_NextPart_001_01C7551C.302725D3 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Philip We have Changed the permissions . Even after that, I am getting the following error as =20 =20 install_driver(Oracle) failed: Can't load '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBD/Oracle/Oracl e.so' for module DBD::Oracle: ld.so.1: perl: fatal: libclntsh.so.9.0: open failed: No such file or directory at /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206. at (eval 1) l...

Web resources about - Checking the status oracle connection PB9.0 Oracle 9i(9.2.0.50) Lost connection problem (LAN and WAN) - sybase.powerbuilder.database

Connection - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

iMedia Connection: Interactive Marketing News, Features, Podcasts and Video - iMediaConnection.com
High-quality data, if not used properly, can still lead marketers to make bad decisions. Consider these common ways that numbers are used to ...

HTTP persistent connection - Wikipedia, the free encyclopedia
... tacked on to an existing protocol. If the browser supports keep-alive, it adds an additional header to the request: Following this, the connection ...

CareerSonar Turns Facebook Friends Into Job Connections
Looking for a job ? Among your Facebook friends lies the potential for employment. CareerSonar , a new service, brings together a person’s connections ...

Kings Cross identities arrested in connection with murder
Two Kings Cross identities&nbsp;have been arrested in connection with the murder of a man at Sydney hotel.

Faith: Spirits lift in connection with home
We need to more adequately understand the spirituality of our unique place on earth.

Governor declares state of emergency in connection with California methane leak
... of Emergency Services) On Wednesday evening, California Governor Jerry Brown declared a state of emergency in Los Angeles County in connection ...

Tons Of Methane Are Spewing Out Of California, And There’s A Connection To The Governor
The out of control leak has forced thousands of residents to flee their homes. Gov. Brown's sister is a paid board member at the company that ...

Report: Man arrested in connection with Ashley Olsen's murder
Italian media agency reports that a non-EU male has been arrested in the murder of the 35-year-old American

Toyota and Kymeta rely on satellites to power this Mirai's data connection
They're hoping to achieve gigabit wireless speeds within the next few years.

Resources last updated: 1/16/2016 6:16:17 PM