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. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 0 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Hagar Yousef [ip] => 196.205.186.233 [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> 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. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => 196.205.186.233 [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 0 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => hager_yousef [ip] => 196.205.186.233 [isdeleted] => 0 [usergroupid] => 2 [membergroupids] => [displaygroupid] => 2 [password] => 8ce27f119870b2f364714ce589c6b691 [passworddate] => 2011-04-11 [email] => hager_yousef@yahoo.com [styleid] => 0 [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => 1 [showbirthday] => 0 [usertitle] => Junior Member [customtitle] => 0 [joindate] => 1302510305 [daysprune] => 0 [lastvisit] => 1302510305 [lastactivity] => 1302510817 [lastpost] => 1302510569 [lastpostid] => 507467 [posts] => 2 [reputation] => 10 [reputationlevelid] => 5 [timezoneoffset] => 0 [pmpopup] => 1 [avatarid] => 0 [avatarrevision] => 0 [profilepicrevision] => 0 [sigpicrevision] => 0 [options] => 45112407 [akvbghsfs_optionsfield] => 0 [birthday] => [birthday_search] => 0000-00-00 [maxposts] => -1 [startofweek] => -1 [referrerid] => 0 [languageid] => 1 [emailstamp] => 0 [threadedmode] => 0 [autosubscribe] => 2 [pmtotal] => 0 [pmunread] => 0 [salt] => \A|u*?58PY)Z41 0 [infractions] => 0 [warnings] => 0 [infractiongroupids] => [infractiongroupid] => 0 [adminoptions] => 0 [profilevisits] => 173 [friendcount] => 0 [friendreqcount] => 0 [vmunreadcount] => 0 [vmmoderatedcount] => 0 [socgroupinvitecount] => 0 [socgroupreqcount] => 0 [pcunreadcount] => 0 [pcmoderatedcount] => 0 [gmmoderatedcount] => 0 [assetposthash] => [fbuserid] => [fbjoindate] => 0 [fbname] => [logintype] => vb [fbaccesstoken] => [newrepcount] => 0 [vbseo_likes_in] => 0 [vbseo_likes_out] => 0 [vbseo_likes_unread] => 0 [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => Male [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> 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. [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => 196.205.186.233 [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 0 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => hager_yousef [ip] => 196.205.186.233 [isdeleted] => 0 [usergroupid] => 2 [membergroupids] => [displaygroupid] => 2 [password] => 8ce27f119870b2f364714ce589c6b691 [passworddate] => 2011-04-11 [email] => hager_yousef@yahoo.com [styleid] => 0 [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => 1 [showbirthday] => 0 [usertitle] => Junior Member [customtitle] => 0 [joindate] => 1302510305 [daysprune] => 0 [lastvisit] => 1302510305 [lastactivity] => 1302510817 [lastpost] => 1302510569 [lastpostid] => 507467 [posts] => 2 [reputation] => 10 [reputationlevelid] => 5 [timezoneoffset] => 0 [pmpopup] => 1 [avatarid] => 0 [avatarrevision] => 0 [profilepicrevision] => 0 [sigpicrevision] => 0 [options] => 45112407 [akvbghsfs_optionsfield] => 0 [birthday] => [birthday_search] => 0000-00-00 [maxposts] => -1 [startofweek] => -1 [referrerid] => 0 [languageid] => 1 [emailstamp] => 0 [threadedmode] => 0 [autosubscribe] => 2 [pmtotal] => 0 [pmunread] => 0 [salt] => \A|u*?58PY)Z41 0 [infractions] => 0 [warnings] => 0 [infractiongroupids] => [infractiongroupid] => 0 [adminoptions] => 0 [profilevisits] => 173 [friendcount] => 0 [friendreqcount] => 0 [vmunreadcount] => 0 [vmmoderatedcount] => 0 [socgroupinvitecount] => 0 [socgroupreqcount] => 0 [pcunreadcount] => 0 [pcmoderatedcount] => 0 [gmmoderatedcount] => 0 [assetposthash] => [fbuserid] => [fbjoindate] => 0 [fbname] => [logintype] => vb [fbaccesstoken] => [newrepcount] => 0 [vbseo_likes_in] => 0 [vbseo_likes_out] => 0 [vbseo_likes_unread] => 0 [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => Male [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 5 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> How to make a ODBC connection to Informix database. - Informix

How to make a ODBC connection to Informix database. - Informix

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

  1. #1

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

    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> a écrit dans le message de
    news:487f6ccc.0306251146.21460054posting.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

    ar Guest

  2. #2

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

    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" <bidonemail.com> wrote in message news:<bdeugc$uhc$1news-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> a écrit dans le message de
    > news:487f6ccc.0306251146.21460054posting.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 Guest

  3. #3

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

    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.
    Hagar Yousef Guest

  4. #4

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

    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 is offline Junior Member
    Join Date
    Apr 2011
    Posts
    2

  5. #5

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

    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 is offline Junior Member
    Join Date
    Apr 2011
    Posts
    2

Similar Threads

  1. No read permission on access database odbc connection
    By mdirect in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 3rd, 08:27 PM
  2. Error in ODBC connection to Pick D3 database in CF 7.0.1
    By elkar portu in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 28th, 02:59 PM
  3. How do I make an ODBC Connection to an offsite server?
    By gregbert in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 30th, 05:03 PM
  4. Replies: 1
    Last Post: November 12th, 08:43 AM
  5. VB & Odbc link to Informix Database
    By Alan in forum Informix
    Replies: 0
    Last Post: July 13th, 06:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •