Upgrading Financials

cythea

Ive moved my navision fin server from
one machine to another and at the sametime
upgraded it and the clients ODBC driver.

On a new client I open excel and it says it
cannot access the link, then the ODBC config options comes up with the old data not the newly confgiured ODBC link.

What am i doing wrong ?

Lars_Westman

Have You changed the Server Name in that clients ODBC Data Source? Since You've moved Navision to an other server You must change the Data Source in the Control Panel on the client

//Lars

cythea

old data source ODBC new data source on the
new client is also called ODBC, the client and
the server are new its the excel sheet thats
the old part and this is the part that causeing
the problem ... new links work fine

John_Tegelaar

Is the database link saved with the Excel sheet? Then you need to update this connection as well. Go in Excel to menu Data, Get External Data, Edit query.

John