Visit Our UNIX and Linux User Community


Establish ODBC connection from Linux


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Establish ODBC connection from Linux
# 1  
Old 01-31-2014
Establish ODBC connection from Linux

Hi All,

I want to establish a ODBC connection to a database from linux and query the tables of a database.

Please let me know how I can achieve this.

Thanks and Regards
Nagaraja Akkivalli.

Previous Thread | Next Thread
Test Your Knowledge in Computers #939
Difficulty: Easy
The author named the ping utility after the sound that a sonar makes.
True or False?

9 More Discussions You Might Find Interesting

1. AIX

Unable to establish connection over TLS 1.2 on AIX 7.1/7.2

Hello Team, I would need your help to enable communication over TLS1.2 on AIX 7.1 or 7.2 with IBM JDK 1.8 latest update. By default, the request is trying to establish a connection over TLSv1 even though TLS 1.2 is explicitly enabled on server as well as on Java 8. The openssl command throws... (4 Replies)
Discussion started by: Naina2019
4 Replies

2. BSD

Can't establish outbound ssh connection on an OpenBSD system

I am getting the below error when I try to make outbound ssh from an OpenBSD system. I can't ssh to any host except the localhost. I can ping the hosts which I can't ssh, though.~ uname -rs OpenBSD 6.1 ~ ssh -V OpenSSH_7.5, LibreSSL 2.5.2 ~ ssh hostname ssh: connect to host hostname... (11 Replies)
Discussion started by: milhan
11 Replies

3. Red Hat

Proxy tunneling failed: ForbiddenUnable to establish SSL connection.

Tryied both ways curl and wget wget --no-check-certificate https://mysitet.it:61617 --2017-05-05 17:29:02-- https://mysitet.it:61617/ Connecting to myproxy:8080... connected. Proxy tunneling failed: ForbiddenUnable to establish SSL connection. curl https://mysite.it:61617 curl: (56)... (3 Replies)
Discussion started by: charli1
3 Replies

4. Red Hat

Connection establish two server

How do make connection between two linux server.Such as SSH,rsync,ftp (3 Replies)
Discussion started by: Mani T
3 Replies

5. Shell Programming and Scripting

Cron job fails with [DataDirect][ODBC lib] Connection not open error

Hi, When run the script directly...it executes as expected. But when put it in crontab the job fails with this error: Connection not open 08003: Connection not open Unable to connect to the database... how come it is not able to connect when cron job fires?... Do I need to... (7 Replies)
Discussion started by: nuthakki
7 Replies

6. Linux

Unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0

Hi , I am unable to setup ODBC connection in RHEL5 64 bit and MySql 5.0 I had modified ODBC.ini file , set the env variables such as LD_LIBRARY_PATH, ODBCINI , ODBCSYSINI etc . Getting the error as Data source name not found, and no default driver specified ERROR: Could not SQLConnect ... (0 Replies)
Discussion started by: roopalidalvi231
0 Replies

7. HP-UX

Xterm :Cannot establish a connection to "Server IP" on port 22

Dears, I installed HP-UX Server, when I tried to reach it through Xterm it returns the error like Xrcmd Cannot establish a connection to "Server IP" on port 22 Anyone here to tell me the reason(s) find attached xterm.jpg (3 Replies)
Discussion started by: smartyshan
3 Replies

8. Windows & DOS: Issues & Discussions

Oracle 9i ODBC connection

I am attempting to access an Oracle 9i database located on a Solaris server from an XP client. The server is running Oracle 9i9.2.0.1.0 and the XP is Oracle client 9i 9.2.0.1.0. When I start a listener on the server, the listener starts but I receive a message “The listener supports no services”. I... (3 Replies)
Discussion started by: jkuchar747
3 Replies

9. SCO

SCO ODBC connection to Vista?

Hi, I'm trying to make an odbc connection to a SCO db using Vista, but I'm having some troubles. In the past I have used Vision97 on either windows 98 and XP, but it will not install on Vista. Is there an alternative driver that I can use to make my connection? Any other workaround? Thanks, ... (1 Reply)
Discussion started by: knewknow
1 Replies
ODBC_PREPARE(3) 							 1							   ODBC_PREPARE(3)

odbc_prepare - Prepares a statement for execution

SYNOPSIS
resource odbc_prepare (resource $connection_id, string $query_string) DESCRIPTION
Prepares a statement for execution. The result identifier can be used later to execute the statement with odbc_execute(3). Some databases (such as IBM DB2, MS SQL Server, and Oracle) support stored procedures that accept parameters of type IN, INOUT, and OUT as defined by the ODBC specification. However, the Unified ODBC driver currently only supports parameters of type IN to stored procedures. PARAMETERS
o $connection_id -The ODBC connection identifier, see odbc_connect(3) for details. o $query_string - The query string statement being prepared. RETURN VALUES
Returns an ODBC result identifier if the SQL command was prepared successfully. Returns FALSE on error. EXAMPLES
Example #1 odbc_execute(3) and odbc_prepare(3) example In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters: <?php $a = 1; $b = 2; $c = 3; $stmt = odbc_prepare($conn, 'CALL myproc(?,?,?)'); $success = odbc_execute($stmt, array($a, $b, $c)); ?> If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your database (for example, mssql for MS SQL Server, or oci8 for Oracle). SEE ALSO
odbc_execute(3). PHP Documentation Group ODBC_PREPARE(3)

Featured Tech Videos