RE: [PHP-WIN] mssql and odbc functions

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