Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Incorrect syntax near the keyword 'ON'

Author  Topic 

dragonsting
Starting Member

7 Posts

Posted - 2008-04-06 : 04:45:32
Hi,

I have a problem when I try to install software that creates a database in SQL called "SNOWDB". I have a WK3 server with SQL 2000 SP4 installed, when the software try's to create teh DB I get the following popup error:
---------------------------
setup
---------------------------
Failed to create database "".

Error description: Incorrect syntax near the keyword 'ON'.
---------------------------
OK
---------------------------

It looks like it is trying to create a non existing database.
It is a reinstall of all the software.
I uninstalled the software and uninstalled SQL 2000 SP4, after a reboot I installed SQL 2005 and Installed the software and got the same error. I deinstalled it all again and installed SQL 2000 SP4 and I keep getting this error.

When I installed it on a clean machine it all goes fine and I have done that about 50 times now.

Please Advise, I Also Made asked support at the vendor of the software.

Thank you

Iwan

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-06 : 10:39:34
why you need software to create database? can't you do with ssms? Is that company rules?
Go to Top of Page

dragonsting
Starting Member

7 Posts

Posted - 2008-04-06 : 10:51:42
quote:
Originally posted by sodeep

why you need software to create database? can't you do with ssms? Is that company rules?



Hi, The software is what is important and SQL is a prerequisite for the software to work.
It creates the Database during install. Otherwise I would've create the database manually but that does not work.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-04-06 : 11:00:37
What is the name of software?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-06 : 16:32:09
you should contact vendor in this case.
Go to Top of Page
   

- Advertisement -