Re: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

Duane, appreciated. Somehow installing MySql ODBC connector 5.1 and using it instead of 8.1 resolves the issue.

best regards

Ahmed

On Wed, Aug 2, 2023 at 4:14 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Next, I would try select a single, simple field in a pass-through rather than all fields. 

Duane

Sent from my mobile

On Aug 2, 2023, at 12:23 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, a simple table with just 2 field and few data, is connected via pass through query without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 11:07 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you try with a very simple table?

Duane

On Aug 1, 2023, at 1:01 PM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane

I think now i understand what you meant, tried the pass through query with ODBC connection string:

<image.png>

tried both File DSN and Machine DSN with same following error:

<image.png>

regards

Ahmed

On Tue, Aug 1, 2023 at 10:42 PM Ahmed Hashim via groups.io <ahmedhashim1=gmail.com@groups.io> wrote:

Duane,

How do I create a pass through query from Ms.Access without connecting/Linking to MySql? I am trying to link with only 1 table. With no relationship with any other tables etc.

regards

Ahmed

On Tue, Aug 1, 2023 at 10:40 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Did you attempt the pass-through query in Access? There might be an incompatibility issue with one or more fields. Can you try link to a very simple table?

Duane

On Aug 1, 2023, at 10:24 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Duane,

Surprisingly Excel is able to get connected with MySql and even import data via ODBC without any errors.

regards

Ahmed

On Tue, Aug 1, 2023 at 6:27 PM Duane Hookom <duanehookom@hotmail.com> wrote:

I would try create a pass-through query or connect via Excel (as tests). 

Duane

Sent from my mobile

On Aug 1, 2023, at 7:47 AM, Ahmed Hashim <ahmedhashim1@gmail.com> wrote:



Yes, creating DSN outside Ms.Access is successfully connected with MySql database:

<image.png>

On Tue, Aug 1, 2023 at 4:59 PM Duane Hookom <duanehookom@hotmail.com> wrote:

Creating an ODBC/DSN can be accomplished completely outside of Access. Is this successful? Will the DSN connect?

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Ahmed Hashim <ahmedhashim1@gmail.com>
Sent: Tuesday, August 1, 2023 12:52 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Error while Linking Table from MySql to Ms.Access

 

Hi to All,

I am trying to connect and link Mysql table with Ms.Access, but everytime using wizard it shows following error:

<image.png>

I've tried via ODBC (file, system and machine DSN), and received the same error every time.

Environment Information:

Windows 10 64bit

Ms. Office version 2019 64bit

MySql version: mysql  Ver 15.1 Distrib 10.4.20-MariaDB, for Win64 (AMD64), source revision c7ee039d36f69f24fb3b1c422fcff8dbf974e3eb

MySql ODBC Driver/Connector: MySQL ODBC 8.1

Any help/suggestion will be highly appreciated.

best regards

Ahmed Hashim

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116432) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_