How to make a ODBC connection to Informix database.

[ar]

Hello,

First you must have Informix SDK or Informix Connect installed on your PC.
Second, you must get informations from your DBA
Is your server a Windows Server or a Unix (or Linux) Server ?

Server = The name of your Informix instance (Value of the INFORMIXSERVER
environment variable on the server)
Host = Name ot IP address of your server (Unix or Windows server)
Protocol = olsoctcp
Service = service name or TCP/IP port number to access to Informix Server

If you have a Unix Server, you can find :
SERVER => in the file $INFORMIXDIR/etc/$ONCONFIG, SERVERNAME or
SERVERALIASES parameter, or in the file $INFORMIXDIR/etc/sqlhosts (first
column) .
PROTOCOL => in the file $INFORMIXDIR/etc/sqlhosts (second column)
HOST => in the file $INFORMIXDIR/etc/sqlhosts (third column) or in the file
/etc/hosts (if static IP address)
SERVICE => in the file $INFORMIXDIR/etc/sqlhosts (fourth column). If it's a
service name, you can get port number in the file /etc/services.
Hope this will help you.

Regards
AR

These informations can be found on

"Sanjay" <vermasanjay@yahoo.com> a écrit dans le message de
news:487f6ccc.0306251146.21460054@posting.google.c om...

> Hi Friends,
>
> I am new to informix and so want to know how should I make connection
> to my Informix server. There are cetain parameters while making the
> connection and I dont know what to enter in that. For eg. : Server ,
> Host, Service, Protocol. I know the Database name and the user and
> passwd. My company's Network admin. is on vacation for the next 20
> days and I need a connection urgently.
>
> Can someone help me in this,
>
> Thanking you in advance,
>
> Sanjay

[Emmon Simbo]

Hi

If you do not have Informix Connect or would rather not install that
software, there is also the alternative of installing a client/server
that doesn't need any Informix software other than the database
installed. This can be got from [url]www.openlinksw.com[/url]

BR
Emmon Simbo
"ar" <bidon@email.com> wrote in message news:<bdeugc$uhc$1@news-reader4.wanadoo.fr>...

> Hello,
>
> First you must have Informix SDK or Informix Connect installed on your PC.
> Second, you must get informations from your DBA
> Is your server a Windows Server or a Unix (or Linux) Server ?
>
> Server = The name of your Informix instance (Value of the INFORMIXSERVER
> environment variable on the server)
> Host = Name ot IP address of your server (Unix or Windows server)
> Protocol = olsoctcp
> Service = service name or TCP/IP port number to access to Informix Server
>
> If you have a Unix Server, you can find :
> SERVER => in the file $INFORMIXDIR/etc/$ONCONFIG, SERVERNAME or
> SERVERALIASES parameter, or in the file $INFORMIXDIR/etc/sqlhosts (first
> column) .
> PROTOCOL => in the file $INFORMIXDIR/etc/sqlhosts (second column)
> HOST => in the file $INFORMIXDIR/etc/sqlhosts (third column) or in the file
> /etc/hosts (if static IP address)
> SERVICE => in the file $INFORMIXDIR/etc/sqlhosts (fourth column). If it's a
> service name, you can get port number in the file /etc/services.
> Hope this will help you.
>
> Regards
> AR
>
> These informations can be found on
>
> "Sanjay" <vermasanjay@yahoo.com> a écrit dans le message de
> news:487f6ccc.0306251146.21460054@posting.google.c om...

> > Hi Friends,
> >
> > I am new to informix and so want to know how should I make connection
> > to my Informix server. There are cetain parameters while making the
> > connection and I dont know what to enter in that. For eg. : Server ,
> > Host, Service, Protocol. I know the Database name and the user and
> > passwd. My company's Network admin. is on vacation for the next 20
> > days and I need a connection urgently.
> >
> > Can someone help me in this,
> >
> > Thanking you in advance,
> >
> > Sanjay

[Hagar Yousef]

Hi everybody,

I have Avaya system in my company, and I have task to get the cost of call and know all called numbers in and out from call center.
All I know about the database --> it is informix DB and it is located on UNIX server .
And I found your replay --->
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''
If you have a Unix Server, you can find :
> SERVER => in the file $INFORMIXDIR/etc/$ONCONFIG, SERVERNAME or
> SERVERALIASES parameter, or in the file $INFORMIXDIR/etc/sqlhosts (first
> column) .
> PROTOCOL => in the file $INFORMIXDIR/etc/sqlhosts (second column)
> HOST => in the file $INFORMIXDIR/etc/sqlhosts (third column) or in the file
> /etc/hosts (if static IP address)
> SERVICE => in the file $INFORMIXDIR/etc/sqlhosts (fourth column). If it's a
> service name, you can get port number in the file /etc/services.
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''

My question is how to access this file , I don't have experience with unix ?

Thanks all.

[hager_yousef]

Hi everybody,

I have Avaya system in my company, and I have task to get the cost of call and know all called numbers in and out from call center.
All I know about the database --> it is informix DB and it is located on UNIX server .
And I found your replay --->
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''
If you have a Unix Server, you can find :
> SERVER => in the file $INFORMIXDIR/etc/$ONCONFIG, SERVERNAME or
> SERVERALIASES parameter, or in the file $INFORMIXDIR/etc/sqlhosts (first
> column) .
> PROTOCOL => in the file $INFORMIXDIR/etc/sqlhosts (second column)
> HOST => in the file $INFORMIXDIR/etc/sqlhosts (third column) or in the file
> /etc/hosts (if static IP address)
> SERVICE => in the file $INFORMIXDIR/etc/sqlhosts (fourth column). If it's a
> service name, you can get port number in the file /etc/services.
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''

My question is how to access this file , I don't have experience with unix ?

Thanks all.

[hager_yousef]

Hi everybody,

I have Avaya system in my company, and I have task to get the cost of call and know all called numbers in and out from call center.
All I know about the database --> it is informix DB and it is located on UNIX server .
And I found your replay --->
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''
If you have a Unix Server, you can find :
> SERVER => in the file $INFORMIXDIR/etc/$ONCONFIG, SERVERNAME or
> SERVERALIASES parameter, or in the file $INFORMIXDIR/etc/sqlhosts (first
> column) .
> PROTOCOL => in the file $INFORMIXDIR/etc/sqlhosts (second column)
> HOST => in the file $INFORMIXDIR/etc/sqlhosts (third column) or in the file
> /etc/hosts (if static IP address)
> SERVICE => in the file $INFORMIXDIR/etc/sqlhosts (fourth column). If it's a
> service name, you can get port number in the file /etc/services.
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''

My question is how to access this file , I don't have experience with unix ?

Thanks all.