Sponsored Content
Full Discussion: Sybase 12/15 compatability
Top Forums Shell Programming and Scripting Sybase 12/15 compatability Post 302472769 by JerryHone on Thursday 18th of November 2010 04:30:41 AM
Old 11-18-2010
Sybase 12/15 compatability

This is more a database problem than a shell one, but we have a problem affecting our scripts, so I'm stretching the limits a bit! Smilie

We're in the process of migrating our application and a large number of associated scripts from Sybase 12.5.4 to Sybase 15. Scripts using 'isql' and 'bcp' include the -X option that ensures that database passwords are sent encrypted. This works without an issue between a Sybase 12 client and server, and also with no problem between a S12 client and S15 server, and also it seems between an S15 client and S12 server. However, we get a failure to connect when using S15 at both ends. Removing the -X option sorts our problem.

So what I'd like to understand is what's going on with S15 both ends, and why the -X option is causing a failure
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Hardware compatability

One thing I am learning is that it is hard to find hardware that is compatiple with unix (correct me if I am wrong). I have now installed Corel's version of Linux. How do you know when a piece of hardware (e.g. network card) is or is not working in Unix. I go to the Control centre and see... (1 Reply)
Discussion started by: cantcatchme
1 Replies

2. UNIX for Dummies Questions & Answers

Laptop Compatability

I would like to know if anybody has had success loading Solaris 8 onto a laptop? If so, what was the make and the model:confused: (5 Replies)
Discussion started by: bilal_aa
5 Replies

3. Linux

Mandrake Compatability

I was just woundering, is mandrake compatible with AMD Athlon processors? I think I have AMD Athlon 2400 XP (5 Replies)
Discussion started by: Kimm
5 Replies

4. Solaris

Connect From VB to Sybase 11

Dear All I have a problem that I can't connect from VB to Sybase 11. Could you help me? (2 Replies)
Discussion started by: Than Chanroeun
2 Replies

5. Shell Programming and Scripting

sybase and shell

I am writing a shell script that verifies if a device is created on wrong mounts 1> sp_helpdevice 2> go | awk '{print $2}' | grep database | grep -v `df -k | grep /dev/dsk | awk '{print $6}'` So if things are ok, the output should return nothing If the result gives 1 or more entry, then... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies

6. Shell Programming and Scripting

Connecting to Sybase from autosys

Hi, Kindly help in how to connect Autosys to sybase or oracle database. am new to autosys. please help me. Thank you..! (0 Replies)
Discussion started by: babulal
0 Replies

7. Shell Programming and Scripting

sybase::bcp

I am trying to bcp in using sybase::bcp perl module. I can find we can give user, pwd and server name in the parameters. How can I give database and table name? (1 Reply)
Discussion started by: Deei
1 Replies

8. Shell Programming and Scripting

Sybase server

I have requirement to connect to different sybase server's and store the data into flat file and load into oracle using sqlloader for each day drop the table and re create it and load the data based on business date as parameter which was taking from parameter file.Any help on this should be... (0 Replies)
Discussion started by: mohan705
0 Replies

9. Emergency UNIX and Linux Support

Help with Sybase DB

Hi, I'm facing an emergency situation, wherein I have to provide limited support to a Sybase DB temporarily as the DBA was fired. There is an urgent need of adding to users to the database. After some time on google, I was able to gather the below information on the database setup ... (1 Reply)
Discussion started by: maverick_here
1 Replies
SYBASE_PCONNECT(3)														SYBASE_PCONNECT(3)

sybase_pconnect - Open persistent Sybase connection

SYNOPSIS
resource sybase_pconnect ([string $servername], [string $username], [string $password], [string $charset], [string $appname]) DESCRIPTION
sybase_pconnect(3) acts very much like sybase_connect(3) with two major differences. First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection. Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (sybase_close(3) will not close links established by sybase_pconnect(3)). This type of links is therefore called 'persistent'. PARAMETERS
o $servername - The servername argument has to be a valid servername that is defined in the 'interfaces' file. o $username - Sybase user name o $password - Password associated with $username. o $charset - Specifies the charset for the connection o $appname - Specifies an appname for the Sybase connection. This allow you to make separate connections in the same script to the same data- base. This may come handy when you have started a transaction in your current connection, and you need to be able to do a separate query which cannot be performed inside this transaction. RETURN VALUES
Returns a positive Sybase persistent link identifier on success, or FALSE on error. SEE ALSO
sybase_connect(3). PHP Documentation Group SYBASE_PCONNECT(3)
All times are GMT -4. The time now is 09:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy