Oninit cdi / Archive
Talk to an expert →

Informix Connection Strings

Posted in 2009

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

MIKE CADDY — — source: IIUG Forums & Mailing Lists

All, I'm very new to Informix and have been asked to produce a C# based Web Application that interfaces to an Informix 11.10 IDS Database. Due to security requirements I need to pass the current users credentials through to the database server. I do this on SQL Server by specifying "Integrated Security=True" in the connection string. Is there a way to do this with Informix, all the examples I have seen to date include the user name and Password hard coded in the connection string. Regards MC

↪ replying to MIKE CADDY
MIKE CADDY — — source: IIUG Forums & Mailing Lists

Answer was surprisingly simple. I just left the user name and password out of the connection string and all is fine. I have observed some very strange issues, which I think relate to a bug in the connection pooling code. I'll post that as a new thread.

Glossary