DevOps, CI/CD and Automation

I cannot get PHP to make the connection to Oracle 7.

I am running everyhting on Windows 2003 with IIS. I have the Oracle ODBC driver and have setup a DSN for the database. I can connect easily using ASP but trying to connect using PHP via ODBC just does not seem work.

Using ASP the following works

cntMyConnection_STRING = "dsn=MyDSNName;uid=Username;pwd=Password;"

Trying the following in PHP produces an error:

$connect = odbc_connect("MyDSNName", "Username", "Password");

For the sake of arguement, I also setup a DSN to an Access database and tried the PHP connection method above and it worked fine. The problem seems to be specific to Oracle and PHP.

Any answer I have seen thus far has been way over my head and has contained WAY TO MUCH INFORMATION. I need to know how to SIMPLY establish a connection between PHP and Oracle 7 using ODBC via an assigned DSN on Windows Server 2003. Any help would be GREATLY appreciated.