Re: [PHP-DB] Re: mssql connecting
Hi, Le Thu, 31 May 2007 13:46:47 -0300, Sady Marcos [EMAIL PROTECTED] a écrit : The SQL Server 2000, installed in a Windows 2003 Server, only accepted remote connections later that the DB will be with the SP3 or 4 installed. In my company, we detect this problem, and alone installing the SP that the applications had come back to function. For the PHP, it was as if the SQL did not exist in the server that we were specifying. This is very interesting. It looks like I have the same problem, but my MSDE (SQL Server 2000) is on Windows XP. Is there a same bug with XP ? Thank you. David. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: mssql connecting
For that I read, the SQL Server 2000 with equal or lesser SP 2 has one bug of security guard that allows the execution of archives together with instructions (I did not enter in the details). Therefore it is necessary that SP 3 or 4 is installed in the Windows 2003 Server. In the XP I do not know if it needs, but test and in informs them. I wait to have helped. Hi, Le Thu, 31 May 2007 13:46:47 -0300, Sady Marcos [EMAIL PROTECTED] a écrit : The SQL Server 2000, installed in a Windows 2003 Server, only accepted remote connections later that the DB will be with the SP3 or 4 installed. In my company, we detect this problem, and alone installing the SP that the applications had come back to function. For the PHP, it was as if the SQL did not exist in the server that we were specifying. This is very interesting. It looks like I have the same problem, but my MSDE (SQL Server 2000) is on Windows XP. Is there a same bug with XP ? Thank you. David. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: mssql connecting
The SQL Server 2000, installed in a Windows 2003 Server, only accepted remote connections later that the DB will be with the SP3 or 4 installed. In my company, we detect this problem, and alone installing the SP that the applications had come back to function. For the PHP, it was as if the SQL did not exist in the server that we were specifying. Bryan [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I'm trying to connect from a totally different server. I don't think SP4 has anything to do with it. Thanks though. ;-) Sady Marcos wrote: Install SP4 of the SQL Server Bryan [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I've tried installing php-mssql-5.0.4-10.1.i386.rpm and it shows that it needs the dependency of libsybdb.so.5. So I try to install freetds-0.64-1.rh9.rf.i386.rpm and it shows that it needs the dependency of libreadline.so.4. I check my server and it already has libreadline.so.5. What do I need to do now? Any help would be extremely appreciated. ;-) Maybe if someone in the Austin, Texas area can help, I can give them a discount on a bass fishing guide trip. LOL Thanks... Bryan wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any ideas? It just gives me the wonderful error: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in file. I also have Plesk 8.1 on the linux box so if I need to recompile php, would it break anything? I've installed freetds as well but haven't recompiled php questioning the above. Thanks for any and all help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: mssql connecting
I've tried installing php-mssql-5.0.4-10.1.i386.rpm and it shows that it needs the dependency of libsybdb.so.5. So I try to install freetds-0.64-1.rh9.rf.i386.rpm and it shows that it needs the dependency of libreadline.so.4. I check my server and it already has libreadline.so.5. What do I need to do now? Any help would be extremely appreciated. ;-) Maybe if someone in the Austin, Texas area can help, I can give them a discount on a bass fishing guide trip. LOL Thanks... Bryan wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any ideas? It just gives me the wonderful error: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in file. I also have Plesk 8.1 on the linux box so if I need to recompile php, would it break anything? I've installed freetds as well but haven't recompiled php questioning the above. Thanks for any and all help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: mssql connecting
Install SP4 of the SQL Server Bryan [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I've tried installing php-mssql-5.0.4-10.1.i386.rpm and it shows that it needs the dependency of libsybdb.so.5. So I try to install freetds-0.64-1.rh9.rf.i386.rpm and it shows that it needs the dependency of libreadline.so.4. I check my server and it already has libreadline.so.5. What do I need to do now? Any help would be extremely appreciated. ;-) Maybe if someone in the Austin, Texas area can help, I can give them a discount on a bass fishing guide trip. LOL Thanks... Bryan wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any ideas? It just gives me the wonderful error: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in file. I also have Plesk 8.1 on the linux box so if I need to recompile php, would it break anything? I've installed freetds as well but haven't recompiled php questioning the above. Thanks for any and all help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: mssql connecting
I'm trying to connect from a totally different server. I don't think SP4 has anything to do with it. Thanks though. ;-) Sady Marcos wrote: Install SP4 of the SQL Server Bryan [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I've tried installing php-mssql-5.0.4-10.1.i386.rpm and it shows that it needs the dependency of libsybdb.so.5. So I try to install freetds-0.64-1.rh9.rf.i386.rpm and it shows that it needs the dependency of libreadline.so.4. I check my server and it already has libreadline.so.5. What do I need to do now? Any help would be extremely appreciated. ;-) Maybe if someone in the Austin, Texas area can help, I can give them a discount on a bass fishing guide trip. LOL Thanks... Bryan wrote: I'm trying to connect to mssql 2000 on a windows server 2003 standard box using php v5.1.6/apache 2.2.2 fedora core 4 on a separate box, of course. Any ideas? It just gives me the wonderful error: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in file. I also have Plesk 8.1 on the linux box so if I need to recompile php, would it break anything? I've installed freetds as well but haven't recompiled php questioning the above. Thanks for any and all help... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php