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.
Login or Register to Ask a Question

Previous Thread | Next Thread

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
Login or Register to Ask a Question
GAMMU-SMSD-ODBC(7)						       Gammu							GAMMU-SMSD-ODBC(7)

NAME
gammu-smsd-odbc - gammu-smsd(1) backend using ODBC abstraction layer to use any supported database as a message storage DESCRIPTION
New in version 1.29.92. ODBC backend stores all data in any database supported by ODBC, which parameters are defined by configuration (see gammu-smsdrc for description of configuration options). For tables description see gammu-smsd-tables. This backend is based on gammu-smsd-sql. SUPPORTED DRIVERS
On Microsoft Windows, Gammu uses native ODBC, on other platforms, unixODBC can be used. LIMITATIONS
Due to limits of the ODBC interface, you might have to tweak SQL queries to work in used SQL server, see SQL Queries for more details. Partially this can be configured using SQL. CONFIGURATION
Before running gammu-smsd you need to create necessary tables in the database. You can use examples given in database specific backends parts of this manual to do that. You specify data source name (DSN) as Host in gammu-smsdrc. The data source is configured depending on your platform. On Microsoft Windows, you can find instructions on Microsoft website: http://support.microsoft.com/kb/305599 For unixODBC this is documented in the user manual: http://www.unixodbc.org/doc/UserManual/ EXAMPLE
Example configuration: [smsd] service = sql driver = odbc host = dsn_of_your_database sql = sql_variant_to_use user = username password = password See also gammu-smsdrc AUTHOR
Michal iha <michal@cihar.com> COPYRIGHT
2009-2012, Michal iha <michal@cihar.com> 1.31.90 February 24, 2012 GAMMU-SMSD-ODBC(7)