MS-SQL connect fails on a database with a hyphen in the name.
Posted on 2004-10-08
I am using mssql_select_db as part of ADODB 4.5.3 under PHP 4.3.9 on windows XPsp1
I have modified the SelectDb method to echo out some parameters as it goes...
Attepting connection to uk-argo-asp-01_LM_W3SVC_1_Collab
ConnectionID = Resource id #7
Then the mssql_select_db(...) is called and this error is outputted with connection debug on.
127.1.1.104: Could not locate entry in sysdatabases for database 'uk'. No entry found with that name. Make sure that the name is entered correctly.
My connection to, and credentials on the database are sound as I can connect to the Northwind database (with a different erro regarding ODBC version and ntext).
The problem is that the mssql_... appears to be truncating the name. However, I did have ADODB version 2.42 and this did not appear to happen, but I am forced to upgrade as I require funcionality in the new version.
Any ideas how I can escape the name, or fix the problem?
Thanks in advance.