Why cannot Apache/PHP find my odbc.ini file? Why do I get error "Datasource not found and no default driver"?

Easysoft ODBC-ODBC Bridge

Why cannot Apache/PHP find my odbc.ini file? Why do I get error "Datasource not found and no default driver"?

Article :	00979
Last Reviewed :	2nd June 2008
Revision :	1

When you start Apache with PHP built with ODBC support, PHP immediately allocates an ODBC environment handle. Unfortunately, the OOB searches for the odbc.ini file when an environment handle is created and so your odbc.ini file needs to found at server startup. This can be a nuisance since most people start Apache at machine boot time from an rc script but locate their odbc.ini files in the same directory as their PHP scripts. The best way around this is to put all your DSN definitions in the /etc/odbc.ini (or SYS$ROOT:odbc.ini for VMS) file.

Applies To

Products
- Easysoft ODBC-ODBC Bridge
Applications
- Apache
Languages
- PHP

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)

Easysoft ODBC-ODBC Bridge

Why cannot Apache/PHP find my odbc.ini file? Why do I get error "Datasource not found and no default driver"?

Applies To

Knowledge Base Feedback