#23325 [Opn->Fbk]: PHP can't connect if db name has dashes

From: Date: Wed, 30 Apr 2003 11:13:25 +0000
Subject: #23325 [Opn->Fbk]: PHP can't connect if db name has dashes
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-38814@lists.php.net to get a copy of this message
 ID:               23325
 Updated by:       sniper@php.net
 Reported By:      fritz at lateral dot net
-Status:           Open
+Status:           Feedback
 Bug Type:         MSSQL related
 Operating System: Win 2000
 PHP Version:      4.3.1
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip




Previous Comments:
------------------------------------------------------------------------

[2003-04-28 07:29:08] fritz at lateral dot net

Try creating a database called php-bugs-list and one 
called php_bugs_list.

mssql_connect('localhost','username','pwd') or die 
'mssql_connect error';
mssql_select_db('php-bugs-list') or die 
'mssql_select_db error';

mssql_connect('localhost','username','pwd') or die 
'mssql_connect error';
mssql_select_db('php_bugs_list') or die 
'mssql_select_db error';

I am not 'demanding' a fix - I have learnt that I will 
avoid errors by having no dashes in the database name. 
My problem is solved.
I tried to share this with other php users, If you want 
to use this information to improve php you are welcome 
to it - but please don't waste my time by being anal 
about how the bug is reported.

And that's the end of it, AFAIAC.

------------------------------------------------------------------------

[2003-04-28 07:11:52] derick@php.net

my my my... what a nice attitude we have again. From the "How to report
a bug" page:

    * Provide code that demonstrates the problem, it should almost
never be more than ten lines long. Anything longer probably contains a
lot of code that has nothing to do with the problem, which just makes
it take longer to figure out the real problem. (But don't forget to
make sure that your code still demonstrates the bug you're reporting
and doesn't have some other problem because you've accidently trimmed
out something you thought wasn't important but was!)

The URL for this is: http://bugs.php.net/how-to-report.php

Don't forget we're volunteers and are not particulary fond of people
who start shouting and demand a fix while they are not willing to
produce a useful bugreport.

------------------------------------------------------------------------

[2003-04-28 07:05:47] fritz at lateral dot net

What do you mean, 'Not enough information was 
provided'???

It's very simple - the category is MSSQL related.
The OS is Win 2000.
If the name of the (MSSQL) database contains dashes, a 
PHP page running under Apache cannot connect to it.
If I try connecting to it from an ASP, page running 
under IIS, I can connect allright.
If I rename the database and remove the dashes I can 
connect from either PHP/Apache or IIS/ASP.

What other information do you need? My star sign is 
aquarius. I was wearing grey socks when the error 
occured.... ?!!?

------------------------------------------------------------------------

[2003-04-25 12:23:04] sniper@php.net

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.




------------------------------------------------------------------------

[2003-04-24 06:20:02] fritz at lateral dot net

If the name of the database has a dash in it, e.g. php-bugs-list, php
running under apache is not able to connect - I can connect using ASP
in IIS.



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=23325&edit=1



Thread (11 messages)

« previous php.bugs (#38814) next »