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 ---
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]
Thanks
The ConnectString just shows the DSN name.
I did create a file dsn, located the file in the common folder and it has an "OPTION=524298". Still not showing me the MyODBC.SQL file though.
Nothing else in the DSN so not sure what else it needs.
Graham
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Ted Roche Sent: 29 November 2018 18:55 To: profox@leafe.com Subject: Re: MyODBC
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]
-
Graham Brown -
Ted Roche