Re: Access - ODBC - OnLine

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.