RE: Informix CLI 32 and Access
Posted in 2000
Simone could not stop MS Access asking for a password with Informix CLI 32 even after setting it in SETNET32. Niraj Sinha said to set user and password in the ODBC driver setup. Simone said this failed on 25 PCs. Falco asked how Access was connecting. Alex Bernaards said to tick the remember password option when attaching the external table in Access. No confirmed solution.
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing
SEt your user/passwd in the ODBC driver setup and it would work. We have that setup in atleast 10 PCs in our office. Niraj -----Original Message----- From: Simone [mailto:riker66@katamail.com] Sent: Sunday, December 17, 2000 2:59 AM To: informix-list@iiug.org Subject: Re: Informix CLI 32 and Access This (the most logical solution) do not work on my PC. Why? I set the password in the SETNET utility but access still asking me the password!!! I have installed on the pc the 16 bit version on setnet (setnet.exe) also. Is this the rason? Simon "Csom Gyula" <Csom@interface.hu> ha scritto nel messaggio news:91gph9$36h$1@news.xmission.com... > > Hi, > goto to "Host Information", then set the "Password Option" to > "Password" and the "Password" to the appropiate password. Do it > on a per-user basis, eg. if multiple users use the database set > SETNET 32 for all... > > Csomi > > -----Original Message----- > From: Simone [mailto:riker66@katamail.com] > Sent: Saturday, December 16, 2000 4:41 PM > To: informix-list@iiug.org > Subject: Informix CLI 32 and Access > > > Hello, > i use the Informix-cli ODBC driver 2.5 with access 97 and 2000. > I have some link tables un my access aplication. > what is the way to set the password of the connection from the INFORMIX > SETNET 32? > Every time thath i run my access application the ODBC connection ask me the > password even if I have set the password in the setnet 32 utility. > It's a bug, it's a feature, I'm making a mistake? > tank you for the help end escuse me for my poor english... i'm italian. > > Simon > >
This don't work on my PC, and in other 25 pc of my lan!!! If you use the informix/cli you know that the password must be setted un the SETNET32.EXE utility that don't work: don't "remember" the password... "Sinha, Niraj" <niraj.sinha@BondBook.com> ha scritto nel messaggio news:91in21$l63$1@news.xmission.com... > > SEt your user/passwd in the ODBC driver setup and it would work. We have > that setup in atleast 10 PCs in our office. > Niraj
Hi Simone. How do you you connect Access ( or plan to connect ) to the tables you want to use ? /Falco
Hi Simone, When you attach a new external table within MS-Access you get the option to mark the "remind password" field. Maybe mine explation isn´t okay, because i use the dutch version of MS-Access, but i know for sure that you have to do it within MS-Access. Ofcourse your setnet setttings must be okay! Alex Simone wrote: > This don't work on my PC, and in other 25 pc of my lan!!! > If you use the informix/cli you know that the password must be setted un the > SETNET32.EXE utility that don't work: don't "remember" the password... > > "Sinha, Niraj" <niraj.sinha@BondBook.com> ha scritto nel messaggio > news:91in21$l63$1@news.xmission.com... > > > > SEt your user/passwd in the ODBC driver setup and it would work. We have > > that setup in atleast 10 PCs in our office. > > Niraj