Re: How to make both 'onipcshm' and 'onsoctcp' working ?

On Sat, Apr 24, 1999 at 01:56:50PM +0900, Gidon Sull wrote: > > A liner help would be highly appreciated if somebody > could advise. > > I'm trying to setup our BBS DB for running on DS (Linux), > with NETTYPE set to both onipcshm/onsoctcp, so that it's > available to the Windows client via ODBC. I tried the config > as follows, but either one (ie. either onipcshm or onsoctcp) > works but not both... > > Our BBS server program talk to DB via ipc, and Windows > client need to talk to DB via tcp/ip so it seems that we need > both connection types working. > > I suppose it's related to the NETTYPE setting on 'onconfig' > file, but find it difficult to get the syntax right for NETTYPE > setup. > > > -- sqlhosts > > ss10 onipcshm ss10 olshm0 > #ss10t onsoctcp ss10 oltcp0> > > -- onconfig > > # System Configuration > > SERVERNUM 0 > NETTYPE onipcshm > DBSERVERNAME ss10> #DBSERVERALIASES ss10t > DEADLOCK_TIMEOUT 60 > RESIDENT 0 Try: DBSERVERNAME ss10 DBSERVERALIASES ss10t NETTYPE ipcshm,,,CPU NETTYPE soctcp,,,NET And of course uncomment the sqlhosts and services line. I'm not sure it will help, but it is worth to try it. Best Regards, Octav > > -- services > > #oltcp0 1499/tcp # Informix tcp > > Any suggestions would be highly appreciated. > > Cheers ! > > > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com

Hi Octav ! Many thanks for your advise. I didn't know there's ',,,CPU/,,,NET' syntax, so I tried as you suggested. But I 've got : "oninit: Fatal error in initializing ASF with 'ASF_INIT_DATA' flags; asfcode = ' 25507'." 'Course I did uncomment corresponding sqlhosts, services and onconfig lines. Obviously I can't initialize the DB at the moment, though I can try this with the new DB. I see that 25507 is : 'You specified an unknown service name or protocol. Tell your database administrator to examine the sqlhosts file entry. Check that the NETTYPE settings in the ONCONFIG file match the NETTYPE settings in the sqlhosts file.' As far as I can see, the only diff is 'on' part (ie. ipcshm/soctcp) on the onconfig file. And I don't understand what functions '.infos.ss10' and 'oncfg_ss10.0', which are generated after DB's being initialized, are doing... Would the changes in sqlhosts and onconfig file are relevant to these files in any way ?? I really appreciate for your help. Best regards, ps. ummm.... I'm ashamed to say that I had to lookup my map to locate R.O.M !!! > Octav Chiriac wrote: > > Try: > > DBSERVERNAME ss10 > DBSERVERALIASES ss10t > NETTYPE ipcshm,,,CPU > NETTYPE soctcp,,,NET> > And of course uncomment the sqlhosts and services line. > > I'm not sure it will help, but it is worth to try it. > > Best Regards, > Octav > > > > > -- services > > > > #oltcp0 1499/tcp # Informix tcp > > > > Any suggestions would be highly appreciated. > > > > Cheers ! > > > > > > > > -- > Octav Chiriac Phone: (373) 2 21 20 96 > NetInfo S.R.L. Fax: (373) 2 21 36 59 > Chisinau (373) 2 24 00 83 > Moldova, Republic of mailto:com@netinfo-moldova.com