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

ID: 23325 User updated by: fritz at lateral dot net Reported By: fritz at lateral dot net -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: Win 2000 PHP Version: 4.3.1 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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