Solved

How to test the sybase connection.

Posted on 2008-10-10
4
2,951 Views
Last Modified: 2012-05-05
Hai !
       we are pulling the data from a sybase remote machine.
Before extracting i need to test the sybase connection status. How to do this ?

How can we determine that the connection failed (sybase database down) ?
0
Comment
Question by:vishali_vishu
4 Comments
 
LVL 2

Expert Comment

by:navid86
ID: 22690737
If I understand the question properly, you need to check the ODBC connection.  This is under the control panel in Windows XP.  Control Planel > Administrative Tools > Data Sources (ODBC).

Under user DSN or system DSN you should see your ODBC connection.  Highlight your connection then click Configure.  At the bottom of the Configure screen there is a Test Connection button.  You can click that to test your connection.

Hope this helps!
0
 
LVL 19

Accepted Solution

by:
grant300 earned 500 total points
ID: 22690844
I am betting that you are doing the data pull automatically in some kind of script and want to put a check of the Sybase connection into the process so you can tell what is wrong.  Since you specify Unix, I figure there is no ODBC.  That's O.K.; it actually makes things easier.

Since you are on a Unix/Linux platform, you will have the Sybase Client Library (CT-lib) and it's associated components installed.  On Windows machines there is a utility called "sybping" for testing connections but there is no equivalent on Linux or Unix.  The script below will do roughly the same thing using ISQL and some shell commands to determine success or failure.  I believe this was posted somewhere by Michael Peppler, a well know Sybase guru.  It looks like it might be a little rough yet.

Regards,
Bill



#!/bin/sh
 
srv=$1
logfile=/tmp/sybping.$$
isql -Usa -PTryItNow -S$srv >$logfile 2>&1
 
# ASE
grep 'Login failed' $logfile >/dev/null
if [ $? -eq 0 ]
then
echo "Server $srv is up"
exit 0
fi
 
# Generic message when connection fails.
grep "connect two endpoints failed" $logfile >/dev/null
if [ $? -eq 0 ]
then
echo "Server $srv is unreachable"
exit 1
fi
 
echo "Unknown sybping error:"
cat $logfile
exit -1

Open in new window

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Developer 6 75
Creation date for a PDB 5 62
sql server store procedure contains temp tables need to convert oracle? 3 35
Oracle performance tuning 2 15
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question