Trace ODBC Connection log

2019独角兽企业重金招聘Python工程师标准>>>

1. In the odbc.ini, go to the [ODBC] entry.

It should look something like this by default:

 

[ODBC]

Trace=0

TraceFile=/<InformaticaInstallationDir>/ODBC7.0/odbctrace.out

TraceDll=/<InformaticaInstallationDir>/ODBC7.0/lib/DWtrc26.so

InstallDir=/<InformaticaInstallationDir>/ODBC7.0

 

2. Enter the following:

? Set Trace to 1

? Set TraceFile to the desired output file name including full path.

Where TRACEFILE specifies the name and full path of the trace file ? Leave all other settings as is.

 

Example

[ODBC]

Trace=1

TraceFile=/<InformaticaInstallationDir>/ODBC7.0/odbctrace.out

TraceDLL=/<InformaticaInstallationDir>/ODBC7.0/lib/DWtrc26.so

InstallDir=/<InformaticaInstallationDir>/ODBC7.0

 

3. Run the PowerCenter session with the error.

 

4. Set Trace=0 after running the session.

 

Please send the trace file (/<InformaticaInstallationDir>/ODBC7.0/odbctrace.out).

转载于:https://my.oschina.net/swuly302/blog/487515