i tried the above solution, still get the same error.
Code:
#!/usr/bin/bash
LD_LIBRARY_PATH="/usr/sybase/ASE-12_5/lib:$LD_LIBRARY_PATH"
SYBASE="/usr/sybase:$SYBASE"
/path/to/dir/isql -Uuser -Ppwd -SFOO <<EOF
use db
go
select count(something) from some_table
go
EOF
error :
Code:
Msg 4002, Level 14, State 1:
Server 'FOO':
Login failed.
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
Hi all,
I am trying to connect to a remote sybase database server (sitting on windows) from my freebsd apache webserver.
My Webserver has installed;
Apache2.0
PHP 4.3.8
Freetds with ODBC enables ( tsql works but isql doesnt )
unixODBC
syabse-ocsd
When i connect with tsql from... (4 Replies)
Hi,
Can anyone please give me a script or let me know how to connect to a sybase database and execute a query using Korn shell scripts.Am new to Unix but i need to do this ASAP.
Please help.
Thanks,
Gops (7 Replies)
Hi All,
I was able to connect to sybase in shell script and also able to run few sql queries, something like this,
#!/usr/bin/ksh -x
temp=`echo "select name from sysobjects where type = 'U'"`
results=`isql -SDS_SERVER-UAdhocUser -Pha12 <<EOF
set rowcount 6
$temp
go
EOF`
line_count=0... (1 Reply)
Hi All,
This is my first post. Need your favour guys.
I need to authenticate syabse login/password thru shell script.
I am getting the ID & Pwd form user and storing it in variable..
But how to authenticate and echo user back if the id/pwd doesnt work.
isql -U$1 -P$2 -S$3 ??
thanks in... (3 Replies)
Greetings,
I need to capture the output of a Sybase stored procedure, inside my
shell script( k shell). Based on this output, I need to call another
perl script, with input arguments as the result set of the procedure
execution. I need to keep looping through and call the perl script, ... (2 Replies)
Hi,
I need to check the sysbase database connectivity through the Unix Shell Script. Can you help me on the how to write the script to test the sysbase database connection.
Thanks in Advance
Nandha (0 Replies)
hi,
I'm setting up a home lab and I am having problems keeping my connection open on putty. every time i leave it for about 10 seconds and come back I keep having to re-connect. I'm more of a AIX person and trying to get more fimilar with Sun but some of the commands I am trying to run to diag... (2 Replies)
Hi, I am new to advanced scripting.
I need to get top 20 records from database (Sybase) with a condition that all Char/varchar columns should have more than 4 characters.
I need to do this via shell scripting, I have got half logic (on how to get varchar/char columns and stored it in a... (2 Replies)
Discussion started by: Selva_2507
2 Replies
LEARN ABOUT SUSE
lint
lint(1B) SunOS/BSD Compatibility Package Commands lint(1B)NAME
lint - C program verifier
SYNOPSIS
/usr/ucb/lint [options]
DESCRIPTION
/usr/ucb/lint is the interface to the BSD Compatibility Package C program verifier. It is a script that looks for the link
/usr/ccs/bin/ucblint to the C program verifier. /usr/ccs/bin/ucblint is available only with the SPROcc package, whose default location is
/opt/SUNWspro. /usr/ucb/lint is identical to /usr/ccs/bin/ucblint, except that BSD headers are used and BSD libraries are linked before
base libraries. The /opt/SUNWspro/man/man1/lint.1 man page is available only with the SPROcc package.
OPTIONS
/usr/ucb/lint accepts the same options as /usr/ccs/bin/ucblint, with the following exceptions:
-Idir Search dir for included files whose names do not begin with a slash (/) prior to searching the usual directories. The
directories for multiple -I options are searched in the order specified. The preprocessor first searches for #include files
in the directory containing sourcefile, and then in directories named with -I options (if any), then /usr/ucbinclude, and
finally, in /usr/include.
-Ldir Add dir to the list of directories searched for libraries by /usr/ccs/bin/ucblint. This option is passed to
/usr/ccs/bin/ld. Directories specified with this option are searched before /usr/ucblib and /usr/lib.
-Y P, dir Change the default directory used for finding libraries.
EXIT STATUS
The following exit values are returned:
0 Successful completion.
>0 An error occurred.
FILES
/usr/lint/bin/ld link editor
/usr/lib/libc C library
/usr/ucbinclude BSD Compatibility directory for header files
/usr/ucblib BSD Compatibility directory for libraries
/usr/ucblib/libucb BSD Compatibility C library
/usr/lib/libsocket library containing socket routines
/usr/lib/libnsl library containing network functions
/usr/lib/libelf library containing routines to process ELF object files
/usr/lib/libaio library containing asynchronous I/O routines
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWscpu |
+-----------------------------+-----------------------------+
SEE ALSO ld(1), a.out(4), attributes(5)SunOS 5.10 1 Feb 1995 lint(1B)