This is a discussion on ODBC via Proxy server? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> My organization is trying to limit ODBC connections attaching to the main DB from satellite sites to 1 per ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| My organization is trying to limit ODBC connections attaching to the main DB from satellite sites to 1 per site. They are proposing that users (about 30) needing to query the DB use terminal services on a server with the appropriate ODBC driver installed and do their queries. Is there a way to: 1. "share" an ODBC driver on the central server that workstations can point to and appear as 1 ip address? 2. Use a proxy configuration with the odbc driver one one side and clients connecting on the other? letting the proxy server handle connection. 3. Do a really cool suggestion that you have. (that I haven't thought of) 4. or do I just capitulate and make everyone learn how to use terminal services and suffer the slings and arrows of complaints and slow performance? |