Date/Time

Date/Time

am 31.03.2005 15:12:04 von Hartmut Rohe

Dear all,

we have a MySQL database with a MS ACCESS 97/2000 frontend.

If we attach a table with a datetime field:

with MyODBC 2.50 this field is in ACCESS a Date/Time field and works
proper
with MyODBC 3.51 this field is in ACCESS a String255 field and don't
work

If we copy the Access Database with the table attached with MyODBC 2.50
to the computer with MyODBC 3.51 it works also proper.

Only at the time were the tables attached there must be MyODBC 2.50 used.


Sincerelly

Hartmut Rohe





--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Date/Time

am 01.04.2005 01:10:56 von Daniel Kasak

Hartmut Rohe wrote:

>Dear all,
>
>we have a MySQL database with a MS ACCESS 97/2000 frontend.
>
>If we attach a table with a datetime field:
>
> with MyODBC 2.50 this field is in ACCESS a Date/Time field and works
>proper
> with MyODBC 3.51 this field is in ACCESS a String255 field and don't
>work
>
>
:)

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Date/Time

am 01.04.2005 01:16:20 von Daniel Kasak

Hartmut Rohe wrote:

>Dear all,
>
>we have a MySQL database with a MS ACCESS 97/2000 frontend.
>
>If we attach a table with a datetime field:
>
> with MyODBC 2.50 this field is in ACCESS a Date/Time field and works
>proper
> with MyODBC 3.51 this field is in ACCESS a String255 field and don't
>work
>
>If we copy the Access Database with the table attached with MyODBC 2.50
>to the computer with MyODBC 3.51 it works also proper.
>
>Only at the time were the tables attached there must be MyODBC 2.50 used.
>
>
Look back through the forums for details, or download MyODBC-3.51.09 or
3.51.06.
If you want a bleeding-edge version that seems to work, download
3.51.11-2 from http://www.peterharvey.org/Downloads/MySQL/MyODBC/

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org