Search results

In the meantime I solved this with CONVERT(CAST(CONVERT( column ) USING LATIN1) AS BINARY) USING UTF8) in the select. Best, Frank

Good morning, thank you, do you think that Ansi and utf8mb4 don't go together? What's your point? Thx, Frank

Hi there, I'm pulling data from my Wordpress database (charset utf8mb4_unicode_ci) via MySQL Connector 8.0 into MS Access. This has worked well until I had to restore a backup on my website using Duplicator Backup Plugin. Now, all German Umlaute (ä, ü etc.) and other letters like ß are displayed...

I think I will try to look into a remote desktop setup. That's maybe the best workaround. Thank you for your input. Frank

Hi there, I'm using Access together with a MySQL database as the backend. Whenever I hosted the database with a shared hosting provider (remote access via ODBC), the connection performance was just not sufficient even though my queries are not that complex. In some tables we have a few thousand...

You're right, there should be only one slash, I just deleted a few things before putting the code here, that's when it happened ...

@Gasman Thank you - it's true that I kind of ignored that one post where they were addressing my issue. With the help of that post I was able to put together a routine which now connects via ftp, looks through a certain folder for subfolders, and downloads all files from the subfolders to a...

I already did a lot of googling :-) However there was nothing really useful.

Hi there, I'm working on pulling order data from our web shop into MS Access which works pretty well. Now I'd like to copy files uploaded by customers within the order process onto our drive via FTP. Unfortunately, I only know part of the path - my URL/order_ID/unique_ID/files .... As I cannot...

And this is the code to authenticate with Woocommerce from MS Access & VBA and retrieve information via REST API: Option Compare Database Option Explicit Const WOOkey = "ck_XYZ" Const WOOsecret = "cs_XYZ" Const WOOtoken = "ck_XYZ:cs_XYZ" Const WOOurl = "https://yoururl.com/wp-json/wc/v3"...

Fantastic effort, Dave!! You didn't give up and finally worked out a code that works perfectly! Finally it's documented how to authenticate with Woocommerce from MS Access & VBA and retrieve information via REST API. Thank you!!

Super, this is what I needed - I didn't know that if ... then is possible in the Select part. Thanks a lot! Frank

Hi there, I'm trying to fetch data from a Wordpress database into MS Access. In picture below you'll see how Woocommerce (the shop plugin of Wordpress) stores user data. I'm now trying to build a query to fetch the different user data at once (e.g. _billing_first_name, _billing_last_name...

Thank you so much! Ansi Driver solved my issue! Frank

Hi there, in the past, I've used the MySQL Connector 5.1 driver to connect to my MySQL database. For several reasons, I now had to update to MySQL Connector 8.0. Unfortunately MySQL Connector 8.0 doesn't support my German Umlaute by default (ä, ü etc.). What I read about this is "The default...

Hi Gemma, I would like to try your code, but I don't have a Bearer token. Woocommerce / Wordpress gives you a Consumer Key and a Consumer Secret issued specifically for my user. With these codes, I should be able to read and write data. In PHP, it would be the code below...

No, no parsing required :-) You simply fetch your data like you do from any other MySQL db. Frank

I didn't even manage to pass the REST API basic authentification with Postman with both keys I had generated in Woocommerce. So I'm giving up... I now turned to pulling data simply via ODBC which is working well via MySQL Connector. Thanks for helping. Frank

@gemma-the-husky Could you be more specific about .setRequestHeader "Authorization", "Bearer " & apikey? I get a "Access denied message". I guess I need to insert my username and the Consumer Secret key, but how? Thank you, Frank