Re: Access - ODBC - OnLine -Reply

Richard Has anyone already mentioned NIS? The error you are receiving means that the connection to the server has succeeded, and Openlink has been unable to resolve the userid and password that you entered. If you are absolutely sure that these are correct for the server that you are connecting to then the only other time i have seen this behaviour is when NIS is configured on the box. You need a different server side component from openlink to run against NIS. When running it creates a process called oplauth, in addition to the normal oplrqb. HTH -- -- Peter Tashkoff <tashkop@kiwi.co.nz> This posting may not be used by any commercial organisation to vilify another. <r.thomas@csl.gov .uk> 14/August/1996 10:27pm >>> Corinne Gregory wrote: > > > > > Thanks for this, but where will I find the "save userid/password > > locally" option. It doesn't seem to be in any of the menus or > > dialogue boxes. It doesn't appear in any the prompts when I try to > > connect, and it doesn't seem to be in openlink.ini. Am I missing > > something fundamental here? :-) > > Ah, you haven't even made a connection yet...you'll find this option > as part of the "attach tables" dialog, which I'm assuming you haven't > gotten to yet. > Hi Corinne, Thanks, I'll look out for this when I eventually get there!! :-) My (current) problem is happening before this stage. I click on File - Attach table..., I get a box where I have to choose the type of "target" database, so I choose <sql database>, then from the SQL Data Sources box I choose "PHDD" (this is one I configured using the ODBC software). I then get a login dialogue box entitled "Openlink ODBC" with the name of the datasource and spaces for Username and Password. I put in my username and id for the unix server, and I get the error message "invalid username/password" in a box headed "Openlink Communication Agent", and the following lines are added to the request broker log file: 11:10:19 unsuccessful login attempt for rt10hp 11:10:19 rejected rt10hp@pc120.MSACCESS (invalid username/password) I added pc120 to my .rhosts file, but it still doesn't work. The same thing happens if I use the informix id and password. Has anyone got any ideas? Richard.