Ask a Question related to Coldfusion Server Administration, Design and Development.
-
Eindride #1
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
-
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... -
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... -
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... -
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... -
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? -
Eindride #2
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



Reply With Quote

