Author Topic: ODBC PHP and Apache server - SOLVED  (Read 1756 times)

sdetweil

  • New Member
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
ODBC PHP and Apache server - SOLVED
« on: April 15, 2008, 07:42:52 PM »
| 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() [<a href='function.odbc-connect'>function.odbc-connect</a>]: 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

peg110

  • Expert PHP Helper
  • Senior Member
  • *****
  • Posts: 799
  • Karma: +0/-0
    • View Profile
    • http://www.tripleclicks.com/11260983/go
Re: ODBC PHP and Apache server - SOLVED
« Reply #1 on: April 16, 2008, 11:26:45 AM »
Glad we could,..... err...... Help?

Anyway... glad you got it working.