Sunday, July 31, 2011

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

You may get the above error when trying to open the database diagram or trying to create a new diagram.

Solution

ALTER AUTHORIZATION ON DATABASE::DTLDW TO sa

or

Assign the Database owner to a valid login by right clicking on the database and choose properties > file.

Wednesday, July 20, 2011

The setup routines for the Lotus NotesSQL Driver(*.nsf) ODBC driver could not be loaded due to system error code 126.

I tried to create a system DSN for ODBC connection to the Lotus Notes Database and I got the following error:

"The setup routines for the Lotus NotesSQL Driver(*.nsf) ODBC driver could not be loaded due to system error code 126."

Solution
Just append the Lotus Installation Path to the Path environment variable and try setting up the DSN again and it will work.

Tuesday, July 12, 2011

Variable: not found in bash script

I was trying to assign a value to a variable using bash script and got this error.

Solution

You can't have space around the "=" sign. Remove the space around the equal to sign and run the script.