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]
