I am preforming a simple query:
SELECT COUNT(*) FROM MyTable
The query fails when it's preformed on sql server and succeeds when sent to an Oracle database.
The Error code is: -2147217887
The Error description is:
"Database Error: Microsoft OLE DB Provider for Sql Server, Multiple-step OLE DB operation generated errors. Check each OLE DB s"
What could be the problem ?
Are there any special settings for the database (indexes or identities) that are critical for a SELECT querys that contain the COUNT function ?