Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

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?

Article:
00079
Last Reviewed:
2nd January 2024
Revision:
9

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.:

SQLDriverConnect(dbc,
 "DSN=dsn_name;LOGONUSER=username;LOGONAUTH=password;",…);

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:

phpinfo();
Applies To

Knowledge Base Feedback

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

(* Required Fields)