Do not use dashes (-) in an SQL database name 1

[RobHVB6Sql]

PROBLEM CAUSED:
Crystal Reports will connect to the server, connect to the database and show a list of stored procedures.
It will give a 'Syntax error or access violation' message when you attempt to use the stored procedure in a report.

SOLUTION:
Do not use a dash (-) in the naming of databases on SQL servers. Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)

 

[Transcend]

Here are some links related to this:

http://vyaskn.tripod.com/object_naming.htm

http://www.right-clickconsulting.com/ss2k/snaming.asp

http://vyaskn.tripod.com/coding_conventions.htm

Transcend

 

[RobHVB6Sql]

Sorry the links mentioned in the response above do not mention any conventions or hints for SQL database names. I also found nothing on the CrystalDecisions website re this problem. Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)

 

[Transcend]

How do pages titled "Database object naming conventions" and "SQL Server Suggested Naming Standards" NOT mention naming conventions .... ????

Actually .. the links are all different takes on naming conventions in databases in general.

Are you serious? Did you even read them?

Transcend

 

[Transcend]

If they weren't specific enough how about

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adoce31/html/adoguide_27.asp

Transcend

 

[RobHVB6Sql]

I didin't want to start an argument, just alert people to this.

An SQL database name 'Dbname-Test' is perfectly valid in SQL. The dash (-) is an explicitly allowed character. However when you attempt to use stored procedures with Crystal Reports 8.5 you will have problems. The solution is to rename it 'DBnameTest'. Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)

 

[Transcend]

Ah ... now i'm with you

so sorry for being bitchy

have a star

Transcend

 

[chelseatech]

I had a client who had a table with some file information, so named their SQL table "File"

Thats a reserved word so Cr couldn't report of it at all.

I created a view "vwFile" as
Select * from [File]

and i could then get the data into a report.

How do we stop accountants from designing databases when they don't understand these rules? Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Transcend]

Take away all their database design tools and force them to go through their IT section

I work for a government department in the IT branch and we had a big problem with users making their own access/db apps, then running into problems and getting us to support them. Next time we designed an SOE they only got access runtime

Transcend