Connect to a SQL server from AIX Post: 302992820

Sponsored Content

Operating Systems AIX Connect to a SQL server from AIX Post 302992820 by bakunin on Thursday 2nd of March 2017 03:37:39 AM

03-02-2017

Registered User

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

bakunin

View Public Profile for bakunin

Find all posts by 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.

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

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

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

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

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.

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.

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

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

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

LEARN ABOUT NETBSD

rpmspec

RPMSPEC(8)						      System Manager's Manual							RPMSPEC(8)

NAME

       rpmspec - RPM Spec Tool

SYNOPSIS

   QUERYING SPEC FILES:
       rpmspec {-q|--query} [select-options] [query-options] SPEC_FILE ...

   select-options
	[--rpms]
	[--srpms]

   query-options
	[--qf,--queryformat QUERYFMT]
	[--target TARGET_PLATFORM]

   QUERY OPTIONS
       The general form of an rpm spec query command is

       rpm {-q|--query} [select-options] [query-options]

       You may specify the format that the information should be printed in. To do this, you use the

	--qf|--queryformat QUERYFMT

       option, followed by the QUERYFMT format string.	See rpm(8) for details.

   SELECT OPTIONS
	--rpms Operate on the binary package header(s).
	--srpm Operate on the source package header(s).

SEE ALSO

       popt(3),
       rpm(8),
       rpmdb(8),
       rpmkeys(8),
       rpmsign(8),
       rpm2cpio(8),
       rpmbuild(8),

       rpmspec	--help - as rpm supports customizing the options via popt aliases it's impossible to guarantee that what's described in the manual
       matches what's available.

       http://www.rpm.org/ <URL:http://www.rpm.org/>

AUTHORS

       Marc Ewing <marc@redhat.com>
       Jeff Johnson <jbj@redhat.com>
       Erik Troan <ewt@redhat.com>
       Panu Matilainen <pmatilai@redhat.com>

Red Hat, Inc							  29 October 2010							RPMSPEC(8)

10 More Discussions You Might Find Interesting

1. Solaris

Connect From VB to SQL Server

Discussion started by: Than Chanroeun

2. Shell Programming and Scripting

connect to SQL server from shell script

Discussion started by: ananthi_ku

3. Solaris

connect to SQL server from shell script

Discussion started by: amitbhelave

4. Shell Programming and Scripting

connect to SQL server from shell script

Discussion started by: amitbhelave

5. AIX

Help Me - AIX server connect to a VPN network

Discussion started by: mushr00m

6. Emergency UNIX and Linux Support

How to connect Unix and Sql Server 2005?

Discussion started by: parthmittal2007

7. Shell Programming and Scripting

how to Connect from ksh script to SQL server

Discussion started by: santoshhegde

8. SuSE

Connect to SQL server from Linux

Discussion started by: cvsanthosh

9. AIX

Command to connect to remote AIX server

Discussion started by: Vishakh

10. AIX

Connect to database server and execute sql

Discussion started by: MadhuSeven

LEARN ABOUT NETBSD

rpmspec