SQL Server Performance

SQL Server Naming

Discussion in 'General Developer Questions' started by tnmcfadden, Jul 3, 2003.

  1. tnmcfadden New Member

    I am working with a database that many people access that has a space in the name. I am trying to create some views to this database, but the programming tool I use does not like the space. Without changing the name, which I do not have rights to do, does anyone know of a way to make my programming tool think the name is okay with the space?

    A SQL co-worker suggested putting the database name in [], but that did not work. Any other suggestions?

    Thanks. Martha
    tnmcfadden, Jul 3, 2003
    #2

  2. vbkenya New Member

    The [] or "" always work with ODBC or OLEDB-connected queries sent to SQL server. In fact an ADO connection string doesn't even need any of the quotation marks or brackets to connect to SQL server.

    So the question is:

    • What tool are you using?


    Nathan H.O.
    vbkenya, Jul 3, 2003
    #2

  3. tnmcfadden New Member

    I am using GeneXus by Artech. Not used a whole lot here in the US, but very widespread in South America and Central America.
    tnmcfadden, Jul 3, 2003
    #2

  4. tnmcfadden New Member

    Thanks! I connected using the " ".
    tnmcfadden, Jul 3, 2003
    #2

  5. vbkenya New Member

    Strange that such a great tool (according to their website) would be debilitatingly selective - I haven't confirmed this limitation though.

    Nathan H.O.
    vbkenya, Jul 3, 2003
    #2

Share This Page