SQL Complete error: SELECT SERVERPROPERTY('productversion');

AndrewBuis · Post by **AndrewBuis** » Tue 15 Nov 2011 16:21

I got an error when trying to query against a StarSQL (DB2 ODBC driver) linked server. The full error text is:

dbForge SQL Complete
Some errors has occurred while describing server scope objects:
Query index(0); Error: An error occurred while preparing the query "SELECT SERVERPROPERTY('productversion');" for execution against OLE DB provider "MSDASQL" for linked server "MyDB2LinkedServer".

I was wondering what this was about.

alexa · Post by **alexa** » Wed 16 Nov 2011 10:43

Describing of objects works only for Microsoft SQL Server servers. The message you're seeing is displayed for all other SQL servers.