We are using the Excel Export SO with ADO Query. but while retrieving the data getting the error”Unable to determine the identity of domain”, we susppect the Number of Rows has limit and file size.
May I know what is the max row and max file size ADO query can be inserted into the excel?
Are you using the custom broker from here?
Are you seeing this error if using a smaller result set?
SELECT TOP 5 * FROM SMONAME
What if you tried returning only a few columns, does it still error?
SELECT ID, NAME FROM SMONAME
I assume the ADO execute successfully outside of this ExcelFromADQuery SMO?
Hi TinTex,
We found that issue was due to Total No of records exceeds 22K and file size reached 10 MB for export to excel during ADO query execution. Modified the SQL Query and SMO results, then its working fine.
Thanks for your reply.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.