I'm trying to figure out a problem with a customer's OpenLink ODBC link.
Information:
win95 clients, connecting to Progress with Access via OpenLink MT.
8.2B running on SCO OS5
The ODBC is giving them access to only the default field length from the
Progress database schema. Unfortunately, we put more data than the field
format (the field is defined as 'x(25)', but frequently stores as much as
'x(50)'). I need to find how to tell ODBC to show a larger field size.
I have a .dat file, in /usr/openlink/bin. As far as I know, this was put
in place to help handle arrays better. I found what appears to be the
definition of the field that I wanted to change. It was in the format:
'F|LastName|1|25|0|0|yes|The person's last name.'
I modified this line to look like this:
'F|LastName|1|60|0|0|yes|The person's last name.'
This did not seem to make any difference in how the data is presented
within Access. I've stopped and re-started the openlink broker on the
server with the commands 'oplshut' and 'oplrqb', and had the customer
re-link the tables in Access. There is still no difference.
What am I missing here? I was handed this situation, and haven't done much
of anything with ODBC. I may be missing something here, but don't know
what to look for.
Thanks--
--James--
James Burts james@klas.com
Keystone Systems, Inc. (919)782-1143
Manager of Software Development
Information:
win95 clients, connecting to Progress with Access via OpenLink MT.
8.2B running on SCO OS5
The ODBC is giving them access to only the default field length from the
Progress database schema. Unfortunately, we put more data than the field
format (the field is defined as 'x(25)', but frequently stores as much as
'x(50)'). I need to find how to tell ODBC to show a larger field size.
I have a .dat file, in /usr/openlink/bin. As far as I know, this was put
in place to help handle arrays better. I found what appears to be the
definition of the field that I wanted to change. It was in the format:
'F|LastName|1|25|0|0|yes|The person's last name.'
I modified this line to look like this:
'F|LastName|1|60|0|0|yes|The person's last name.'
This did not seem to make any difference in how the data is presented
within Access. I've stopped and re-started the openlink broker on the
server with the commands 'oplshut' and 'oplrqb', and had the customer
re-link the tables in Access. There is still no difference.
What am I missing here? I was handed this situation, and haven't done much
of anything with ODBC. I may be missing something here, but don't know
what to look for.
Thanks--
--James--
James Burts james@klas.com
Keystone Systems, Inc. (919)782-1143
Manager of Software Development