How to make a ODBC connection to Informix database.
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
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.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
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@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.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