Failed to connect to the server. Reason: ERROR  [Ardent][UniData ODBC Driver]Invalid user authorization specification.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR  [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
ERROR  [Ardent][UniData ODBC Driver]Missing '=' in connection string.
This ocnnection works fine in Excel using regular pivot tables, but i can't get it to work with PowerPivot. Can anyone help?