Microsoft SQL 2000 - table names

Ask a Question related to Coldfusion Server Administration, Design and Development.

  1. #1

    Default Microsoft SQL 2000 - table names

    Hi.
    I want to access some tables in a Microsoft SQL 2000 database. But the tables
    has names with the character "-" (hypen).
    I understand that this is not "legal" in normal SQL, but an "extension" in
    Microsoft SQL.
    My problem is that I can not make SELECT queries to theese tables. Queries to
    other tables (without hypen in the name) in the same database is woring fine.

    I have tried several suggestions with characters like ' and [ around the table
    name in the query without success.
    I have also tried
    - Updataing the Microsoft SQL 2000 driver
    - Updated DataDirect JDBC drivers (version 3.5)
    - Configuring the Microsoft SQL Server 2000 JDBC driver

    Sadly, I may not change the table names. The database is a part of a big
    soloution for imposition and printing newspaper pages.
    For a long time I have been looking for somebody with a similar problem
    without success.

    Can anybody help me?

    Eindride Guest

  2. Similar Questions and Discussions

    1. Table names in Microsoft SQL with hypen
      Hi. I want to access some tables in a Microsoft SQL 2000 database. But the tables has names with the character "-" (hypen). I understand that this...
    2. Coldfusion MX and Microsoft SQL 2000
      If I were to connect Coldfusion MX to a MS SQL 2000 server database, how many CALs do I need for the MS SQL Server? Is it the number of users I have...
    3. Microsoft Home Publishing 2000
      I just finished designing a 6 page website. I need to get to the source code to cut and paste in some PayPal code. How do I access the source code...
    4. Need html help for MicroSoft Publisher 2000
      Subject: Need html help for MicroSoft Publisher 2000 From: "Barbara" <photosbybarbara@yahoo.com> Sent: 10/9/2003 7:10:17 AM I just recently...
    5. Photoshop 7 and IR for Windows 2000 also operate on Microsoft XP OS?
      Hi, Will Photoshop 7 and IR for Windows 2000 also operate on Microsoft XP OS?
  3. #2

    Default Re: Microsoft SQL 2000 - table names

    Thank You! Thank You! Thank You! Thank You! Thank You!

    I have tried a lot with square brackets around the "hole name" like:
    FROM [dbo.Tb2005-09-12$NAT$ONE$$_]

    But the solution was very simple:
    FROM dbo.[Tb2005-09-12$NAT$ONE$$_]

    I?m very happy right now! Tell me what to do in return.

    Thank You kim il sung and Dan

    Eindride Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139