Re: Intersting MySQL / Access Issue

2005-06-22 Thread Daniel Kasak
Raj Goel wrote: Dan, Here's what I've narrowed it down to: We're updating FROM Access TO MySql. If the column in Access is blank/empty, then the error pops up. If the field has data, then the error does not pop up. So, somewhere, either Access, or MyODBC or

RE: Intersting MySQL / Access Issue

2005-06-22 Thread Gordon Bruce
To: mysql@lists.mysql.com Subject: Intersting MySQL / Access Issue 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

Intersting MySQL / Access Issue

2005-06-21 Thread Edward Maas
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

Re: Intersting MySQL / Access Issue

2005-06-21 Thread Daniel Kasak
Edward Maas wrote: 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. No kidding. Looking into my crystal ball, I can

MySQL access issue

2003-09-15 Thread Phil Perrin
Hello everyone, Kind of an oddball question but I'll try to make it as clear as possible. We have a Solaris server, that we have root access to. It houses mysql db's and information. I was not the admin for the db's and frankly I'm not an MySQL buff to be honest. Our DB Admin is gone now, I

Re: MySQL access issue

2003-09-15 Thread Rich Allen
this link from the mysql docs should help http://www.mysql.com/doc/en/Resetting_permissions.html - hcir Kind of an oddball question but I'll try to make it as clear as possible. We have a Solaris server, that we have root access to. It houses mysql db's and information. I was not the admin for