You may find SQL Server returns more tables if you connect through the Easysoft ODBC-ODBC Bridge than if you connect directly to the underlying data source. By default, the ODBC-ODBC Bridge server for Windows NT is a service running with administrator privileges. When the ODBC-ODBC Bridge client connects to the server, you pass a login user name and password that the ODBC-ODBC Bridge server uses so it can become the specified user. For SQL Server data sources using trusted connections, the SQL Server ODBC driver appears to notice that you were an administrative user and are now someone else (possibly noticing the real and effective UIDs). Depending on how your database is set up, this may result in additional tables.
If this causes you concern, change the ODBC-ODBC Bridge server service to run as someone other than the administrative user. Do this by starting Services and edit the ODBC-ODBC Bridge server startup options to specify a user name and password. Restart the ODBC-ODBC Bridge server service.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
