Thanks for the info so far guys. I think part of my problem is I'm a sys admin, with limited programming experience. I was tasked with writing a frontend (really just a simple web form that passes a few variables) so we could run a stored procedure on a MS SQL database. The kicker is using Windows Authentication, I've gotten it to work using SQL Authentication. I might venture in to ASP land (I've never done ANYTHING is ASP) since I would imagine Microsft would have their own integration down. Anyways, thanks again.
On Tue, Mar 17, 2009 at 8:08 PM, Mac Newbold <[email protected]> wrote: > Today at 6:08pm, Brady Mitchell said: > > On Tue, Mar 17, 2009 at 1:03 PM, Caleb Call <[email protected]> wrote: >> >>> I'm trying to use mssql_connect, but I'm not opposed to using another >>> method of >>> connecting if it's better. Any help would be appreciated. >>> >> >> I've only used MS SQL and PHP together once, and I was never able to >> get it working using the built-in functions on their own. Using adodb >> (http://adodb.sourceforge.net/) worked well for me: >> >> $conn =& ADONewConnection('odbc_mssql'); >> $conn->Connect($dsn_name,$db_user,$db_passwd); >> > > The two main methods (not counting things that layer on top of them, like > adodb) are directly (MSSQL extension) and ODBC (ODBC extension). From a > linux box you usually need FreeTDS as well (especially for MSSQL method) but > in this case that won't be necessary. > > Generally there's some installation to do to make sure you have compatible > versions of all the DLLs. Last I checked, the online resources, starting > with php.net user comments in the manual, and following up with Google, > gave good answers and chances are really good someone else ran into any > problem you ran into and documented a solution eventually. > > Last time we set up an MS SQL connection on a windows box from PHP I think > we eneded up needing to use ODBC because the direct way was never happy with > the versions of DLLs we had (aka DLL Hell, one program needs one version and > another program can't work with that version). With ODBC there are a bunch > of connections you need to configure before it works, if I remember right. > There's a level of that with the "direct" way too. > > Thanks, > Mac > > -- > Mac Newbold Code Greene, LLC > CTO/Chief Technical Officer 44 Exchange Place > Office: 801-582-0148 Salt Lake City, UT 84111 > Cell: 801-694-6334 www.codegreene.com _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
