#20873 [Opn->Bgs]: DSN with space will not work

ID: 20873 Updated by: iliaa@php.net Reported By: mykbaker@msn.com -Status: Open +Status: Bogus Bug Type: ODBC related Operating System: Win XP Pro PHP Version: 4.2.3 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Thank you for your interest in PHP. Given the error message you've recieved I'd say the problem is not PHP, but rather something else, possible solutions are described in the SQL error message. Previous Comments: ------------------------------------------------------------------------ [2002-12-07 01:58:36] mykbaker@msn.com Using odbc_connect with a DSN with a space causes error: Code: $cnx = odbc_connect("BSU Directory","","") or die(odbc_error()); Error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\mbaker\Project\processInst.php on line 20 S1000 The same DSN works fine with a ColdFusion template and other DSNs work fine with PHP. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20873&edit=1