Re: Reserevd Error -7776 -- Urgent
"C K" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc,gmane.comp.db.mysql.general,gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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 ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]