ODBC problems

system · June 7, 2001, 9:20am

Joe,
The "Unable to undestand after Declare" error can be fixed by downloading and running the "ivpro14.reg" from the following link: http://groups.yahoo.com/group/vantage/files/Reports%20-%20Crystal%20Reports/ODBC/ivpro14%20for%203.5.reg
It is a registry fix to load a .dll that Merant ODBC 3.5 needs for Progress.
Another file, "ivpro15.reg" is only for Merant ODBC version 3.6.

Your workaround is quite interesting, though.

Troy Funte
Liberty Electronics

----- Original Message -----
From: joealmeida@...
To: vantage@yahoogroups.com
Sent: Thursday, June 07, 2001 8:55 AM
Subject: RE: [Vantage] ODBC problems

Hi Bart

We used to get all sorts of errors when using the Merant Drivers on Vantage
3.00 and 4.00. Most were that "cannot understand after DECLARE" type
errors. When ever we used Crystal Reports to link tables, any table linking
that I did that was beyond four table across or with complicated table
linking gave this error. I came across this error as well in Access. To
get around this I "cheated". I would use Progress Report Builder to create
links and filter conditions. I would then press Ctrl-Alt-P and then press
F12. What comes up is the SQL Statement! You now can copy then paste that
whole statement right into any program that can use SQL statements! Just be
sure that you strip the READ ONLY text at the end of the SQL statement. I
should run like a charm. We've done this with Crystal Reports, Excel,
Microsoft Query, and Access. I suspect whenever we use the graphical
methods to link tables in other programs like Crystal, the query that is
created is not fully compliant with what is submitted to the Progress
Database.

I realize this is not the direct answer to your question, but this is a
possible avenue to get around your problem and make effective use of any
reporting program you want to use.

Good Luck!

Joe Almeida
Telecommunications Co-ordinator
Royal Laser Corp.
Toronto, ON, Canada

-----Original Message-----
From: Sgroi, Bart T. [mailto:btsgroi@...]
Sent: Wednesday, June 06, 2001 2:49 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] ODBC problems

Thanks Sarah,
At least it tells me there is a little hope that I may get it right.

Bart

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Yahoo! Groups Sponsor

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · June 6, 2001, 2:23pm

We are currently using Vantage 3.00.632 and the Merant ODBC driver
version 3.50. The problems that we are encountering are when we use MS
Access to link to tables in the progress database(ver. 8.3b). The links
work fine if you don't close Access. If you do close Access, when you
reopen the Access application, you need to relink the tables to avoid
getting an access violation when trying to view the data. This makes it
hard to distribute compiled version of our Access applications. Is anyone
successfully using MS Access to query their Progress database and if so
would you mind sharing your configuration settings.

Bart Sgroi

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

system · June 6, 2001, 2:34pm

We have many access reports and files that are linked to the Vantage data.
We started these on 3.0 with access 97 and then updated them to 4.0 access
2000 when we upgraded (about a year ago). We have never seen this problem.
On 3.0, everything ran very smoothly. Once the tables were linked, we could
close access and re-open it anytime to run the reports and we never got and
error. We used this for about a year before upgrading to 4.0. Since moving
to 4.0, occasionally we do get an error although not the one you mention,
but if we wait a second and try it again, it works. Still haven't figured
out why that happens. As for our setting, the ODBC is set up exactly as the
Epicor directions says. To link to access, all I did was open a new
database, go to 'get external data', 'link tables', chose 'ODBC' as the file
type, and chose "progress Remote OID' as the source. Never had to look at
that again.

Sorry, this probably wasn't much help.

-----Original Message-----
From: Sgroi, Bart T. [mailto:btsgroi@...]
Sent: Wednesday, June 06, 2001 2:22 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] ODBC problems

We are currently using Vantage 3.00.632 and the Merant ODBC driver
version 3.50. The problems that we are encountering are when we use MS
Access to link to tables in the progress database(ver. 8.3b). The links
work fine if you don't close Access. If you do close Access, when you
reopen the Access application, you need to relink the tables to avoid
getting an access violation when trying to view the data. This makes it
hard to distribute compiled version of our Access applications. Is anyone
successfully using MS Access to query their Progress database and if so
would you mind sharing your configuration settings.

Bart Sgroi

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

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

system · June 6, 2001, 2:50pm

Thanks Sarah,
At least it tells me there is a little hope that I may get it right.

Bart

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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

system · June 6, 2001, 4:50pm

Some time ago someone mentioned problems with Access and ODBC when looking at 'blob' or 'memo' fields. Apparently one or the other can't handle huge fields like Part Descriptions very well. Sorry I can't be more detailed, I'm just throwing you some straws to grasp at.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Sgroi, Bart T.
To: 'vantage@yahoogroups.com'
Sent: Wednesday, June 06, 2001 2:21 PM
Subject: [Vantage] ODBC problems

We are currently using Vantage 3.00.632 and the Merant ODBC driver
version 3.50. The problems that we are encountering are when we use MS
Access to link to tables in the progress database(ver. 8.3b). The links
work fine if you don't close Access. If you do close Access, when you
reopen the Access application, you need to relink the tables to avoid
getting an access violation when trying to view the data. This makes it
hard to distribute compiled version of our Access applications. Is anyone
successfully using MS Access to query their Progress database and if so
would you mind sharing your configuration settings.

Bart Sgroi

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

Yahoo! Groups Sponsor

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · June 7, 2001, 8:56am

Hi Bart

We used to get all sorts of errors when using the Merant Drivers on Vantage
3.00 and 4.00. Most were that "cannot understand after DECLARE" type
errors. When ever we used Crystal Reports to link tables, any table linking
that I did that was beyond four table across or with complicated table
linking gave this error. I came across this error as well in Access. To
get around this I "cheated". I would use Progress Report Builder to create
links and filter conditions. I would then press Ctrl-Alt-P and then press
F12. What comes up is the SQL Statement! You now can copy then paste that
whole statement right into any program that can use SQL statements! Just be
sure that you strip the READ ONLY text at the end of the SQL statement. I
should run like a charm. We've done this with Crystal Reports, Excel,
Microsoft Query, and Access. I suspect whenever we use the graphical
methods to link tables in other programs like Crystal, the query that is
created is not fully compliant with what is submitted to the Progress
Database.

I realize this is not the direct answer to your question, but this is a
possible avenue to get around your problem and make effective use of any
reporting program you want to use.

Good Luck!

Joe Almeida
Telecommunications Co-ordinator
Royal Laser Corp.
Toronto, ON, Canada

-----Original Message-----
From: Sgroi, Bart T. [mailto:btsgroi@...]
Sent: Wednesday, June 06, 2001 2:49 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] ODBC problems

Thanks Sarah,
At least it tells me there is a little hope that I may get it right.

Bart

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/