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:
4th July 2017
Revision:
9

You can place your odbc.ini file in the current users 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 to from PHP use:
phpinfo();

Applies To

Knowledge Base Feedback

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

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.