Re: RE: [PHP-WIN] mssql and odbc functions

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:mru@suchtreffer.de] > Sent: Thursday, March 01, 2001 1:31 PM > To: Martin Rokicki; php-windows@lists.php.net > 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:mru@suchtreffer.de > internet: http://www.suchtreffer.de > _______________________________________________________________ > > > > -----Original Message----- > From: Martin Rokicki [mailto:Martin_Rokicki@Jabil.com] > Sent: Thursday, March 01, 2001 7:08 PM > To: 'php-windows@lists.php.net' > 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: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >