Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Connect to a SQL server from AIX
Operating Systems AIX Connect to a SQL server from AIX Post 302992820 by bakunin on Thursday 2nd of March 2017 03:37:39 AM
Old 03-02-2017
Quote:
Originally Posted by TechStudent36
What is the easiest way to connect to a SQL server from aix?
Counter question: what is the easiest way to write programs?

It depends. It depends on a lot of things and without further describing what you are trying to do and how you are planning to do it it is difficult to answer your question.

Quote:
Originally Posted by TechStudent36
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.
OK, this is at least some of the info talked about above, even though i wonder why a company would use AIX as its main OS and then put the database on Windows. It usually is the other way round as AIX is a lot better suited to robust and continuous operation than some Windoze.

Anyway, what you most probably need is unixODBC. It is a driver you install (in fact it is basically a shared library containing the functions used to access the DB) and then have to configure to access the DB.

Drivers to install are "packages" and each OS has its package-manager. AIX has in fact two of them: the native installp and then rpm. This means you can install packages in "bff-format" (installp) and rpm-format (rpm), but they still have to be built for the respective platform you are going to install to. You cannot take any Linux-package in rpm-format, install it and then expect it to work. You still need a package specifically designed and built for AIX. A great source for (open-source) packages is Mister Perzls AIX rpm-page, where you can find and download (among others) recent versions of unixODBC.

There is still not enough information to tell you how to configure the package once you have installed it, but i suggest you install first and - if you still need help configuring it - report back.

I hope this helps.

bakunin
 

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

LEARN ABOUT PHP

snmp2_walk

SNMP2_WALK(3)								 1							     SNMP2_WALK(3)

snmp2_walk - Fetch all theSNMPobjects from an agent

SYNOPSIS

       array snmp2_walk (string  $host, string	$community, string  $object_id, [string  $timeout = 1000000], [string  $retries = 5])

DESCRIPTION

       snmp2_walk(3) function is used to read all the values from an SNMP agent specified by the $hostname.

PARAMETERS

	      o $host
		- The SNMP agent (server).

	      o $community
		- The read community.

	      o $object_id
		-  If NULL, $object_id is taken as the root of the SNMP objects tree and all objects under that tree are returned as an array.	If
		$object_id is specified, all the SNMP objects below that $object_id are returned.

	      o $timeout
		- The number of microseconds until the first timeout.

	      o $retries
		- The number of times to retry if timeouts occur.

RETURN VALUES

	Returns an array of SNMP object values starting from the $object_id as root or FALSE on error.

EXAMPLES

       Example #1

	      snm2_pwalk(3) Example

	      <?php
	      $a = snmp2_walk("127.0.0.1", "public", "");

	      foreach ($a as $val) {
		  echo "$val
";
	      }

	      ?>

	Above function call would return all the SNMP objects from the SNMP agent running on localhost. One can step through  the  values  with  a
       loop

SEE ALSO

       snmp2_real_walk(3).

PHP Documentation Group 													     SNMP2_WALK(3)
All times are GMT -4. The time now is 08:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy