|
|
Sponsor |
MyOdbc <-> Access2000 and Time Column: msg#00020db.mysql.odbc
Hi! I have the following problem with Access2000 as frontend connected to a MySql-Server via ODBC. The Table contains 6 Time Columns. When linking the MySQL-Table in the table tab of Access2000 and then opening the table, all Time Columns show either nothing or strange date values. (eg. 18:30:00 is converted to 31.05.21) Data stored from Access2000 into the table is stored right in MySQL, but shown wrong in the linked table in Access2000 and therfore stored wrong in a mirror table in Access2000. Using the same MySQL-Table with an Access97 frontend and the SAME ODBC-Datasource shows the proper values and data exchange between Access97 and MySQL works fine! OS: Win98SE (same on win2k) ODBC: MySQL ODBC 3.51 Driver - Version 3.51.12.00 Application: Access2000 (MDAC 2.8 SP1, Jet40 SP8 9x&NT) MySQL-Server: MySQL 4.0.12-standard-log on linux Searching the web and this mailinglist, I found only workarrounds, that do not apply in my case. Since changing the Column-Type is not an option. Anyone can help? Thank You, Kai -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | RE: Huge memory consumed with myOdbc and VB.NET, Patrik Lindvall |
|---|---|
| Next by Date: | Re: MyOdbc <-> Access2000 and Time Column, Daniel Kasak |
| Previous by Thread: | How to get myodbc3d.dll ???, Jan-Simon Lucas |
| Next by Thread: | Re: MyOdbc <-> Access2000 and Time Column, Daniel Kasak |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home | sitemap
| advertise | OSDir is
an inevitable website.
|