Correction to the max length. I meant to write it is well over 1000
not 2000. I believe the max SQL length is 2048. Set you SQL length
to 2048. If you have fields with more characters than 2048 your out
of luck. -200112 error is a known limitation. However I don't think
you will find Progress jumping on fixing this problem since large
character fields are problems with my applications and ODBC drivers.
It's an acceptable limitation to the developers.
not 2000. I believe the max SQL length is 2048. Set you SQL length
to 2048. If you have fields with more characters than 2048 your out
of luck. -200112 error is a known limitation. However I don't think
you will find Progress jumping on fixing this problem since large
character fields are problems with my applications and ODBC drivers.
It's an acceptable limitation to the developers.
--- In vantage@y..., "Peter" <peter.paasch@a...> wrote:
> What did you set your SQL width to in Data Admin? If you set it
> lower than the amount of data you are trying to access you will
> recieve a max length error. Vantage tech support is miss guided in
> the idea that shortening up the SQL lenth fixes all woes. They
> should read the Progress ODBC guide. Run an ODBC Trace by going to
> the ODBC admin and clicking the trace tab. Start a new trace and
> look at the log file after you try to access the table through MS
> Acsess. It will give you a specific function call that failed.
Post
> the error or email me the file ODBC trace file. Progress ODBC does
> have a Limit on the length but it is well over 2000. This might
not
> solve your problem but it will help to eliminate a the Progress
ODBC
> driver as a possible cause.
>
> --- In vantage@y..., "lance02" <lance02@y...> wrote:
> > I am having 2 problems when using my ODBC connection (Merant 3.60
> for
> > Progress 9.1C driver). This problems have just started happening
> > recently. We upgraded from Vantage 5.0 to 5.1 on March 1.
> Problems
> > didn't start occurring until (1) mid-March and (2) two days ago.
> > Problem (1) When I try to run a query in MSAccess 2000 I get a
> > Merant ODBC--call failed error saying my column InvcDtl.LineDesc
> has
> > exceeded its max length (#-210012). This is a memo field with
1000
> > character in Vantage. I try to truncate the field to 50
> characters,
> > but no luck (on a test db). Vantage tech support tells me that
the
> > problem may be that I have part descriptions greater than 2000
> > characters (I do, but we need them, and I can't yet find these
> parts
> > duplicated in the InvcDtl.LineDesc field anyway). Any ideas??
Oh,
> > and it started happening about the time I installed the latest
> > Progress patch P91C19. There may or may not be a correlation.
> > Problem (2) This just started happening, the day after I
installed
> > the Vantage 5.10.120 patch. Now, when I bring data into Access
> 2000
> > via a linked table, it will work when I first bring it in just
> fine.
> > But if I close Access and the re-open it and open the database I
> > created earlier, I get the error ODBC call failed -- Merant
Access
> > denied (Authorisation failed)(7512)(#-20228). If I try to add
> > another linked table, it will let me add it but not view it or
run
> > queries on it. Again, if I were to start a brand new Access
> > database, as long as I don't close Access I am able to do
> everything
> > just fine. Any idea on this one?
> >
> > Thanks for the help.
> >
> > Lance Ekum
> > IT Manager
> > Sentry Equipment Corp