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

ID: 23325 Updated by: sniper@php.net Reported By: fritz at lateral dot net -Status: Feedback +Status: No Feedback Bug Type: MSSQL related Operating System: Win 2000 PHP Version: 4.3.1 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2003-04-30 06:13:24] sniper@php.net 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 ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/23325 -- Edit this bug report at http://bugs.php.net/?id=23325&edit=1