I don't know, but here's how I would go about figuring it out:
1. Start up the ODBC Administrator (make sure it's the 32-bit version!) 2. Create a new System DSN using the MyODBC driver. Search through the Options/Properties dialogs for the logging function and turn it on. 3. In VFP, using SQLConnect() to connect to a database. 4. Using the connection number you got in #3, query the connection like:
MyString = SQLGetProp(cnMyConnectionNumber, "StringConnect")
and that should get you the connection string settings.
On Thu, Nov 29, 2018 at 1:30 PM Graham Brown info@compsys.co.uk wrote:
Hi
Does anyone know how to switch on the logging function in the ODBC driver please.
MyODBC says use "option=4" in the sqlstringconnect but this doesn't appear to do anything.
Graham
This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]