I am trying to setup my ODBC connection to our server and i get the test connection to work successfully. However, when i proceed with the next button i get this error message

Failed to connect to the server. Reason: ERROR [28000] [Ardent][UniData ODBC Driver]Invalid user authorization specification.

ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

ERROR [08004] [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?

Hi,

Try the following steps:

• In the Workbook:

1. Go to Data tab -> From Other Sources -> From Data Connection Wizard -> ODBC DSN
2. Choose the ODBC data source and enter login details
3. Select the Table (and change any other details you wish)
4. Finish and return the data to the Workbook.

• In PowerPivot:

Open the PowerPivot window -> Design tab -> Existing connections

From Workbook Connections section and NOT the Local Connections section, select the connection just created. Make sure the name does not have any illegal characters such as brackets around "Default" - but don't worry too much, it will soon tell you and it is simple just to edit the name at that point.

Validate if wished or just go straight to "Finish". This should import the data into PowerPivot.

does this mean that I need to refresh the local connection each time i want to refresh the data?  or just use the powerpivot refresh?