help, dont know what to do now, PHP, MS SQL Server 2005,

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
RichardTaft
Forum Newbie
Posts: 6
Joined: Mon Mar 06, 2006 6:44 pm

help, dont know what to do now, PHP, MS SQL Server 2005,

Post by RichardTaft »

cant connect to database, if needed i can suply copy of php.ini file

msql and mssql dlls have been added to file holding php.exe
ini file has ben modified

anyone have time to help me with this
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

does running phpinfo() show that the mssql extension is loaded?
RichardTaft
Forum Newbie
Posts: 6
Joined: Mon Mar 06, 2006 6:44 pm

Post by RichardTaft »

wish i knew, here is a link to my web site,the phpinfo file

http://portlandz24.dyndns.org/info.php
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Code: Select all

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\php\php_mssql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'C:\php\php_msql.dll' - The specified module could not be found. in Unknown on line 0
Seems like your extension directory directive isn't set right or you wrote the extension load line wrong. You have C:\php set as the extension directory, is this where the extensions are? (Normally, they are in C:\php\ext)
RichardTaft
Forum Newbie
Posts: 6
Joined: Mon Mar 06, 2006 6:44 pm

Post by RichardTaft »

made the changes, ensured that the ext file was in the php\ext zone with all dlls available
still no go, any config suggestions

link to php.ini file
in winzip file
http://portlandz24.dyndns.org/portlandz24/php.zip

am using php 5
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Did you happen to use the installer version of PHP? If so, download the zip version which includes a bunch of "common" extensions that the installer does not.
RichardTaft
Forum Newbie
Posts: 6
Joined: Mon Mar 06, 2006 6:44 pm

Post by RichardTaft »

grabbed both placed installer within the file then ran installer

verifyed that the required dlls are there
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

So the file is at C:\php\ext\php_mssql.dll? Because the error you're getting on the phpinfo page says otherwise.
RichardTaft
Forum Newbie
Posts: 6
Joined: Mon Mar 06, 2006 6:44 pm

Post by RichardTaft »

absolutely, only problem, in services i dont see anything that is php related

last ditch effort i will restart my server
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

..and you've installed the Client Tools from the SQL Server CD?
RichardTaft
Forum Newbie
Posts: 6
Joined: Mon Mar 06, 2006 6:44 pm

Post by RichardTaft »

as far as i could tell i have done a complete install
Post Reply