Space in database name in connectionstring RRS feed

  • Question

  • User-2027757776 posted


    I am in trouble writing connectionstring in app.config. Actually database name contains space in its name. following is the connectionstring i want to put in app.config. but when i do the same it gives me error. how to solve this problem ?

    <add name="Connection" connectionString="Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Program Files\Insignia\Time & Attendence.mdb;Uid=;Pwd=admin;" />

    here, database is access db having name as 'Time & Attendence.mdb'

    Tuesday, July 27, 2010 2:48 AM


All replies