I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the data I get the following error:
As far as I'm concerned, Windows should use the default ODBC driver (odbcad.exe) for the connection. Any idea what might be causing the error when refreshing the data?
Jan 26, 2010 - Try create a user DSN using the information provided in your connection string and test the ODBC connection from your production server to the SQL Server. The file 'odbcad32.exe' lies in 'C: Windows SysWOW64 ' - You will realise that there is no MySQL ODBC Driver listed.
EDIT: The connection string has DSN, UID, TRUSTED_CONNECTION, APP, WSID and DATABASE fields.
EDIT: I set up the ODBC connection, but now I'm getting the following error:
sazpaz
sazpazsazpaz
1 Answer
Even thought the ODBC connection information is present in the Excel workbook, an ODBC connection must be established between your PC and the data source in order for the workbook to connect.
Not sure what OS you are using, but here is Using the ODBC Data Source Administrator for Windows 7.
If you do not know the information to setup the connection, contact your network administrator.
CharlieRBCharlieRB
Not the answer you're looking for? Browse other questions tagged microsoft-excelmicrosoft-excel-2007odbc or ask your own question.
I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the data I get the following error:
As far as I'm concerned, Windows should use the default ODBC driver (odbcad.exe) for the connection. Any idea what might be causing the error when refreshing the data?
EDIT: The connection string has DSN, UID, TRUSTED_CONNECTION, APP, WSID and DATABASE fields.
EDIT: I set up the ODBC connection, but now I'm getting the following error:
sazpaz
sazpazsazpaz
1 Answer
Even thought the ODBC connection information is present in the Excel workbook, an ODBC connection must be established between your PC and the data source in order for the workbook to connect.
Not sure what OS you are using, but here is Using the ODBC Data Source Administrator for Windows 7.
If you do not know the information to setup the connection, contact your network administrator.
CharlieRBCharlieRB