ODBC PHP and Apache server - SOLVED

| DOAH… the SYSTEM DSN and the USER DSN were different on this machine!.. yeowch!

I have a backend data page that uses PHP to pull data out of a database via ODBC on Windows.

The php script runs fine from a command prompt,
(which means the DB is fine, ODBC is fine, the DSN is fine and the php script is good).

but fails
odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

when run thru apache. but the apache loadmodule for .PHP worked ok.

help

Sam

Glad we could,… err… Help?

Anyway… glad you got it working.

Sponsor our Newsletter | Privacy Policy | Terms of Service