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_CONNECT(3)														 SYBASE_CONNECT(3)

sybase_connect - Opens a Sybase server connection

SYNOPSIS
resource sybase_connect ([string $servername], [string $username], [string $password], [string $charset], [string $appname], [bool $new = false]) DESCRIPTION
sybase_connect(3) establishes a connection to a Sybase server. In case a second call is made to sybase_connect(3) with the same arguments, no new link will be established, but instead, the link identi- fier of the already opened link will be returned. The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling sybase_close(3). 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. o $new - Whether to open a new connection or use the existing one. RETURN VALUES
Returns a positive Sybase link identifier on success, or FALSE on failure. CHANGELOG
+--------+------------------------------------+ |Version | | | | | | | Description | | | | +--------+------------------------------------+ | 5.3.0 | | | | | | | The $new parameter was added. | | | | | 4.2.0 | | | | | | | The $appname parameter was added. | | | | | 4.0.2 | | | | | | | The $charset parameter was added. | | | | +--------+------------------------------------+ EXAMPLES
Example #1 sybase_connect(3) example <?php $link = sybase_connect('SYBASE', '', '') or die("Could not connect !"); echo "Connected successfully"; sybase_close($link); ?> SEE ALSO
sybase_pconnect(3), sybase_close(3). PHP Documentation Group SYBASE_CONNECT(3)
All times are GMT -4. The time now is 06:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy