FM 5.5 crashes

[RobertoTaglia]

SDK : FM 5.5 - Windows with 512 MB RAM

I have a big fp5 file (10000 kb) and when i use an ODBC program to retrieve the data from FM, FM crashes few minutes later.

Is it normal ?

[Anatoli]

Actually the file is no that big. But probably way too big for ODBC.

[RobertoTaglia]

In this file, there is more than 200 columns. The error message is "Record size is too big".

Could you advise me a better ODBC driver than the one provided by FM 5.5 ?

Thank you

[Anatoli]

I do not know myself. Search web for ODBC FM plugins.

[kraftyman]

What are you using as an ODBC client?

Most applications and drivers will have a limit as to how much information can be read per record ( row).

It may be that the client will only pull "..." as the upper limit for record size. For example, MsAccess has a maximum limit of 2000 characters in a single record, except for memo type oe OLE type fields.

If you have 200 columns, chances are that you have exceeded this limit

In addition to this, for Access, and I bet many other applications, the maximum number of colums in a table is 255. I suppose that there would not be many reasons to have such a huge flat file structure, as many fields could be kicked out into related tables. Maybe you have more than 255 fields? It is very easy to do in Filemaker......

Post some more details, maybe I can think of something...

[RobertoTaglia]

I thank you for answering me.

The files i try to read through OBDC are not mine.

I have big difficulites to read them.

I even have one fp5 file which cannot be open by ODBC.

I think the problem is coming from the name of the fields whtin

the fp5 file. I saw in this file the following names :

< CR > (the carriage return character)

< ___ >

etc

So, when opening a table under ODBC, you cannot specify which fields

you want to retrieve. ODBC retrieves all fields.

The best way for me is to export some fields from the fp5 file to a DBF files and then process it.

Thank you for your help.