Unable to Bind to field or datamember Run-time error 545

[PCSAARON]

We just upgraded our MySQL Linux development server to 4.1.9-standard.

Our visual basic applications are now complaining that certain fields are not being able to bind.

"Unable to bind field or DataMember: "bill_id".

We also tried MyODBC driver 3.51.06 and the latest MyODBC. It still does the same thing.

We had this happen when we had ONLY upgraded the MyODBC driver to the latest version and NOT the server version which I think was running 4.0.13 at the time.

Does anyone have ANY clue on what might be wrong? The field DOES exist in the table.

Thanks in advance.

 

[PCSAARON]

I did find the solution. After the upgrade of the server, someone had added a date field into the table. This is what caused the problem. The "Allow Null" was not checked. Once that was checked on the new date field, everything worked fine.

Thanks for reading anyway, and hope this helps someone in the future...