Mono Support Installation issue: Incorrect syntax near '4'.  (Closed)

Viewed 36740 time(s), 12 post(s), 5/5/2014 10:37:30 PM - by theAmazingZar
6/26/2014 11:49:54 AM
1384 Reputation 152 Total posts

My guess would be that your database name starts with a "4".
Some of the install scripts don't have [] brackets around database name
So "USE 4real" would produce "Incorrect syntax near '4'."

You could replace in files (\MonoX\Installer\Sql\*.sql) all instances of "USE MonoX2;" to "USE [MonoX2]", or change database name to start with a letter.

11
7/2/2014 5:13:31 PM
41 Reputation 6 Total posts

Thanks @idrazic !!  That was it. You rock!

Maybe you guys should update the installation documentation to inform users to specify a correct DB name, or update the installation process so MonoX can accept different DB names? Just a thought.

12
1 2
This is a demo site for MonoX. Please visit Mono Software for more info.