Re: [PHP-DB] SQL Server Connect Issues

2003-11-03 Thread Frank M. Kromann
Hi Tom,

What you need to get the instalation to work is these:

php.exe (CGI version)
php4ts.dll
php_mssql.dll
php.ini

in the same directory. I know you can make many different combinations of
files and directories but this minimum will work. You can aslo also add
php4isapi.dll if you want to use the ISAPI version over the CGI version,
and any other extensions can be added as needed.

In order to load the mssql extension (from php.ini or with the dl()
function) you need to install the MSSQL Client Tools on the box running
php. These tools can be found on the MSSQL Server CD, or you can simply
copy ntwdblib.dll from the SQL Server tp the web server, but this will not
install the tools needed to change the configuration!

- Frank

> First, I will admit that I am new to PHP.  I'm installing PHP on our
Windows
> 2K / IIS server for some users who want to use it.  We also host SQL
Server
> 7 for websites.  I'm getting the following error on the server, and on
the
> client's webpages:
> 
> PHP Warning: Unknown(): Invalid library (maybe not a PHP library)
'msql.dll'
> in Unknown on line 0
> 
> Here is what I have done so far:
> 
> - I originally installed PHP 4.3.3 on the server using the Windows
Installer
> version.
> - Uncommented out the extension=php_mssql.dll line inside of the
php.ini
> file.
> - Figured out that I needed to download the extensions since they
weren't
> included in the Installer version.
> - Added all of the php_*.dll files to the same directory as the PHP.EXE
> file.  (I've also tried putting these in the WINNT\System32 directory,
with
> the same luck.)
> - Made sure the msql.dll file is in the same directory as the PHP.EXE
file.
> (Again...tried in the WINNT\System32 directory.)
> - Made sure the ntwdblib.dll file was in the same directory as the
PHP.EXE
> file.  (As above...tried the WINNT\System32 directory.)
> 
> Originally, I was having problems with an error about the msql.dll file
not
> being found.  Once I had it put into place, then the current error
message
> came about, and I have not been able to get it to go away.
> 
> I've tried about everything I could find on the Internet about this type
of
> error.  The strange thing is that it appears to be talking to SQL
Server
> just fine, since the PHPBB program I also installed for one user
connected
> to the database at least long enough to create all of the tables and
fields
> required in the install.php file.
> 
> I keep seeing information about having to recompile the PHP.EXE with
certain
> settings using FreeTDS, but from what I have gathered, that is only
required
> if running on Linux.  (Right??)
> 
> Any help anyone can give me would be great.
> 
> Thanks,
> 
> ~ Tom
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] SQL Server Connect Issues

2003-11-03 Thread Alain Barthélemy
It may of course not be a solution but personnally I installed Apache on
port 8100 with PHP on W2000 and it works fine with MySQL and/or MsSQL.
Just in case ...

AB

Le lundi 03 novembre 2003, 15:31:08 ou environ Thomas W. Gallup <[EMAIL PROTECTED]> a 
écrit:
> First, I will admit that I am new to PHP.  I'm installing PHP on our Windows
> 2K / IIS server for some users who want to use it.  We also host SQL Server
> 7 for websites.  I'm getting the following error on the server, and on the
> client's webpages:
> 
> PHP Warning: Unknown(): Invalid library (maybe not a PHP library) 'msql.dll'
> in Unknown on line 0
> 
> Here is what I have done so far:
> 
> - I originally installed PHP 4.3.3 on the server using the Windows Installer
> version.
> - Uncommented out the extension=php_mssql.dll line inside of the php.ini
> file.
> - Figured out that I needed to download the extensions since they weren't
> included in the Installer version.
> - Added all of the php_*.dll files to the same directory as the PHP.EXE
> file.  (I've also tried putting these in the WINNT\System32 directory, with
> the same luck.)
> - Made sure the msql.dll file is in the same directory as the PHP.EXE file.
> (Again...tried in the WINNT\System32 directory.)
> - Made sure the ntwdblib.dll file was in the same directory as the PHP.EXE
> file.  (As above...tried the WINNT\System32 directory.)
> 
> Originally, I was having problems with an error about the msql.dll file not
> being found.  Once I had it put into place, then the current error message
> came about, and I have not been able to get it to go away.
> 
> I've tried about everything I could find on the Internet about this type of
> error.  The strange thing is that it appears to be talking to SQL Server
> just fine, since the PHPBB program I also installed for one user connected
> to the database at least long enough to create all of the tables and fields
> required in the install.php file.
> 
> I keep seeing information about having to recompile the PHP.EXE with certain
> settings using FreeTDS, but from what I have gathered, that is only required
> if running on Linux.  (Right??)
> 
> Any help anyone can give me would be great.
> 
> Thanks,
> 
> ~ Tom
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
Alain Barthélemy
[EMAIL PROTECTED]
http://bartydeux.be
Linux User #315631

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] SQL Server Connect Issues

2003-11-03 Thread Thomas W. Gallup
First, I will admit that I am new to PHP.  I'm installing PHP on our Windows
2K / IIS server for some users who want to use it.  We also host SQL Server
7 for websites.  I'm getting the following error on the server, and on the
client's webpages:

PHP Warning: Unknown(): Invalid library (maybe not a PHP library) 'msql.dll'
in Unknown on line 0

Here is what I have done so far:

- I originally installed PHP 4.3.3 on the server using the Windows Installer
version.
- Uncommented out the extension=php_mssql.dll line inside of the php.ini
file.
- Figured out that I needed to download the extensions since they weren't
included in the Installer version.
- Added all of the php_*.dll files to the same directory as the PHP.EXE
file.  (I've also tried putting these in the WINNT\System32 directory, with
the same luck.)
- Made sure the msql.dll file is in the same directory as the PHP.EXE file.
(Again...tried in the WINNT\System32 directory.)
- Made sure the ntwdblib.dll file was in the same directory as the PHP.EXE
file.  (As above...tried the WINNT\System32 directory.)

Originally, I was having problems with an error about the msql.dll file not
being found.  Once I had it put into place, then the current error message
came about, and I have not been able to get it to go away.

I've tried about everything I could find on the Internet about this type of
error.  The strange thing is that it appears to be talking to SQL Server
just fine, since the PHPBB program I also installed for one user connected
to the database at least long enough to create all of the tables and fields
required in the install.php file.

I keep seeing information about having to recompile the PHP.EXE with certain
settings using FreeTDS, but from what I have gathered, that is only required
if running on Linux.  (Right??)

Any help anyone can give me would be great.

Thanks,

~ Tom

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php