Sponsored Content
Operating Systems AIX Connect to a SQL server from AIX Post 302992683 by TechStudent36 on Tuesday 28th of February 2017 01:56:28 PM
Old 02-28-2017
Connect to a SQL server from 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?

Researching out there, it seems that there are a couple of options:

Data Direct driver
FreeTDS
unixODBC

I hope someone here in the community can either point me in the right direction or share with me some resources and even a step by step if they have one

What am I'm trying to do?
Where I work, we use aix as our main os. We also have a SQL server that houses a lot of our data.

All I want to do is create an aix query that will allow me to connect to a SQL server. From that connection, I want to create an ODBC connect that will allow me to read a dbo table and then create a file with my criteria.

How can you help?
1. High level view of the sequence of steps I need to take to install a driver on aix and probably something on the SQL server side that will allow me to connect to a SQL server. What driver should I use to connect the two?

Thanks in advance for your help!
TechStudent36
 

10 More Discussions You Might Find Interesting

1. Solaris

Connect From VB to SQL Server

Dear All Now I can't connect from VB to Sybase on Unix. How could I do? Please help me. (0 Replies)
Discussion started by: Than Chanroeun
0 Replies

2. Shell Programming and Scripting

connect to SQL server from shell script

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

connect to SQL server from shell script

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

connect to SQL server from shell script

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. AIX

Help Me - AIX server connect to a VPN network

Hi, I have a task requested by my boss to create a script to enable a server to connect to a vpn network and then to connect to another server to upload some data... How can I connect to a vpn network from AIX server? via telnet? ssh? I have tried to google but mostly the answers are... (1 Reply)
Discussion started by: mushr00m
1 Replies

6. Emergency UNIX and Linux Support

How to connect Unix and Sql Server 2005?

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

7. Shell Programming and Scripting

how to Connect from ksh script to SQL server

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

Connect to SQL server from Linux

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

Command to connect to remote AIX server

Hi All, Im looking for a command that can remotely connect to another AIX machine and execute scripts present in that server(Possible scenarios are a complete a restart of 3 servers in a cluster through a single script execution present in one of the servers). Im relatively new to AIX and... (5 Replies)
Discussion started by: Vishakh
5 Replies

10. AIX

Connect to database server and execute sql

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
LQR_CARVER_SET_ENL_STEP(3)				     LqR library API reference					LQR_CARVER_SET_ENL_STEP(3)

NAME
lqr_carver_set_enl_step - set the enlargement step of a LqrCarver object SYNOPSIS
#include <lqr.h> LqrRetVal lqr_carver_set_enl_step(LqrCarver* carver, gfloat enl_step); DESCRIPTION
The function lqr_carver_set_enl_step sets the enlargement step of the LqrCarver object pointed to by carver to the value specified in enl_step, which must be strictly greater than 1 and less than 2. The enlargement step is the maximum enlargement ratio (with respect to either the original width or original height of carver) which the function lqr_carver_resize applies in a single step; if that function is asked a greater enlargement, it divides the process in multiple steps (and updates the original sizes accordingly at each new step - these can be readout at any time with lqr_carver_get_ref_width(3) and lqr_carver_get_ref_height(3)). The default value for new LqrCarver objects is 2.0. RETURN VALUE
The return value follows the Liquid Rescale library signalling system. LQR_ERROR is returned if the enl_step parameter is out of bounds. SEE ALSO
lqr_carver_resize(3), lqr_carver_get_enl_step(3), lqr_carver_get_ref_width(3), lqr_carver_get_ref_height(3), lqr_carver_set_dump_vmaps(3), lqr_carver_set_side_switch_frequency(3), lqr_carver_set_progress(3), lqr_carver_set_preserve_input_image(3), lqr_carver_set_use_cache(3) COPYRIGHT
Copyright (C) 2007-2009 Carlo Baldassi LqR library 0.4.1 API (3:1:3) 10 Maj 2009 LQR_CARVER_SET_ENL_STEP(3)
All times are GMT -4. The time now is 04:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy