MyODBC

[Graham Brown]

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
---

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/014201d48811$8ab1d9c0$a0158d40$@compsys.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Ted Roche]

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.

Post by Graham Brown
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]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CACW6n4s3mc5F7FpCc2hMcB5VfXGdL_u1DATzx+***@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

[Graham Brown]

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-***@leafe.com] On Behalf Of Ted Roche
Sent: 29 November 2018 18:55
To: ***@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.

Post by Graham Brown
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]

_______________________________________________
Post Messages to: ***@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/000e01d48831$69055840$3b1008c0$@compsys.co.uk
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.