mssql connecting

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 .

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

Re: mssql connecting

------=_Part_140143_7066698.1179945478879
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Did you already try these steps?

http://us2.php.net/manual/en/function.mssql-connect.php#7091 8



On 5/23/07, 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 .
>
> 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
>
>

------=_Part_140143_7066698.1179945478879--

Re: mssql connecting

Hi,

Le Wed, 23 May 2007 14:37:58 -0400,
"Dan Shirah" a écrit :
> Did you already try these steps?
>=20
> http://us2.php.net/manual/en/function.mssql-connect.php#7091 8

Hum, these steps are for PHP on IIS (i.e. Windows) (even if, later,
someone talks about Linux).
The question (I have almost the same) is for PHP on Linux !!!

David.

> On 5/23/07, 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 .
> >
> > 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

Re: mssql connecting

I also use PHP/SQL Server, but my server is the IIS.
To make the PHP to have access the SQL Server 2000 in the Windows 2003
server, you he will need to install SP 4 of the SQL Server.

"David BERCOT" escreveu na mensagem
news:20070524083728.707d0269@localhost...
Hi,

Le Wed, 23 May 2007 14:37:58 -0400,
"Dan Shirah" a écrit :
> Did you already try these steps?
>
> http://us2.php.net/manual/en/function.mssql-connect.php#7091 8

Hum, these steps are for PHP on IIS (i.e. Windows) (even if, later,
someone talks about Linux).
The question (I have almost the same) is for PHP on Linux !!!

David.

> On 5/23/07, 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 .
> >
> > 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

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 .
>
> 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

Re: mssql connecting

Install SP4 of the SQL Server

"Bryan" escreveu na mensagem
news:1B.13.10662.2F15C564@pb1.pair.com...
> 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 .
>>
>> 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

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" escreveu na mensagem
> news:1B.13.10662.2F15C564@pb1.pair.com...
>> 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 .
>>>
>>> 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

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" escreveu na mensagem
news:91.A8.10662.B6A6C564@pb1.pair.com...
> 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" escreveu na mensagem
>> news:1B.13.10662.2F15C564@pb1.pair.com...
>>> 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 .
>>>>
>>>> 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

Re: Re: mssql connecting

Hi,

Le Thu, 31 May 2007 13:46:47 -0300,
"Sady Marcos" 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: 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" 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