RE: ODBC troubles

> Here's what I got so far... > > On the AIX box /etc/services > ifx1_tcp1 1540/tcp # Informix > ifx1 1541/tcp # Informix Good - and it matches the client's version > > Informix73/etc/sqlhosts > ifx1 onsoctcp mishost ifx1 > ifx1_tcp1 onsoctcp mishost ifx1_tcp1 So the DBSERVERNAME/DBSERVERALIAS should be ifx1 and ifx1_tcp1. Under AIX run `onstat -c | grep -i DBSERV ` This will list which is which. The file that holds this info is $INFORMIXDIR/etc/$ONCONFIG INFORMIXSERVER is a environment variable ( Unix ) Try ` env | grep -i INFORMIX ` Note informixserver should be either ifx1 or ifx1_tcp1 on the unix server and should be the tcp one on the client machine ( often denoted by server in ODBC setup ). The servicename should be ( col 4 from sqlhosts ) ifx1_tcp1 The protocol is onsoctcp. HTH Jo > > > On the Win95 box /WINDOWS/services > ifx1_tcp1 1540/tcp # Informix > ifx1 1541/tcp # Informix > > With this I get the ubiquitous error: > "INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES" > To which I reply... UGH > > Thanks again for any help.. > > > > On Tue, 07 Mar 2000 15:44:47 +0000, Paul Watson <paulw@wfsoftware.com> > wrote: > > >It should be onsoctcp at the PC end, can't remember at the AIX end. > > > >The port number you are trying to connect to at the AIX end should be > >in the services file on the PC, if it isn't then you need to connect > >via the port number. If you are under Win9x then the services > >file should be in $WINDOWS, under NT it should be under > >$WINNT/system32/drivers/etc, under Win2000 I don't know but it's > >probably > >$WIN2000/lets/move/bastard/again > > > > > > > >BMSI wrote: > >> > >> I'm new to Informix, (I'm a networker) so bear with me.. > >> We have Informix 7.2..1 on AIX and I'm trying to connect via ODBC. > >> Using the ODBC connection I type in the Databasename, > Hostname which > >> is the FQDN, Username PW etc.. My troubles are in the Servicename > >> and Protocaltype fields. I'm guessing Servicename as tcp, > and onsotcp > >> as this was a default. I know I have tcp running on the > AIX, as it > >> is listed in the etc/services. > >> > >> And using MS-Access to connect to the ODBC I get a > "Cannot locate tcp > >> service/tcp service in etc/services, Unknown error message 11004" > >> > >> Any help would be greatly appreciated... > ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________

Sorry for the newbie-ness here , but I cannot get onstat to run, it y returns 'GLS initialization failed, error -23101' I also do not have the ENV set, but I can manage that, I just wonder if the env would be set if I had onstat running correctly. I appreciate your help, and any you can give... On Wed, 8 Mar 2000 09:38:14 -0000, "COOPER, Joseph" <Joseph.COOPER@sema.co.uk> wrote: > >> Here's what I got so far... >> >> On the AIX box /etc/services >> ifx1_tcp1 1540/tcp # Informix >> ifx1 1541/tcp # Informix > >Good - and it matches the client's version > >> >> Informix73/etc/sqlhosts >> ifx1 onsoctcp mishost ifx1 >> ifx1_tcp1 onsoctcp mishost ifx1_tcp1> >So the DBSERVERNAME/DBSERVERALIAS should be ifx1 and ifx1_tcp1. >Under AIX run `onstat -c | grep -i DBSERV ` >This will list which is which. The file that holds this info is >$INFORMIXDIR/etc/$ONCONFIG > >INFORMIXSERVER is a environment variable ( Unix ) >Try ` env | grep -i INFORMIX ` >Note informixserver should be either ifx1 or ifx1_tcp1 on the unix server >and should be the tcp one on the client machine ( often denoted by server >in ODBC setup ). > >The servicename should be ( col 4 from sqlhosts ) ifx1_tcp1 >The protocol is onsoctcp. > >HTH >Jo > >> >> >> On the Win95 box /WINDOWS/services >> ifx1_tcp1 1540/tcp # Informix >> ifx1 1541/tcp # Informix >> >> With this I get the ubiquitous error: >> "INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES" >> To which I reply... UGH >> >> Thanks again for any help.. >> >> >> >> On Tue, 07 Mar 2000 15:44:47 +0000, Paul Watson <paulw@wfsoftware.com> >> wrote: >> >> >It should be onsoctcp at the PC end, can't remember at the AIX end. >> > >> >The port number you are trying to connect to at the AIX end should be >> >in the services file on the PC, if it isn't then you need to connect >> >via the port number. If you are under Win9x then the services >> >file should be in $WINDOWS, under NT it should be under >> >$WINNT/system32/drivers/etc, under Win2000 I don't know but it's >> >probably >> >$WIN2000/lets/move/bastard/again >> > >> > >> > >> >BMSI wrote: >> >> >> >> I'm new to Informix, (I'm a networker) so bear with me.. >> >> We have Informix 7.2..1 on AIX and I'm trying to connect via ODBC. >> >> Using the ODBC connection I type in the Databasename, >> Hostname which >> >> is the FQDN, Username PW etc.. My troubles are in the Servicename >> >> and Protocaltype fields. I'm guessing Servicename as tcp, >> and onsotcp >> >> as this was a default. I know I have tcp running on the >> AIX, as it >> >> is listed in the etc/services. >> >> >> >> And using MS-Access to connect to the ODBC I get a >> "Cannot locate tcp >> >> service/tcp service in etc/services, Unknown error message 11004" >> >> >> >> Any help would be greatly appreciated... >> > >___________________________________________________________________________ >This email is confidential and intended solely for the use of the >individual to whom it is addressed. Any views or opinions presented are >solely those of the author and do not necessarily represent those of >Sema Group. >If you are not the intended recipient, be advised that you have received this >email in error and that any use, dissemination, forwarding, printing, or >copying of this email is strictly prohibited. > >If you have received this email in error please notify the Sema Group >Helpdesk by telephone on +44 (0) 121 627 5600. >___________________________________________________________________________