>I think I might have found the problem that is causing GENDBC to fail.
>
>I have pasted portions of the PRG file generated by GENDBC into another PRG file and compiled that. I repeated this until I found the code that was causing the compile to fail.
>
>It appears to me that one of the CREATE TABLE statements has too many characters in it. This database includes about 176 tables. 2 of them are quite large, but do fit within the number of allowed field.
>
>I copied the each of the questionable CREATE TABLE statements into Microsoft Word as a way of getting a character count.
>
>One CREATE TABLE statement had 6963 characters (not counting spaces), or 13834 characters if you counted spaces. The PRG file with this CREATE TABLE statement in it compiles OK.
>
>The other CREATE TABLE statement has 7654 chars (not counting spaces), or 15,284 chars counting spaces. When this statement is in the PRG file, the compile fails.
>
>Does this sound like what might be causing my problems?
>
>Jim
Yes, I think you nailed the problem. Basically you're saying, that you can not re-generate your database using GenDBC. What are you using for DBC modifications? SDT?
Is is a critical table? Can you generate the database without it and test OleDB?
If it's not broken, fix it until it is.
My Blog