Re: Re: PHP and MSSQL Connection on IIS 5.1

Wei, Alice J. wrote: > Hi, > > For ODBC connections, are you using MSSQL 2005? I am currently using Windows XP for the > server with PHP 5.2. > > I am currently using this version of the MS SQL server, and thus when I am seting up the > ODBC connection, I notice that it keeps failing possibly because the SQL Server is indicated as 2000 > and not even 2003. Would this make a difference? > > Thanks in advance. > > Alice > ====================================================== > Alice Wei > MIS 2009 > School of Library and Information Science > Indiana University Bloomington > ajwei@indiana.edu > _____________________ As long as you're using the right odbc connection string it shouldn't matter - you shouldn't have to use a dsn even - www.connectionstrings.com/?carrier=sqlserver has a nice listing of how you should be formatting your connection strings Remember that you need to be able to have permission to connect to the database! For PHP the easiest way to do this is to get TCP/IP working for sqlserver and using sql level authentication, not windows authentication. You'll have to get into the client tools to get this working properly, and it's been long enough since I had to mess with it that I don't remember exactly where those settings are. Thanks, Elizabeth