Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 ODBC dsn file

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2007-07-10 : 15:27:42
I use dsn file as below from Access to link to SQL server via ODBC.
From Access, I use this file but list all tables including system tables. How to restrict system objecs?

[ODBC]
DRIVER=SQL Server
UID=Foster
Trusted_Connection=Yes
DATABASE=credent
WSID=sunfoster
APP=Microsoft Data Access Components
SERVER=order
   

- Advertisement -