OLE DB debug logging
You set up OLE DB debug logging by using the connection URL.
Use the following
components in the connection URL:
- Provider
- Enter NZOLEDB.
- User ID
- Enter your user ID.
- Password
- Enter your password.
- Data source
- Enter the system host name.
- Initial catalog
- Enter the database name.
- Port
- Enter the port number. The default is 5480.
- Logging Level
- Enter 1 to enable logging or 0 for no logging.
- Log Path
- Enter the path for the log file. For example, enter c:\logs.
Separate components with a semicolon. A sample connection string
follows:
Provider=NZOLEDB;User ID=<UserID>;Password=<Password>;Data
Source=<npshostname>;Initial Catalog=<database_name>;Port=5480;Logging
Level=1;Log Path=c:\logs