Progress ODBC

system · July 22, 2004, 8:39am

When you install the patch then Progress will first install the software in
a temporary directory. A sub directory of the temp directory contains the
latest datadirect driver.

Ronald van der Linden
Product Manager
Macroscoop BV

Epicor Partner of the Year

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: woensdag 7 juli 2004 19:50
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

I installed 9.1D08 and it still shows the merant version as 3.6. Is there
something I am doing wrong?
Thanks
Jeremy

-----Original Message-----
From: Ronald van der Linden [mailto:R.van.der.Linden@...]
Sent: Wednesday, July 07, 2004 12:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

It is part of the Progress patches 9.1D07 and 9.1D08. I think you can
download them from the Epicor customer support site.

Ronald van der Linden
Product Manager
Macroscoop BV

Epicor Partner of the Year

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: woensdag 7 juli 2004 18:27
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

Where do you get the Data Direct 4.1 driver? Is it a free download from
Progress or Data Direct? If not, what is the cost?
Thanks
Jeremy Leonard

-----Original Message-----
From: Ronald van der Linden [mailto:R.van.der.Linden@...]
Sent: Friday, July 02, 2004 3:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

If you are on Progress 9.1D patch 7 then you can install the Data Direct 4.1
odbc driver. I recommend anyone this driver.

Regardless the driver you are using always check the default isolation
level. The setting at installation time creates locks in the database. You
should always change the default isolation level into "READ UNCOMMITTED" for
those clients using ODBC only for reporting purposes.

Ronald van der Linden
Product Manager
Macroscoop BV

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

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

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

system · June 29, 2004, 2:29pm

What is the specific error you are getting?

-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Tuesday, June 29, 2004 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Progress ODBC

Hi,

We've been working on a few reports in Crystal using an ODBC connection.

These seemed to work fine while only one person was developing and using the ODBC connection.

As soon as we started distributing the report and letting multiple users access ODBC, we started having connection problems. I've called Epicor a few times & was told to adjust my DB settings with the Progress Explorer tool. This really hasn't helped.

Have any of you had ODBC problems when multiple users are accessing the DB?

Any ideas how to fix this?

We're Vantage 6.1 and Progress 9.1D06.

BTW,

The latest call to Epicor resulted in the tech saying to put in Progress patch 08.

I'm downloading now.

Thanks,

Bruce Ordway

[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

system · June 30, 2004, 3:13am

What version of progress/vantage are you using? Are you using the SQL92 driver or the older driver?

-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Tue 6/29/2004 4:03 PM
To: vantage@yahoogroups.com
Cc:
Subject: RE: [Vantage] Progress ODBC

I haven't kept good records to this point.

Here's the latest from this morning.

Got this error when creating a view in Access to look at the customer table.

It worked fine when we recreated it in a test db

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC Progress Driver]:Failure to acquire exclusive schema lock for DDL operation. (7872)

-----Original Message-----

From: Jeremy Leonard [mailto:jeremy.leonard@...]

Sent: Tue 6/29/2004 1:29 PM

To: vantage@yahoogroups.com

Cc:

Subject: RE: [Vantage] Progress ODBC

What is the specific error you are getting?

-----Original Message-----

From: Ordway, Bruce [mailto:bruceo@...]

Sent: Tuesday, June 29, 2004 2:28 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Progress ODBC

Hi,

We've been working on a few reports in Crystal using an ODBC connection.

These seemed to work fine while only one person was developing and using the ODBC connection.

As soon as we started distributing the report and letting multiple users access ODBC, we started having connection problems. I've called Epicor a few times & was told to adjust my DB settings with the Progress Explorer tool. This really hasn't helped.

Have any of you had ODBC problems when multiple users are accessing the DB?

Any ideas how to fix this?

We're Vantage 6.1 and Progress 9.1D06.

BTW,

The latest call to Epicor resulted in the tech saying to put in Progress patch 08.

I'm downloading now.

Thanks,

Bruce Ordway

