Dear Community,
My team and I have been experiencing an interesting mysql error
during the past few weeks of testing. Here is the scenario we are
trying to accomplish. We are essentially working to use MsAccess as a
windows client for a linux based mysql databases. We have installed
myODBC 3.51 and are using that for communication. We seem to be able to
create a linked table just find and select queries work great.
The problem arises when we try to update or insert data. Updates
yield the following error:
"You Tried to assign the Null value to a variable that is not a
Variant data type."
From my searching, I was unable to find how to set fields to variant
data types. Secondly, I am not sure which field is causing the error.
The second issue was with inserts. On insert of just one field (none
are required other than the primary key), ALL of the fields of type text
are set to NULL. This is particularly odd and occurs also in the mysql
command line utilty.
If anyone has any ideas or experience, please send emails to
[EMAIL PROTECTED] We will definitely summarize the solution for the
educaitonal purposes of the list. Again many thanks in advance.
Sincerely,,
Ed Maas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
