Treeko

Yes, I am now out of the pickle jar. The good corbin hath directed me to http://us2.php.net/get/php-5.2.8-Win32.zip/from/a/mirror Where I downloaded the files directly, instead of using the installer. AND LO AND BEHOLD, it worked flawlessly. That is, I renamed my current PHP folder to PHP2, and then made a new PHP folder named PHP, and unzipped the contents of the zip folder that was downloaded from that site into it. And it worked. My module is being loaded correctly now. Here is an image of the huge success: http://img.photobucket.com/albums/v228/Treeko/MS%20SQL%20Stuff/HugeSuccess.png

Well... I have heard that ntwdblib.dll is a dependancy for php_mssql.dll, and I have that file... all over the place. Copies residing both in c:\windows\system32, and in c:\php\ext. I reinstalled my PHP to C:\PHP\, in case the error was that the original install path had a space in it, "C:\Program Files\PHP\". As of right now, the only module that will load correctly is "php_sqlsrv_ts.dll". I put in two other modules, "php_exif.dll" and "php_mbstring.dll", and neither of those will load correctly either. I'm still getting: PHP Warning: PHP Startup: Unable to load dynamic library 'c:\\php\\ext\\php_mbstring.dll' - The specified module could not be found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'c:\\php\\ext\\php_exif.dll' - The specified module could not be found.\r\n in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'c:\\php\\ext\\php_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0 c.c I still don't get why I'm getting the double slashes... something to do with escape characters, maybe?

The frustrating thing is that "php_sqlsrv_ts.dll" seems to have no trouble loading at all, every time, yet "php_mssql.dll" which is in the exact same folder as "php_sqlsrv_ts.dll" never loads properly. I don't get it, I seriously don't get it... i will disperse my frustration by slitting my wrists and listening to emo music. c.c

So... c.c Might I ask what the difference is between the two. Y'know... other than the syntax? c.c

Oh... wait, are you saying that I should be using sqlsrv_connect instead of mssql_connect? c.c does this mean that... i... adsklajdkl *explodes*

See, I really don't know much about this stuff... First off... the phpinfo() info. Configuration File (php.ini) Path: C:\WINDOWS Loaded Configuration File: C:\Program Files\PHP\php.ini O_o; The path seems to be wrong, at C:\WINDOWS, yet... the file it actually loaded seems to be correct? C:\Program Files\PHP\php.ini is correct. As far as php_sqlsrv_ts.dll is concerned (the thread safe version is supposed to be used with Apache or something, hence the "_ts" on the end), I have gotten the php_sqlsrv_ts.dll module to appear correctly. But even when that is loaded, my php statement that I included on my original post still caused a blank screen, which leads me to believe that the function call I was using wasn't being recognized by php and so forth. From what I have read after googling around, php_sqlsrv_ts.dll can be used with MS SQL 2008...

So as it stands... I am still in a pickle jar! D: Hm. What was that you said about another DLL file that php_mssql.dll depended on? c.c Or for that matter... any ideas on what might be going on here? Oh and thanks for the lesson on file-paths

Well c.c, I'm trying various methods of slashes and backslashes, but to no avail! ... The following is from php.ini: ; UNIX: "/path1:/path2" ;include_path = ".:/php/includes" ; ; Windows: "\path1;\path2" ;include_path = ".;c:\php\includes" What purpose does the ".:" and the ".;" serve? The following is also from php.ini: ;extension_dir = "./" This is the commented out default value for extension_dir "./" ? A dot and a slash? I don't think I know what that... does? Enlighten me? D:

Oh wait a minute... PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Program Files\\PHP\\Ext\\php_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0 fffffffffuuuuuuuuuuuu-- Are those double backslashes supposed to be there? c.c I'm sure that is the right path.

Hm. Well, the absolute path reference works... but I'm getting the same results as before, the sqlsrv module appears, but the mssql module does not appear. As a side note, did you look at the photobucket images in my first post? c.c

Yes I read it! D: I left extension_dir in php.ini as the default... which I believe has it so the root directory, that is, the same directory that php.ini is in, will function as the extension directory? I put php_mssql.dll both there, and in system32 just for the hell of it. c.c extension_dir = "./" is what I have right now. Hm. *doing stuff*

O_O Apache error log! I shall check it momentarily! And yes, I'm using Apache HTTP server, version 2 point oh. (2.0) c.c you should contact me on AIM or something, real-time communication would be awesomesauce. ... Oh snap... "PHP Warning: PHP Startup: Unable to load dynamic library './php_mssql.dll' - The specified module could not be found.\r\n in Unknown on line 0" Oh god oh god what to do, what to do? D:

I added extension=php_mssql.dll into php.ini myself! I added: extension=php_sqlsrv_ts.dll as well! I'm using the tread safe version. Not only did I uncomment extension=php_mssql.dll, I uncommented the crap out if it!

Edit: I am using an Apache HTTP server, version 2.0. I have installed PHP version 5.2.8. I am using Windows XP Professional, service pack 2. I am using MS SQL Server Express Edition 2008. end edit. I've been reading through other threads on this forum, and I have the same issue as a lot of other people... just trying to get everything set up and working. I'm trying to connect to an MS SQL Server Express Edition 2008 through PHP. The part that I am stuck at right now... When I do a phpinfo() call, I do not see an "mssql" module anywhere, I do, however, see an "sqlsrv" module listed. As can be seen here: http://img.photobucket.com/albums/v228/Treeko/MS%20SQL%20Stuff/MSSQLHelp001.png And also as can be seen here: http://img.photobucket.com/albums/v228/Treeko/MS%20SQL%20Stuff/MSSQLHelp002.png ========== I have... I have this little bit o' kode right here: <?php $server = 'SECRET\SQLEXPRESS'; $link = mssql_connect($server, 'SECRET/Administrator', 'my administrator password'); if(!$link) { die('Something went wrong while connecting to MSSQL'); } ?> And I am sure that the line "$link = mssql_connect($server, 'SECRET/Administrator', 'PASSWORD');" is the problem c.c When I try to run this page, I just get a blank page displayed, which is what happens when you make a typo on a php function or something. So my guess is that the function "mssql_connect" is not being recognized, WHICH IS WHY I think that my uh... MS SQL support for PHP is not working properly. I'm also very unsure as to what... accounts/password I'm supposed to use to try to connect to an MS SQL database. Should I make a separate windows user account for connecting to MS SQL? Is that user account supposed to be... logged onto windows? Is it supposed to be an administrator account? Am I supposed to set up a password for the windows account, then use that same password to try and connect to the SQL Server? I just... don't know! Also, whoever directly aids me in solving my problem gets a free hug, but only one.