logging to a database
i want to take advantage of VT's logging features, but i want to log to a database. the VT help has an example of initializing a logging object to write to file similar to...
</font><blockquote><font size="1" face="Verdana, Arial, Helvetica">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">Dim LIS As LOGINITSTRUCT
LIS.LogOutputType = LogTypeFile
LIS.MinDetailLevel = 3
LIS.ProductVersion = "9.0"
LIS.MachineName = "QAXPGC"
LIS.LogLocation = "test_log.log"
LIS.Language = "US English"</pre><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">it also mentions that you can log to a database by changing the LOGOUTPUTTYPE to LogTypeDatabase and changing the LOGLOCATION to a connection string, but gives no examples of what the connection string should be. What would the connection string look like for connecting to an Access database using ODBC?
Re: logging to a database
VT we used to log our results to a SQL database using ADODB connection