Cache ODBC에 쿼리문을 날렸는데, 무슨 일이 일어났는지 잘 모르겠다 싶을 땐, Client 쪽에서 Cache ODBC log를 남길 수가 있다.
Windows Control Panel -> Administrative Tools -> Data Sources (ODBC)
-> System DSN -> CACHE Data Source -> Configure -> Check ODBC Log -> OK
위와 같이 하면, 윈도우즈 환경에서는 주로 Windows 디렉터리 아래에 CacheODBC.log 파일에 남는다. 하지만, 아래와 같이 하면, 로그의 위치를 변경할 수가 있다.
1. Create the log files outside of the standard path (windows directory is default)
Windows Control Panel -> System -> Advanced Tab
-> Environment Variables -> System Variables
-> New Variable name CACHEODBCTRACEFILE
Variable value C:\ODBC_Logs\CacheODBC.log
optionally you can define also the following environment variable to include PID info (cf Cache online documentation - ODBC log setup)
-> New Variable name CACHEODBCPID
Variable value 1
Create folder C:\ODBC_Logs
하지만, Windows2003에서는 아래와 같은 추가 스텝이 필요하다고 하니 참고하시길.
2. Authorizations
Windows Control Panel -> Administrative Tools -> Computer Management
-> + Local Users and Groups -> Users -> ASPNET -> Member of -> Add
-> Enter the object names to select -> Administrators
(It may be already defined on your system)
Windows Control Panel -> Administrative Tools -> Computer Management
-> + Services and Applications -> right click Internet Information Services
-> All Tasks -> Restart IIS -> Restart Internet Services on XXXX -> OK
|