RE: Informix CLI 32 and Access

Posted in 2000

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Security, Permissions & Auditing

Csom Gyula — Sun, 17 Dec 2000 14:07:29 +0100 — source: Informix-list mailing list archive (1991-1998)

Well, then you may try to set uid/passwd at the odbc-datasource level. Eg. on the Control Panel, goto Data Sources (ODBC), select the appropiate datasources (those used by Access as linked tables) and set the uid/passwd there. I admit this is not an elegant solution if there are many linked tables... Regarding your question "Why?" I have no clue. Csomi Ps. one question: which setnet did you install first/last and where? Im not a CLI/ODBC expert but to my understanding the dll-s used by CLI/ODBC can be found under the following registry key: HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\SharedDLLs You may check there whether you use or not the correct verions - but again I could be wrong... -----Original Message----- From: Simone [mailto:riker66@katamail.com] Sent: Sunday, December 17, 2000 8: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 > >

↪ replying to Csom Gyula

Simone — Sun, 17 Dec 2000 17:01:15 +0100 — source: Informix-list mailing list archive (1991-1998)

It's no possible set the password from the ODBC control pannell for the ODBC/CLI. It's necessary use the SETNET utility to set the password and ACCESS ignore the password setted from the SETNET utility. Anyone have never used INFORMIX ODBC/CLI 2.5 with Access? I can belive it, I am the only in the world?