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!

    Posted 2 weeks ago #
  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

    Posted 2 weeks ago #
  3. Suppy, Member

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

    Posted 2 weeks ago #

Reply

You must log in to post.