dbTalk Databases Forums  

Re: How to make a ODBC connection to Informix database.

comp.databases.informix comp.databases.informix


Discuss Re: How to make a ODBC connection to Informix database. in the comp.databases.informix forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
ar
 
Posts: n/a

Default Re: How to make a ODBC connection to Informix database. - 06-26-2003 , 10:06 AM






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 (AT) yahoo (DOT) com> a écrit dans le message de
news:487f6ccc.0306251146.21460054 (AT) posting (DOT) google.com...
Quote:
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



Reply With Quote
  #2  
Old   
Emmon Simbo
 
Posts: n/a

Default Re: How to make a ODBC connection to Informix database. - 06-27-2003 , 05:13 AM






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 www.openlinksw.com

BR
Emmon Simbo
"ar" <bidon (AT) email (DOT) com> wrote

Quote:
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 (AT) yahoo (DOT) com> a écrit dans le message de
news:487f6ccc.0306251146.21460054 (AT) posting (DOT) google.com...
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

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.