Error when "-" in Database-Name

(3 posts) (2 voices)

Tags:

No tags yet.

  1. Suppy, Member

    Hi All

    I am testing myDBR for the first time and was unable to get Objects in the Query-Builder. I always get an Error

    ***
    SQLSTATE: 42000, code: 102
    [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Falsche Syntax in der Nähe von "-".SQLSTATE: 42000, code: 102
    Falsche Syntax in der Nähe von "-".
    SQL: sp_MyDBR_db_objects 'PC-Supporting-GmbH'
    ***

    (I am using the german version, the Error is telling me that there is an error near "-"...)

    Some time later I discovered that if the Database contains the character "-" in it's name this Error occures. If not, everything is fine.

    Is this a bug or can I do anything to solve it myself (except change the Name of our main Database)?

    Thanks in advance for your help!

  2. myDBR Team, Key Master

    Hi,
    run the automatic updater and you will get a new version which handles the minus-character in database names in the query builder better when running SQL Server.

    --
    myDBR Team

  3. Suppy, Member

    Boah, Lightning-Fast-Solution. Perfect, works great!


Reply

You must log in to post.