If you are using PHP as an ISAPI module, you need to restart the web service after
making changes to php.ini. The file is only read on startup.
php_mssql70.dll can be in \winnt\system32 or in yoy php directory (c:\php4). It is
important that your extension_dir in php.ini points to the right place. default is ./
and that indicates that php_mssql70.dll should be in the sam directory as php.exe (and
all other php binaries).
In order to use MS SQL server from a web server you also need to install a MS SQL
Client (from the cd) or at least copy ntwdblib.dll to \winnt\system32.
- Frank
> Here is what the windows extensions of my php.ini looks like:
>
> ;Windows Extensions
> ;extension=php_mysql.dll
> ;extension=php_nsmail.dll
> ;extension=php_calendar.dll
> ;extension=php_dbase.dll
> ;extension=php_filepro.dll
> ;extension=php_gd.dll
> ;extension=php_dbm.dll
> extension=php_mssql70.dll
> ;extension=php_zlib.dll
> ;extension=php_filepro.dll
> ;extension=php_imap4r2.dll
> ;extension=php_ldap.dll
> ;extension=php_crypt.dll
> ;extension=php_msql2.dll
> extension=php_odbc.dll
>
> And the mssql portion:
> [MSSQL]
> extension=php_mssql70.dll
>
> I checked and I do have that dll in c:\winnt\system32. I also have the data
> source setup on the web serve as a system dsn.
> Thanks!,
> Martin
>
> -----Original Message-----
> From: Michael Rudel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 1:31 PM
> To: Martin Rokicki; [EMAIL PROTECTED]
> Subject: RE: [PHP-WIN] mssql and odbc functions
>
>
> Hey Martin,
>
> First Problem (mssql): you don't have the mssql-extension running.
> Check it out in the php.ini and remove the ; before the appropriate line.
>
> Second Problem (odbc): I've never worked with mssql2k, but here a silly
> question that *might* be the problem: the system-dsn entry, is it set on
> the Web-Server ???
>
> Hope this helps, at least a bit =8)
>
> Greetinx,
>
> Michael Rudel
> - Web-Development, Systemadministration -
> _______________________________________________________________
>
> Suchtreffer AG
> Bleicherstraße 20
> D-78467 Konstanz
> Germany
> fon: +49-(0)7531-89207-17
> fax: +49-(0)7531-89207-13
> e-mail: mailto:[EMAIL PROTECTED]
> internet: http://www.suchtreffer.de
> _______________________________________________________________
>
>
>
> -----Original Message-----
> From: Martin Rokicki [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 01, 2001 7:08 PM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-WIN] mssql and odbc functions
>
>
> Hi All,
> Thanks for the advice on database connectivity. I've tried
> connecting to the mssql server (which is running 2000 not 6.5 as I had
> thought) with the mssql_connect function as well as the odbc_connect
> function. When I run the mssql connect I use this code:
> MSSQL_CONNECT($host,$user,$pass)
> The variables are all defined with the correct values, but I receive an
> error message:
> Fatal error: Call to undefined function: mssql_connect() in
> c:\inetpub\wwwroot\stpweb\test\mssql.php on line 7
> I've looked through the PHP documentation and tried a couple of fixes for
> this error, but no luck so far. Also when I try to connect to the database
> using odbc connect and this code:
> odbc_connect("dsn","uid","pas");
> I get this message:
> Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified, SQL state IM002 in SQLConnect
> I have the DSN defined as a system dsn, and it works when tested. I know I'm
> screwing something up, but I'm not sure what. Any help you could give would
> be appreciated.
>
> Regards,
> Martin
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
