This content has been marked as final. Show 9 replies
It appears that I can view in Excel through the RPD when I am accessing the RPD in offline mode. If I try to access through online mode it just says "Connection Failed".
I also tried viewing the data through Answers but received the following error:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: IM006 code: 0 message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed. [nQSError: 16001] ODBC error state: S1000 code: -1022 message: [Microsoft][ODBC Excel Driver] Your network access was interrupted. To continue, close the database, and then open it again.. (HY000)
SQL Issued: SELECT 0 s_0, "XLS-GBB"."FACT_F!_FACT"."Measure" s_1 FROM "XLS-GBB"
Does the file have to reside someplace special?
I'm not seeing the options you have listed. If I click on the database the data source definition is set to "ODBC Advanced". If I do a [Find] for "distinct" on the Features tab I see the following options:
I have deselected each of these options.
Looking at the connection pool properties I see the following on the General tab:
Call interface -> ODBC 3.5
Data source name
Enable connection pooling
Use multithreaded connections
I have deselected "Enable connection pooling".
I've got to be missing something simple because I cant seem to find anyone else that has had this problem. Thank you for you help!