Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-12-2018, 10:09 AM   #1
dgulliver
Newly Registered User
 
Join Date: Nov 2014
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
dgulliver is on a distinguished road
1 table gives ODBC Call Failed

Hi,

Seen plenty of threads regarding Linked Tables ODBC Call Failed however this happens to only one table on one freshly installed PC. All Tables are using the same ODBC System DSN and the same ODBC MySQL Connector which is "MySQL ODBC 5.2a Driver".

When I double click the table error appears but table appears to open but data filled with name?

I uploaded the source application to the problem PC and on debug found it was this particular table causing the problem.

This particular PC has all windows and office updates.
I have deleted, Compacted & repaired, Re linked the table
All Byte/Boolean fields are set to ether 0 or -1
Dates look OK

I'm using odbcad32.exe located syswow64 on all PC's including the problem one.

any other ideas?

Thanks
Darren

dgulliver is offline   Reply With Quote
Old 07-13-2018, 07:07 AM   #2
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 643
Thanks: 9
Thanked 52 Times in 50 Posts
kevlray will become famous soon enough
Re: 1 table gives ODBC Call Failed

Ok, I am going to ask the stupid question. Are you certain that the table exists in the MySQL database. I do not know much about MySQL and table naming restrictions that might not be compatible with Access.
kevlray is offline   Reply With Quote
Old 07-13-2018, 07:59 AM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: 1 table gives ODBC Call Failed

If only one pc had an issue with the table, then it must exist

Just wondering about the Boolean fields. You say these are set to true/false but didn't say where this was checked.
I don't use MySQL but if it's like SQL Server, Boolean fields can also be null. Access doesn't know how to handle the null Booleans and displays them as zero but treats them as 'indeterminate'. Trying to run an update query on such fields will result in a write conflict error.
To avoid issues, always set default values for these Boolean fields so these are NEVER null

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 07-13-2018, 12:59 PM   #4
kevlray
Newly Registered User
 
Join Date: Apr 2010
Location: Central California
Posts: 643
Thanks: 9
Thanked 52 Times in 50 Posts
kevlray will become famous soon enough
Re: 1 table gives ODBC Call Failed

If only one pc had an issue with the table, then it must exist


Opps!! Missed that part of the paragraph.
kevlray is offline   Reply With Quote
Old 07-13-2018, 02:15 PM   #5
AccessBlaster
.
 
Join Date: May 2010
Posts: 1,103
Thanks: 24
Thanked 268 Times in 255 Posts
AccessBlaster has a spectacular aura about AccessBlaster has a spectacular aura about
Re: 1 table gives ODBC Call Failed

Have you gone back and double checked the driver on the problem PC = MySQL ODBC 5.2a

When you hover over the link on the bad table, does it have the intellisense.
AccessBlaster is offline   Reply With Quote
Old 07-16-2018, 11:49 PM   #6
dgulliver
Newly Registered User
 
Join Date: Nov 2014
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
dgulliver is on a distinguished road
Re: 1 table gives ODBC Call Failed

Thank you all for responses.

Table does exist in MySQL as I'm able to re-link.
I checked whether the fields were set in MySQL Workbench and phpMyAdmin.
the default on Y/N fields is 0, also this only happens on 1 PC, This app is installed on around 30 PC's
There only 6 records and 57 columns in this table, It is used for configuration of the app.
The driver is 100% MySQL ODBC 5.2a


Darren
dgulliver is offline   Reply With Quote
Old 07-17-2018, 09:17 AM   #7
dgulliver
Newly Registered User
 
Join Date: Nov 2014
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
dgulliver is on a distinguished road
Re: 1 table gives ODBC Call Failed

All,

Once again thank you for your responses.

Looks like I found the issue - our I.t guys in Poland setup a new PC but did not change the locale settings to be the same as the other PC in poland.

We discovered a date issue when we ran an ODBC Trace, We set the ODBC setting Character Set to Latin1 which resolved the issue.

Thanks
Darren


dgulliver is offline   Reply With Quote
Reply

Tags
call failed , mysql connection odbc , odbc

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC Call Failed jerem SQL Server 1 07-12-2016 06:34 PM
ODBC Call Failed when different ODBC tables are linked with different accounts sharpnova General 5 04-20-2012 08:53 AM
ODBC--call failed lhanes72 SQL Server 4 01-26-2010 08:43 AM
ODBC Call Failed??? ewong1 General 1 03-10-2009 01:47 PM
ODBC--Call failed vbjohn General 0 09-05-2002 11:16 AM




All times are GMT -8. The time now is 11:39 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World