November 12, 2015 at 9:27 am
I have a MS 2008R2 SQL server running on a Windows 2008R2 server both virtual servers under Hyper V There are 5 main databases which are all linked to a ERP program.
My users all run Terminal Server (TS) Windows 2008R2 again virtual, we have ODBC connections setup on the TS (under system DSN) to allow users to import data from the SQL database in to MS Excel 2010.
Due to demand on the TS server we are adding a second TS which we are currently testing, now if a user opens a new excel spreadsheet on the new TS and makes an ODBC connection and imports data, he can save it and reopen it on the new TS without a problem.
Now if the user opens an existing Excel spreadsheet on the new TS that was created on the old TS with ODBC links the spreadsheet will not load (the spreadsheet opens but will not load anything).
If the user goes on to the old TS and try to open the new spreadsheet that was created on the new TS with ODBC links this spreadsheet will not open either.
We have found that if we delete the WSID from the ODBC connection string (is that the correct term?) you can open any ODBC linked spreadsheet on any TS but the problems comes when you save and close the spreadsheet because the WSID is re-added to the ODBC connection string.
I believe the WSID is an optional component of the connection string, but can not find anywhere to remove it, is that the best only way to resolve our issue? Both sets of ODBC setting are identical on both the old and new TS
Sorry if I sound vague or used the wrong terminology but this is all new to me.
Regards
Tim
November 13, 2015 at 8:56 am
Hi Tim, from what you've described, all I can think that's happening is the application is checking the value of WSID in the connection string and comparing it to the current machine name as a rudimentary security feature.
It's just an infomational parameter in the connection string normally and so shouldn't be preventing connections.
November 13, 2015 at 9:06 am
That is basically what we assumed, there quite a few comments on the net that state the WSID is optional but cant find anything to say how you can leave it out of any new spreadsheet you produce or how you can delete and ensure that it does not get added back in again in an existing spreadsheet, currently a little stumped :unsure:
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply