Re: [foxboro] Informix Star: access tables from another AW

Assuming that you have the host properly defined in /etc/inet/hosts for
aw51c, you may need to configure/add-an-entry to
/opt/informix/etc/sqlhosts.  This file defines the Informix Star servers.


Steve Shimp
Maintenance & Systems Engineer
ExxonMobil Paulsboro Lube Plant
phone: 856.224.5059      cell: 609.820.8501      fax: 856.224.5030
email:  steve.shimp@xxxxxxxxxxxxxx


                                                                                
                        
                      "Weiss, Andreas"                                          
                        
                      <Andreas.Weiss@xxxxxx          To:      
<foxboro@xxxxxxxxxxxxx>                   
                      com>                           cc:                        
                        
                      Sent by:                       Subject: [foxboro] 
Informix Star: access tables    
                      foxboro-bounce@freeli            from another AW          
                        
                      sts.org                                                   
                        
                                                                                
                        
                                                                                
                        
                                                                                
                        
                      05/28/04 11:44 AM                                         
                        
                      Please respond to                                         
                        
                      foxboro                                                   
                        
                                                                                
                        
                                                                                
                        



Hi,

my first steps trying to access an informix table residing on a
different AW51C were not successful.

The sql statements are for example

select id from rootdbs@AW51C:all_points
select id from historian@AW51C:all_points

The first error message was

 931: Cannot locate sqlexec service/tcp service in /etc/services.

That drives me to modify the /etc/services file by adding two entries

sqlexec         1525/tcp
sqlturbo        1526/tcp



Another attempt to run the sql statements results in another error
message

   908: Attempt to connect to database server (aw51c) failed.
 Bad file number


Is someone familiar with Informix star?

Regards
Andreas

BP Koeln


_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html

foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave





 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: