On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> "C K" <[EMAIL PROTECTED]> wrote on 04/07/2006 01:35:22 PM:
>
>
>  > Dear Friends,
>  > I have linked tables from MySQL through ODBC DSN in Access 2003.
>  > when I go for updating any record in any linked table then it gives me
>  > error as follows:
>  > Reserved Error (-7776); there is no message for this error.
>  > What will be the problem? Please help.
>  > Is this error from MS ACCESS  or for MySQL.
>  > Thanks & Regards,
>  > CPK
>  >
>
>
> Have you read through this:
> http://dev.mysql.com/doc/refman/4.1/en/msaccess.html
>
> or this:
> http://dev.mysql.com/doc/refman/4.1/en/myodbc-with-vb.html
>
> or checked here:
> http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_JetDatabaseEngineVersion30ODBCConnectivity.asp
> (quoted)>>>
> -7776         SQLGetData(SQL_C_TIMESTAMP)         Illegal date/time value
> returned.
> <<<
>
> My quick suggestion: Make sure that all of your timestamp and datetime
> fields are within their expected ranges.
 I am using MySQL server 5.0.17 and ODBC 3.51.12 for ODBC connection.
When I update an y data from MySQL Administrator or SQLYog it gets updated.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to