Easysoft Data Access

I don't like my odbc.ini in the same directory as my PHP/Perl script, as people browsing my web site may see it and it contains passwords. What do I do?

Last Reviewed:
2nd January 2024

You can place your odbc.ini file in the current user's home directory or in the file pointed to by the ODBCINI environment variable. You can also put your DSNs in /etc/odbc.ini. You can also place the sensitive information in the call to SQLDriverConnect by setting the attributes in the in_connection_string parameter, e.g.:


Attributes set in the in_connection_string argument to SQLDriverConnect override values in the odbc.ini file.

To set the ODBCINI environment variable from PHP use:

putenv ("path/odbc.ini");

To see what environment variables are set in PHP use:

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)