BO 5.1.6
Webi 2.7
Win 2000
DB:Sql server 2000
Hi ,
I have a user who's on win 2000 (excel 2000)running zabo.
Everything seems to work fine except exporting to excel functionality.
The user encounters the following error whenever tries to export excel.
1)"Query Input must contain atleast one table or quesry(3067)"
and also sometimes get this error too
2)"Syntax error in Create table statement"
and then gets the "export failed".
Error number 1 is encountered more frequently than 2.
Based on the BO knowledgebase,I tried doing the following things without any success.
1)copied and registered DAO350.dll from a machine that doesn't have this problem.
2)Checked with all other files like MSEXCL35.dll...etc for the correct version in comparision with the machine that had no problem in exporting to excel.
Am I missing something else because I still keep getting the error " Query Input must contain atleast one table or quesry(3067)"
A point to note is that the user is able to download into excel via webi..the problem is only with ZABO.
Any help is appreciated.
TIA,
Kinnu
Webi 2.7
Win 2000
DB:Sql server 2000
Hi ,
I have a user who's on win 2000 (excel 2000)running zabo.
Everything seems to work fine except exporting to excel functionality.
The user encounters the following error whenever tries to export excel.
1)"Query Input must contain atleast one table or quesry(3067)"
and also sometimes get this error too
2)"Syntax error in Create table statement"
and then gets the "export failed".
Error number 1 is encountered more frequently than 2.
Based on the BO knowledgebase,I tried doing the following things without any success.
1)copied and registered DAO350.dll from a machine that doesn't have this problem.
2)Checked with all other files like MSEXCL35.dll...etc for the correct version in comparision with the machine that had no problem in exporting to excel.
Am I missing something else because I still keep getting the error " Query Input must contain atleast one table or quesry(3067)"
A point to note is that the user is able to download into excel via webi..the problem is only with ZABO.
Any help is appreciated.
TIA,
Kinnu