Oninit cdi / Archive
Talk to an expert →

Database only users and ODBC

Posted in 2014

Topics: Connectivity: ODBC / JDBC / .NET, Server Administration, Security, Permissions & Auditing

RAY BURNS — — source: IIUG Forums & Mailing Lists

I have been trying to create users (using the CREATE USER command) for use with ODBC. I create /etc/informix/allowed.surrogates I get the security right (644) I can load it with "onmode -cache surrogates" with no error messages I modified my onconfig with "usermapping admin" and restarted the database. I can use create user : create user noddy with password "bigears" properties user "<user defined in surrogates>" and no error messages are shown. I test that I have a valid ODBC connection for another user. When I try to connect via ODBC with the noddy user I get an error message saying there is no such user on the server. Has anyone tried this before? Is it supposed to work via ODBC? If so, any ideas what I'm missing? Any help will be appreciated.

↪ replying to RAY BURNS
Fernando Nunes — — source: IIUG Forums & Mailing Lists

When you say you receive an error saying there's no user on the server... can you confirm: 1- That you're getting -951 error on the client 2- Is there something written in the server message log? Regards. On Wed, Jun 11, 2014 at 3:33 AM, RAY BURNS <ray.burns@velocityglobal.co.nz> wrote: > I have been trying to create users (using the CREATE USER command) for use > with ODBC. > > I create /etc/informix/allowed.surrogates > I get the security right (644) > I can load it with "onmode -cache surrogates" with no error messages > I modified my onconfig with "usermapping admin" and restarted the database. > I can use create user : > create user noddy with password "bigears" properties user "<user defined in > surrogates>" and no error messages are shown. > I test that I have a valid ODBC connection for another user. > When I try to connect via ODBC with the noddy user I get an error message > saying there is no such user on the server. > > Has anyone tried this before? Is it supposed to work via ODBC? If so, any > ideas what I'm missing? > > Any help will be appreciated. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --047d7b5d428cc4274f04fb96f442

↪ replying to Fernando Nunes
RAY BURNS — — source: IIUG Forums & Mailing Lists

Yes, it is -951 error, There are no messages in $INFOMRIX/tmp/online.log

Related threads

Glossary