> Can you explain further how this works? I know MSS charge a > bit for this solution and claim it's easily usable over > dialup. Why do you have MSSQL at both ends - is it doing > replication? If so you would expect better speed as they > should be connecting to the LAN instance. > > If I have this wrong and you're doing a client-server > database connection over a WAN, then Terminal Services is the > answer to your problem. > > cheers, > Peter.
Full MS SQL at each end. Some sort of replication happening. Remote clients ask remote SQL server for patient file. Remote SQL server has full list patient demographics.(sync'ed whilst on same LAN) If remote server has not cached a copy it pulls it over WAN. If remote server has a cached copy it opens that but whilst doing so checks each field is current compared To primary server. That seems to be quicker than pulling the whole file across. Remote server talks directly to the primary server, And The remote clients have a mapped drive to primary and remote servers. Also remote clients have a ODBC connection to both servers. Terminal Services still not supported by IBA/MSS. They do use it for some remote support though. Yes TS server would have been heaps cheaper, Wyse terminal everywhere would have made AdamK happy. Andrew. _______________________________________________ Gpcg_talk mailing list [email protected] http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk
