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
3537
January 06, 2005 02:33PM
2141
January 14, 2005 01:55PM
2103
January 15, 2005 01:11PM
2042
January 17, 2005 07:41AM
Re: Unstable links to MySQL database from Access
2295
January 17, 2005 08:14AM
2055
January 19, 2005 07:33AM
2037
January 19, 2005 09:22AM
1989
January 19, 2005 10:07AM
1981
May 12, 2005 04:51PM
2422
May 13, 2005 02:57PM
2167
June 10, 2005 10:00AM
2094
June 10, 2005 02:50PM
2085
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.