RESOLVED: PHP & SQL Server Authentication Help

[Vogel515]

I am looking to set up a connection between a website set up on my localhost and the SQL db here at work.

I have set up the ODBC connection and figured I'd be able to just use the odbc_connection() function with my UN/PW, however it does not seem to be working.

Does this have anything to do with the fact that I am connecting to the DB using SQL Server Authentication?

 

[KLin]

Did you setup the userID as a sql login within SQL Server and give it access to the database? That's the first thing I would doublecheck.

 

[Vogel515]

Klin - no but just as stupidly I set the User DSN settings, but not the System DSN settings.

Damnit, that was a completely unnecessary headache.

Thanks for the response