MSSQL 2000
-
Hello. First wanted to say thank you for your project.
I am having an issue with installation on MSSQL 2000 using 1.2.10.
Seems all the Create tables work, but all the create index's and insert statements are failing.
This occurs with the sql driver and the odbc driver.
I think I have it traced to the fact that mssql2000 wants user.table to resolve names.
So I needed to modify my dbinit_mssql to remove all the CREATE's (they already executed), and prepend "netxms." to each table reference.
Thoughts?
edited: spelling
-
Prior to determining this, I was left with a system that was installed, but the service would not start.
nxdbmgr check and upgrade both reported 'Unable to determine database syntax'
That is what led me to manually inspect the metadata table and saw that it was empty.
-
It looks like a singe USE DBNAME; at the top of the sql script will help, but at this point I am trying to fix up the existing install.
I am only carrying on with this to see if maybe the install script needs to know if we are using mssql 2000 vs a later version and include the "USE netxms_db;" statement.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login