ODBC Import error-"defined record is too long"

[Wanda Tucker]

The Preview screenshot

Aaron,
Here's a screenshot of the data generated by the Preview button.
Wanda

[AaronBBrown]

How many records are in that table?

Also, rather than creating a word file, and cutting and pasting the images into Word, then posting a Word DOC file attachment, it makes more sense to cut and paste the images into Microsoft Paint, or other image software (I like IrfanView) and attaching the images as images. This way, a thumbnail is created and it doesn't require opening a separate program.

[Wanda Tucker]

Thanks for the tip on saving to Paint...Never used Paint, and don't even know if I have it, but will check it out.

The table I'm attempting to import has 902 records. Aaron, I managed to get it to import the first field, which is probably numeric. I added one character field to the field list to be imported, and got the error message again. I also tried to import just one character field, and got the error message.

Thanks,
Wanda

[AaronBBrown]

What is the "Character" field defined as in MySQL?

[Wanda Tucker]

What do you mean? I know virtually nothing about MySQL, but spoke to the IT person who does, and he indicated that the file will have numeric and character fields, as well as date fields (and probably others).
Thanks,
Wanda

[AaronBBrown]

I need to know what the definition of the fields are in the MySQL database. MySQL has more than just "numeric", "character", etc. Is it a Varchar? If so, what is the size?

Ideally, it would be nice if you could send me a mysqldump of the database, so I can test with the data directly.

What do you mean? I know virtually nothing about MySQL, but spoke to the IT person who does, and he indicated that the file will have numeric and character fields, as well as date fields (and probably others).
Thanks,
Wanda

[Wanda Tucker]

Hi Aaron,
Our IT Person who hopefully can answer this question is out to lunch right now. I'll try to catch him post haste. Providing all the data is not an option, as there is confidential information that by law, I can not give out.

Please stay tuned. Thank you - Wanda

[AaronBBrown]

Even providing just the structure would be helpful.

Hi Aaron,
Our IT Person who hopefully can answer this question is out to lunch right now. I'll try to catch him post haste. Providing all the data is not an option, as there is confidential information that by law, I can not give out.

Please stay tuned. Thank you - Wanda

[Wanda Tucker]

MySQL definition

Here are the field definitions, Aaron. Thank you for your patience :)

ID: Integer - size 11
FIRST_NAME: Varchar - size 255
LAST_NAME: ""
IDENTIFIER: ""
PREFIX1: Char - size 3
SUFFIX1: Varchar - size 4
PREFIX2: Char - size 3
SUFFIX2: Varchar - size 4
LOCATION: Varchar - size 255
MOD_DATE: Varchar - size 30
VACANT: Char - size 1
CENTREX: Char - size 11
VOICE_MAIL: Varchar - size 255
JACK: Varchar - size 10
DIVISION: Varchar - size 255
UNIT: Char - size 11
HR_EMP_NO: Varchar - size 10
NO_PRINT: Char - size 1
SUPERVISOR: Varchar - size 10
PREVIOUS_EMPLOYER: ""

I hope this is what you need, Aaron.

Thank you,
Wanda

[AaronBBrown]

Sort of. What would be most helpful is if he ran a mysqldump of the table with the "-d" or "--no-data" flag, and then sent me the resulting SQL. That way, I can recreate the table structure on my machine here.

the command would look something like
mysqldump -u user -p password -d mydatabase > sendtoaaron.sql

[Wanda Tucker]

Thank you, Aaron, for working so hard and diligently on this! I will beg and plead and try to talk our IT tech into doing what you're asking - although yesterday I was put on a new assignment to evaluate other web-based design software, and scrap the WAS...(mostly due to the inability to create reports on/from the WAS with external data - a major brick wall).

Sincerely,
Wanda

[Wanda Tucker]

Hi Aaron,

I jost spoke with the IT tech, who is not willing to spend any more time on these problems, unfortunately. I hope you find a fix, anyway, as I'm not sure we'll find another program for me to use, given another huge learning curve.
Sincerely again,
Wanda

[AaronBBrown]

I was eventually able to reproduce the problem and hopefully I can have it fixed.

[Wanda Tucker]

Great, Aaron. Thank you. - Wanda

[AaronBBrown]

I have fixed this problem.