Progress & ODBC error

You have to create a View in Progress to work around this problem. I believe the instructions are included in the ODBC kit. You then link/import from the customer view instead of the customer table. The only problem I have with the Part table is the Part Description field is to long. I just dont import that field.
Thanks
Jeremy


-----Original Message-----
From: Larry Barriere [mailto:larrybarriere@...]
Sent: Friday, September 10, 2004 4:09 PM
To: Vantage Group
Subject: [Vantage] Progress & ODBC error


When we had Vantage 5.1 I was able to import all Vantage tables into Access or Excel. Now that we have upgraded to Vantage 6.1.507, Progress 9.1D and Merant 3.60 32-bit Progress SQL92 v9.1d ODBC driver.
I cannot import or link the Customer or the Part Master table into Access. I do not have any problem with other files. I can import the Customer or Part Master table in Excel only if I exclude certain fields. I spoke to Tech about it and they sent me an ODBC fix for it which I had use before on 51 but It didn't work. Can anyone help me figure out why I cannot import those tables into Access
This is the error that I get when importing into Access.
" The operation failed. there are too many indexes on table 'VtQoDefTemp0000'. Delete some of the indexes on the table and try the operation again.

This is the error if I try to link the table instead of importing
" The operation failed. There are too many indexes on table 'PUB_Customer'. Delete some of the indexes on the table and try the operation again.


In Excel I get this error
[DataDirect-Technologies][ODBC Progress driver][Progress]Column formatstr in table PUB_Customer has value exceeding max leght or precision.


signature

---------------------------------
Do you Yahoo!?
Shop for Back-to-School deals on Yahoo! Shopping.

[Non-text portions of this message have been removed]




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
When we had Vantage 5.1 I was able to import all Vantage tables into Access or Excel. Now that we have upgraded to Vantage 6.1.507, Progress 9.1D and Merant 3.60 32-bit Progress SQL92 v9.1d ODBC driver.
I cannot import or link the Customer or the Part Master table into Access. I do not have any problem with other files. I can import the Customer or Part Master table in Excel only if I exclude certain fields. I spoke to Tech about it and they sent me an ODBC fix for it which I had use before on 51 but It didn't work. Can anyone help me figure out why I cannot import those tables into Access
This is the error that I get when importing into Access.
" The operation failed. there are too many indexes on table 'VtQoDefTemp0000'. Delete some of the indexes on the table and try the operation again.

This is the error if I try to link the table instead of importing
" The operation failed. There are too many indexes on table 'PUB_Customer'. Delete some of the indexes on the table and try the operation again.


In Excel I get this error
[DataDirect-Technologies][ODBC Progress driver][Progress]Column formatstr in table PUB_Customer has value exceeding max leght or precision.


signature

---------------------------------
Do you Yahoo!?
Shop for Back-to-School deals on Yahoo! Shopping.

[Non-text portions of this message have been removed]
Larry,

There is a file in the group and also support has the method of creating an
image of your customer table using sql explorer tool using less indexes that
could be connected to Access or Excel. Still, tables that have comments over
1000 chars will be an issue. Something to note when you are creating your
images. You can also update customer through this image (test first).

Have a nice weekend.

Mario Aguirre
Lakin General

-----Original Message-----
From: Larry Barriere [mailto:larrybarriere@...]
Sent: Friday, September 10, 2004 3:09 PM
To: Vantage Group
Subject: [Vantage] Progress & ODBC error

When we had Vantage 5.1 I was able to import all Vantage tables into Access
or Excel. Now that we have upgraded to Vantage 6.1.507, Progress 9.1D and
Merant 3.60 32-bit Progress SQL92 v9.1d ODBC driver.
I cannot import or link the Customer or the Part Master table into Access. I
do not have any problem with other files. I can import the Customer or Part
Master table in Excel only if I exclude certain fields. I spoke to Tech
about it and they sent me an ODBC fix for it which I had use before on 51
but It didn't work. Can anyone help me figure out why I cannot import those
tables into Access
This is the error that I get when importing into Access.
" The operation failed. there are too many indexes on table
'VtQoDefTemp0000'. Delete some of the indexes on the table and try the
operation again.

This is the error if I try to link the table instead of importing
" The operation failed. There are too many indexes on table 'PUB_Customer'.
Delete some of the indexes on the table and try the operation again.


In Excel I get this error
[DataDirect-Technologies][ODBC Progress driver][Progress]Column formatstr in
table PUB_Customer has value exceeding max leght or precision.


signature

---------------------------------
Do you Yahoo!?
Shop for Back-to-School deals on Yahoo! Shopping.

[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>





Yahoo! Groups Sponsor


ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129vt176i/M=298184.5285298.6392945.3001176/D=gr
oups/S=1705007183:HM/EXP=1094933459/A=2319498/R=0/SIG=11thfntfp/*http:/www.n
etflix.com/Default?mqso=60185352&partid=5285298> click here


<http://us.adserver.yahoo.com/l?M=298184.5285298.6392945.3001176/D=groups/S=
:HM/A=2319498/rand=704884171>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.


[Non-text portions of this message have been removed]