RE: [PHP-DB] Windows XP and PHP
A better solution for connecting to SQL Server is the php_odbtp_mssql.dll extension available at http://odbtp.sourceforge.net. The reason why is because the php_mssql.dll was built using DB-Library, which is obsolete and unsupported by Microsoft. This is why ntwdblib.dll is not in MDAC, and contains bugs that will never be fixed. The php_odbtp_mssql.dll file supports all of the functions from the php_mssql.dll file. And, unlike the php_mssql.dll, it supports all of the new data types available in SQL Server 2000, such as, varchar(255), nvarchar and ntext. -- bob On Sun, 8 Feb 2004, Duane Lakoduk wrote: I had this bookmarked too, and I had forgotten about it. Would installing the MDAC Microsoft have on their site install the ntwdblib.dll? Don't think so, I have current MDAC installed and it is not on my ws. I just found this on: http://www.php.net/function.mssql-connect GET ntwdblib.dll This dll can also be found in the binary zip of php 4.3 in the dlls subdir. put it in the system32 dir. WATCH OUT... i used a copy found on a MSSQL server, used that.. couldn't get it to work.. My function calls seamed OK, could call the mssql routines but I got a connection error When I used the dll distributed with the binary zip of php 4.3 it worked. -- 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] Windows XP and PHP
I installed Apache/Perl/PHP onto a Windows XP machine today and ran into this problem when I tried to access the MS SQL Server via PHP: can't load dynamic library php_mssql.dll The dll is in the extensions directory. Apache is running fine. Any ideas, on what might be wrong? I think this is in the php documentation but here is an answer from: http://forums.devshed.com/archive/5/2002/11/2/47028 = MSSQL connection using PHP (ERROR) micros_bytes This is happening because you do not have the required MS-SQL client libraries. In addition to having the PHP extension DLL, you have to have the Microsoft DLLs for accessing SQL Server. I don't recall the exact files but you can get them by installing the SQL Server Client Tools from the SQL Server install CD. Once you have that installed, you should be able to connect without errors. = -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Windows XP and PHP
Duane Lakoduk wrote: I installed Apache/Perl/PHP onto a Windows XP machine today and ran into this problem when I tried to access the MS SQL Server via PHP: can't load dynamic library php_mssql.dll The dll is in the extensions directory. Apache is running fine. Any ideas, on what might be wrong? I think this is in the php documentation but here is an answer from: http://forums.devshed.com/archive/5/2002/11/2/47028 = MSSQL connection using PHP (ERROR) micros_bytes This is happening because you do not have the required MS-SQL client libraries. In addition to having the PHP extension DLL, you have to have the Microsoft DLLs for accessing SQL Server. I don't recall the exact files but you can get them by installing the SQL Server Client Tools from the SQL Server install CD. Once you have that installed, you should be able to connect without errors. = I had this bookmarked too, and I had forgotten about it. Would installing the MDAC Microsoft have on their site install the ntwdblib.dll? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Windows XP and PHP
I had this bookmarked too, and I had forgotten about it. Would installing the MDAC Microsoft have on their site install the ntwdblib.dll? Don't think so, I have current MDAC installed and it is not on my ws. I just found this on: http://www.php.net/function.mssql-connect GET ntwdblib.dll This dll can also be found in the binary zip of php 4.3 in the dlls subdir. put it in the system32 dir. WATCH OUT... i used a copy found on a MSSQL server, used that.. couldn't get it to work.. My function calls seamed OK, could call the mssql routines but I got a connection error When I used the dll distributed with the binary zip of php 4.3 it worked. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Windows XP and PHP
I had this bookmarked too, and I had forgotten about it. Would installing the MDAC Microsoft have on their site install the ntwdblib.dll? I just checked php-4.3.4-WIN32.zip and ntwdblib.dll is in there. Drop it in your extensions directory and make sure the line: extension=php_mssql.dll ... in the ;Windows Extensions section of php.ini is uncommented. Verify your - extension_dir = path - setting also. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
