Re: Unstable links to MySQL database from Access
Posted by:
Jim Hanley
Date: January 17, 2005 08:14AM
After some testing, if I manually refresh the links, then close the database (but do not exit Access ) then re-open the mdb file, it continues to work without the need to refresh the MySQL tables...
I also checked the value of all the properties to the tables before and after the refresh, and other then the dateCreated/Updated there is no change... not really sure what that means, but I thought it might be useful in finding out why the driver does this.
Here's a snippit of my debug info... at 8:58 is when I tried to run without refreshing, the 9:02 is after refreshing...
--------------------------------------------------------------------------------
01-17-2005 08:58:41: Initialize Log Class
01-17-2005 08:58:41: tbl.name = [ttmp_customers]
01-17-2005 08:58:41: tbl.Attributes = [536870912]
01-17-2005 08:58:45: tbl.ConflictTable = []
01-17-2005 08:58:45: tbl.Connect = [ODBC;DATABASE=TTMP_Lics;DESCRIPTION=TTMP_Lics;DRIVER=MySQL ODBC 3.51 Driver;DSN=TTMP_lics;SERVER=soy.lalalala.com;]
01-17-2005 08:58:45: tbl.DateCreated = [1/17/2005 8:50:29 AM]
01-17-2005 08:59:00: tbl.LastUpdated = [1/17/2005 8:50:29 AM]
01-17-2005 08:59:00: tbl.RecordCount = [-1]
01-17-2005 08:59:04: tbl.ReplicaFilter = []
01-17-2005 08:59:04: tbl.SourceTableName = [ttmp_customers]
01-17-2005 08:59:04: tbl.Updatable = [False]
01-17-2005 08:59:04: tbl.ValidationRule = []
01-17-2005 08:59:04: tbl.ValidationText = []
--------------------------------------------------------------------------------
01-17-2005 09:02:41: Initialize Log Class
01-17-2005 09:02:41: tbl.name = [ttmp_customers]
01-17-2005 09:02:41: tbl.Attributes = [536870912]
01-17-2005 09:02:45: tbl.ConflictTable = []
01-17-2005 09:02:45: tbl.Connect = [ODBC;DATABASE=TTMP_Lics;DESCRIPTION=TTMP_Lics;DRIVER=MySQL ODBC 3.51 Driver;DSN=TTMP_lics;SERVER=soy.lalalala.com;]
01-17-2005 09:02:45: tbl.DateCreated = [1/17/2005 9:01:46 AM]
01-17-2005 09:02:45: tbl.LastUpdated = [1/17/2005 9:01:47 AM]
01-17-2005 09:02:45: tbl.RecordCount = [-1]
01-17-2005 09:02:49: tbl.ReplicaFilter = []
01-17-2005 09:02:49: tbl.SourceTableName = [ttmp_customers]
01-17-2005 09:02:49: tbl.Updatable = [False]
01-17-2005 09:02:49: tbl.ValidationRule = []
01-17-2005 09:02:49: tbl.ValidationText = []
Is there anything else I could/should check?
Subject
Views
Written By
Posted
3517
January 06, 2005 02:33PM
2132
January 14, 2005 01:55PM
2094
January 15, 2005 01:11PM
2034
January 17, 2005 07:41AM
Re: Unstable links to MySQL database from Access
2288
January 17, 2005 08:14AM
2042
January 19, 2005 07:33AM
2029
January 19, 2005 09:22AM
1980
January 19, 2005 10:07AM
1970
May 12, 2005 04:51PM
2404
May 13, 2005 02:57PM
2159
June 10, 2005 10:00AM
2090
June 10, 2005 02:50PM
2073
July 11, 2005 11:43AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.