Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    Thank you for your help Chris!
  2. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    Thank you, Chris. I've ran the code provided and here is the output:
  3. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    Quick Update: I've further verified that I'm able to connect via VBA through Excel using both DSN and full connection string. As an example:
  4. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    You bet. Verifying DSN "TEST" is 32-bit: Various default configuration settings within the MySQL ODBC connection:
  5. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    You're correct, Chris. I edited the original post to state "{host}" to prevent any future misinterpretation by other users. Yes, I'm able to connect via Excel using a DSN. However, using that same DNS in VFP I'm unable to connect. For example: Excel Power Query connection string...
  6. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    Hi Chris, MySQL Server is installed on Ubuntu, but the connection is being made from a Windows device using an ODBC connection. I hope that helps clarify.
  7. AzNative

    Running SQLEXEC on MySQL Database -- Continued...

    Hello All, In reviewing a prior thread (https://www.tek-tips.com/viewthread.cfm?qid=1829136), it seems as though I have a very similar dilemma. The primary difference is that I'd prefer not to utilize outdated ODBC connectors due to vulnerability concerns. I'll quickly recap below: MySQL...

Part and Inventory Search

Back
Top