08-04-2006
Connect From VB to Sybase
Dear All
Now I can't connect from VB to Sybase on Unix. How could I do?
Please help me.
Last edited by Than Chanroeun; 08-11-2006 at 07:59 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Discussion started by: Dird
8 Replies
2. Shell Programming and Scripting
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script. Kindly let me know on how to do this
Thanks,
Ananthi.U (1 Reply)
Discussion started by: ananthi_ku
1 Replies
3. Solaris
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
Kindly let me know on how to do this
Thanks,
Double post. Continue here (0 Replies)
Discussion started by: amitbhelave
0 Replies
4. Shell Programming and Scripting
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
I am using solaris-5.1 to run shell script and want to connect to SQL-5.1 which is installed on SantOS.
Kindly let... (3 Replies)
Discussion started by: amitbhelave
3 Replies
5. Emergency UNIX and Linux Support
Hi All
Can any one please help me about
How to connect Unix with Sql Server 2005
I want to do it urgently and i didn't find the way. (14 Replies)
Discussion started by: parthmittal2007
14 Replies
6. Shell Programming and Scripting
I am trying to connect to SQL plus through unix but i am getting below error
'ksh: sqlplus: not found'
note i am running this from /home/xxx
do i need to set any environmental variable for this. below is my code
echo " hello world"
sqlplus -s apps/CAF78GEN<<EOF
set heading... (4 Replies)
Discussion started by: karnatis
4 Replies
7. Shell Programming and Scripting
I need to connect sql server 2008 from korn shell script. Can you please give me the script which connects sql server 2008 from korn shell script. (2 Replies)
Discussion started by: santoshhegde
2 Replies
8. SuSE
I am trying to establish connection with SQL server 2008 through ODBC on Linux. First step would be
1. How to verify if ODBC driver for SQL server is installed on Linux OS.
PLease let me know how to do it/ if there is any link which could be helpful in this context.
thanks in advance (1 Reply)
Discussion started by: cvsanthosh
1 Replies
9. AIX
Hello aix community,
After scouring the internet to find a step by step process, I've exhausted my efforts. Although I have learned a lot which brings me to this forum. I'm totally new and hope to ask the right questions.
What is the easiest way to connect to a SQL server from aix?
... (2 Replies)
Discussion started by: TechStudent36
2 Replies
10. AIX
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)
Discussion started by: MadhuSeven
1 Replies
LEARN ABOUT PHP
sybase_connect
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)