[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

------------------------ Yahoo! Groups Sponsor --------------------~-->

Yahoo! Domains - Claim yours for only $14.70

http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM

--------------------------------------------------------------------~->

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

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

------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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

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

system · July 2, 2004, 3:50am

If you are on Progress 9.1D patch 7 then you can install the Data Direct 4.1
odbc driver. I recommend anyone this driver.

Regardless the driver you are using always check the default isolation
level. The setting at installation time creates locks in the database. You
should always change the default isolation level into "READ UNCOMMITTED" for
those clients using ODBC only for reporting purposes.

Ronald van der Linden
Product Manager
Macroscoop BV

-----Original Message-----
From: Ordway, Bruce [mailto:bruceo@...]
Sent: Thursday, July 01, 2004 11:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

Progress 9 latest patch level.
SQL92

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: Wed 6/30/2004 2:13 AM
To: vantage@yahoogroups.com
Cc:
Subject: RE: [Vantage] Progress ODBC

What version of progress/vantage are you using? Are you using the
SQL92 driver or the older driver?

-----Original Message-----

From: Ordway, Bruce [mailto:bruceo@...]

Sent: Tue 6/29/2004 4:03 PM

To: vantage@yahoogroups.com

Cc:

Subject: RE: [Vantage] Progress ODBC

I haven't kept good records to this point.

Here's the latest from this morning.

Got this error when creating a view in Access to look at the
customer table.

It worked fine when we recreated it in a test db

=== SQL Exception 1 ===

SQLState=HY000

ErrorCode=-210017

[JDBC Progress Driver]:Failure to acquire exclusive schema
lock for DDL operation. (7872)

-----Original Message-----

From: Jeremy Leonard
[mailto:jeremy.leonard@...]

Sent: Tue 6/29/2004 1:29 PM

To: vantage@yahoogroups.com

Cc:

Subject: RE: [Vantage] Progress ODBC

What is the specific error you are getting?

-----Original Message-----

From: Ordway, Bruce [mailto:bruceo@...]

Sent: Tuesday, June 29, 2004 2:28 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Progress ODBC

Hi,

We've been working on a few reports in Crystal using
an ODBC connection.

These seemed to work fine while only one person was
developing and using the ODBC connection.

As soon as we started distributing the report and
letting multiple users access ODBC, we started having connection problems.
I've called Epicor a few times & was told to adjust my DB settings with the
Progress Explorer tool. This really hasn't helped.

Have any of you had ODBC problems when multiple
users are accessing the DB?

Any ideas how to fix this?

We're Vantage 6.1 and Progress 9.1D06.

BTW,

The latest call to Epicor resulted in the tech
saying to put in Progress patch 08.

I'm downloading now.

Thanks,

Bruce Ordway

[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

------------------------ Yahoo! Groups Sponsor
--------------------~-->

Yahoo! Domains - Claim yours for only $14.70

http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM

--------------------------------------------------------------------~->

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

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

------------------------ Yahoo! Groups Sponsor
--------------------~-->

Yahoo! Domains - Claim yours for only $14.70

http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM

--------------------------------------------------------------------~->

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

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

------------------------ Yahoo! Groups Sponsor
--------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM

--------------------------------------------------------------------~->

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

[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

system · July 7, 2004, 12:27pm

Where do you get the Data Direct 4.1 driver? Is it a free download from Progress or Data Direct? If not, what is the cost?
Thanks
Jeremy Leonard

-----Original Message-----
From: Ronald van der Linden [mailto:R.van.der.Linden@...]
Sent: Friday, July 02, 2004 3:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

If you are on Progress 9.1D patch 7 then you can install the Data Direct 4.1
odbc driver. I recommend anyone this driver.

Regardless the driver you are using always check the default isolation
level. The setting at installation time creates locks in the database. You
should always change the default isolation level into "READ UNCOMMITTED" for
those clients using ODBC only for reporting purposes.

Ronald van der Linden
Product Manager
Macroscoop BV

system · July 7, 2004, 12:48pm

It is part of the Progress patches 9.1D07 and 9.1D08. I think you can
download them from the Epicor customer support site.

Ronald van der Linden
Product Manager
Macroscoop BV

Epicor Partner of the Year

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: woensdag 7 juli 2004 18:27
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

Where do you get the Data Direct 4.1 driver? Is it a free download from
Progress or Data Direct? If not, what is the cost?
Thanks
Jeremy Leonard

-----Original Message-----
From: Ronald van der Linden [mailto:R.van.der.Linden@...]
Sent: Friday, July 02, 2004 3:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

If you are on Progress 9.1D patch 7 then you can install the Data Direct 4.1
odbc driver. I recommend anyone this driver.

Regardless the driver you are using always check the default isolation
level. The setting at installation time creates locks in the database. You
should always change the default isolation level into "READ UNCOMMITTED" for
those clients using ODBC only for reporting purposes.

Ronald van der Linden
Product Manager
Macroscoop BV

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

system · July 7, 2004, 1:50pm

I installed 9.1D08 and it still shows the merant version as 3.6. Is there something I am doing wrong?
Thanks
Jeremy

-----Original Message-----
From: Ronald van der Linden [mailto:R.van.der.Linden@...]
Sent: Wednesday, July 07, 2004 12:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

It is part of the Progress patches 9.1D07 and 9.1D08. I think you can
download them from the Epicor customer support site.

Ronald van der Linden
Product Manager
Macroscoop BV

Epicor Partner of the Year

-----Original Message-----
From: Jeremy Leonard [mailto:jeremy.leonard@...]
Sent: woensdag 7 juli 2004 18:27
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

Where do you get the Data Direct 4.1 driver? Is it a free download from
Progress or Data Direct? If not, what is the cost?
Thanks
Jeremy Leonard

-----Original Message-----
From: Ronald van der Linden [mailto:R.van.der.Linden@...]
Sent: Friday, July 02, 2004 3:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Progress ODBC

If you are on Progress 9.1D patch 7 then you can install the Data Direct 4.1
odbc driver. I recommend anyone this driver.

Regardless the driver you are using always check the default isolation
level. The setting at installation time creates locks in the database. You
should always change the default isolation level into "READ UNCOMMITTED" for
those clients using ODBC only for reporting purposes.

Ronald van der Linden
Product Manager
Macroscoop BV

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

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

system · July 7, 2004, 4:11pm

I am trying to get an odbc connection from ASP on IIS to Vantage.
The connection from the IIS server in Excel works, but through ASP I
get the following error: Specified driver could not be loaded due to
system error 5 (MERANT 3.60 32-BIT Progress SQL92 v9.1D).

Any idea what "system error 5 is?

Thanks,

Rob

system · July 7, 2004, 10:44pm

I found this on a message board after a quick google search - it might apply to your situation:

Or simply:
On filesystem, locate the oracle folder
give full control permissions to that folder on your IIS accounts
test
as it works, remove the iis acccounts from those
listed in "security" tab for that folder.
Test again: it should work!

Obviously - you would tweak the MFGSYSx folder (assuming the default db location)

Charles

----- Original Message -----
From: gfxltd2004
To: vantage@yahoogroups.com
Sent: Wednesday, July 07, 2004 4:11 PM
Subject: [Vantage] Progress ODBC

I am trying to get an odbc connection from ASP on IIS to Vantage.
The connection from the IIS server in Excel works, but through ASP I
get the following error: Specified driver could not be loaded due to
system error 5 (MERANT 3.60 32-BIT Progress SQL92 v9.1D).

Any idea what "system error 5 is?

Thanks,

Rob

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 Sponsor
ADVERTISEMENT

------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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

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

Topic		Replies	Views
Progress odbc driver Yahoo Archive	2	745	June 6, 2001
Progress database driver Yahoo Archive	7	786	May 23, 2008
All this ODBC Stuff? Yahoo Archive	11	645	October 10, 2002
Merant ODBC driver for custom traveler Yahoo Archive	6	668	February 7, 2002
L ODBC and 5.2 Yahoo Archive	0	392	November 18, 2002

Progress ODBC

Related Topics