Fix ‘The application “SQLDeveloper.app” can’t be opened.’

If you just installed SQL Developer on a Mac, but you’re getting an error when trying to launch it, try the steps below to fix it.

The error reads “The application “SQLDeveloper.app” can’t be opened because Apple cannot check it for malicious software“. It also mentions that “This software needs to be updated. Contact the developer for more information“.

Below are the steps I used to overcome this issue, and launch SQL Developer.

Continue reading

OPENROWSET does not accept variables for its arguments (SQL Server)

If you’re trying to use OPENROWSET to run an ad hoc distributed query in SQL Server, but you keep getting an “incorrect syntax” error, and you just can’t see anything wrong with your syntax, it could be that you’re trying to use a variable for one of the arguments.

As mentioned in the title of this post, OPENROWSET does not accept variables for its arguments.

If you’re using variables as arguments, try changing these to string literals.

Continue reading