Re: [PHP-DB] Re: mssql connecting

2007-06-01 Thread David BERCOT
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

2007-06-01 Thread Sady Marcos
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

2007-05-31 Thread Sady Marcos
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

2007-05-29 Thread Bryan
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

2007-05-29 Thread Sady Marcos
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

2007-05-29 Thread Bryan
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