ODBC and 5.2

system · November 18, 2002, 11:01am

Troy,

The strange thing is that it always worked with previous releases of
Progress and now running with Progress 9.1D01 it doesn't.

Erik Weiffenbach

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: maandag 18 november 2002 15:52
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC and 5.2

Erik,
I think you may be able to start the oibrkr32.exe from a batch file.
Contact Jay at Epicor for details (or one of the other Tech guys).

Troy Funte
Liberty Electronics

----- Original Message -----
From: Erik Weiffenbach
To: vantage@yahoogroups.com
Sent: Monday, November 18, 2002 9:01 AM
Subject: RE: [Vantage] ODBC and 5.2

We are on Vantage 5.2 with Progress 9.1D01 and still using the Merant 3.6
drivers and starting the ODBC oibrkr32 broker with the procontrol on our
W2K
server.
The problem I encounter is when logging off from the server the
oibrkr32.exe
crashes generating a Dr Watson log. The result is that reports based on
odbc
will not work.

The work around I found is to use the "Remote Desktop Connection" to login
at the server, start oibrkr32.exe with procontrol and disconnect again.
In this situation the broker continues running.

But on our NT server I haven't found any work around....

Erik Weiffenbach
Macroscoop BV

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: vrijdag 15 november 2002 17:00
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC and 5.2

I haven't tried it yet, Ted. I may actually start trying to use the SQL92
drivers in Vantage 5.2 (if/when we move there). We currently still are
using
the old Merant 3.5 drivers with Vantage 5.1. Works great for us. Now
that
the Error 599 is supposedly fixed in 5.2, I may give it a try in the test
database. I'd love to hear anyone's experience on this before I try,
though.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ted Kitch
To: 'vantage@onelist.com'
Sent: Thursday, November 14, 2002 9:26 PM
Subject: [Vantage] ODBC and 5.2

Is anyone using modified Vantage Crystal reports that use ODBC
connections
with version 5.2? I've read an issue on the Crystal Decisions web site.
It
has do with the SQL92 connections (sysprogress) not disconnecting
properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

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

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

[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

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

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

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

[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

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

system · November 14, 2002, 9:24pm

Is anyone using modified Vantage Crystal reports that use ODBC connections
with version 5.2? I've read an issue on the Crystal Decisions web site. It
has do with the SQL92 connections (sysprogress) not disconnecting properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

system · November 15, 2002, 9:17am

Ted,

What I found in 5.1 is that the connection is maintained as soon as you have
the application running. If you close Crystal, it should terminate the
connection.

Mario Aguirre
Lakin General

-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Thursday, November 14, 2002 8:26 PM
To: 'vantage@onelist.com'
Subject: [Vantage] ODBC and 5.2

Is anyone using modified Vantage Crystal reports that use ODBC connections
with version 5.2? I've read an issue on the Crystal Decisions web site. It
has do with the SQL92 connections (sysprogress) not disconnecting properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

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>

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

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

system · November 15, 2002, 10:59am

I haven't tried it yet, Ted. I may actually start trying to use the SQL92 drivers in Vantage 5.2 (if/when we move there). We currently still are using the old Merant 3.5 drivers with Vantage 5.1. Works great for us. Now that the Error 599 is supposedly fixed in 5.2, I may give it a try in the test database. I'd love to hear anyone's experience on this before I try, though.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ted Kitch
To: 'vantage@onelist.com'
Sent: Thursday, November 14, 2002 9:26 PM
Subject: [Vantage] ODBC and 5.2

Is anyone using modified Vantage Crystal reports that use ODBC connections
with version 5.2? I've read an issue on the Crystal Decisions web site. It
has do with the SQL92 connections (sysprogress) not disconnecting properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

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

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

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

system · November 15, 2002, 11:03am

I called Vantage on a similar problem with SQL92 and 5.1. I was
seeing a large number of resources left open for ODBC connections.
After running a ODBC reports the ODBC broker would not release
memory. Almost as if the connection was still open. I never got an
answer for that.

--- In vantage@y..., Ted Kitch <ted@m...> wrote:
> Is anyone using modified Vantage Crystal reports that use ODBC
connections
> with version 5.2? I've read an issue on the Crystal Decisions web
site. It
> has do with the SQL92 connections (sysprogress) not disconnecting
properly
> after running these reports from within Vantage.
>
> Just curious,
>
> Ted Kitch
> ted@m...

system · November 15, 2002, 1:54pm

Troy,

I have been using the Merant 3.6 SQL92 drivers in Vantage 5.2. And it works
great for us. The Error 599 is fixed in all the 5.2 reports I have tried in
my test database. Your post from 9/30 also seems to "automatically" login
for the report.

CY Crystal Reports SCR 4498 5.20.210
To successfully print a customized Crystal report that contains a sub report
and uses an ODBC connection, the following parameters need to be defined in
the vtg file for Vantage:
VantageODBCServer=xxxxxxx (name of odbc server or connection)
VantageODBCDbse=xxxxxxx(database name)
VantageODBCUser=xxxxxxx(database logon userid)
VantageODBCpasswd=xxxxxxxxx(database logon password)

HOWEVER, I don't know about the disconnect issue spoke of early.

David Gartner
EPG Companies Inc.
Vantage 5.20.210, Progress 9.1D
-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, November 15, 2002 10:00 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC and 5.2

I haven't tried it yet, Ted. I may actually start trying to use the SQL92
drivers in Vantage 5.2 (if/when we move there). We currently still are using
the old Merant 3.5 drivers with Vantage 5.1. Works great for us. Now that
the Error 599 is supposedly fixed in 5.2, I may give it a try in the test
database. I'd love to hear anyone's experience on this before I try,
though.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ted Kitch
To: 'vantage@onelist.com'
Sent: Thursday, November 14, 2002 9:26 PM
Subject: [Vantage] ODBC and 5.2

Is anyone using modified Vantage Crystal reports that use ODBC
connections
with version 5.2? I've read an issue on the Crystal Decisions web site.
It
has do with the SQL92 connections (sysprogress) not disconnecting
properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

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

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

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

Yahoo! Groups Sponsor
ADVERTISEMENT

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

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

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

system · November 18, 2002, 9:01am

We are on Vantage 5.2 with Progress 9.1D01 and still using the Merant 3.6
drivers and starting the ODBC oibrkr32 broker with the procontrol on our W2K
server.
The problem I encounter is when logging off from the server the oibrkr32.exe
crashes generating a Dr Watson log. The result is that reports based on odbc
will not work.

The work around I found is to use the "Remote Desktop Connection" to login
at the server, start oibrkr32.exe with procontrol and disconnect again.
In this situation the broker continues running.

But on our NT server I haven't found any work around....

Erik Weiffenbach
Macroscoop BV

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: vrijdag 15 november 2002 17:00
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC and 5.2

I haven't tried it yet, Ted. I may actually start trying to use the SQL92
drivers in Vantage 5.2 (if/when we move there). We currently still are using
the old Merant 3.5 drivers with Vantage 5.1. Works great for us. Now that
the Error 599 is supposedly fixed in 5.2, I may give it a try in the test
database. I'd love to hear anyone's experience on this before I try,
though.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ted Kitch
To: 'vantage@onelist.com'
Sent: Thursday, November 14, 2002 9:26 PM
Subject: [Vantage] ODBC and 5.2

Is anyone using modified Vantage Crystal reports that use ODBC connections
with version 5.2? I've read an issue on the Crystal Decisions web site.
It
has do with the SQL92 connections (sysprogress) not disconnecting properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

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

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

[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

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

system · November 18, 2002, 9:52am

Erik,
I think you may be able to start the oibrkr32.exe from a batch file. Contact Jay at Epicor for details (or one of the other Tech guys).

Troy Funte
Liberty Electronics

----- Original Message -----
From: Erik Weiffenbach
To: vantage@yahoogroups.com
Sent: Monday, November 18, 2002 9:01 AM
Subject: RE: [Vantage] ODBC and 5.2

We are on Vantage 5.2 with Progress 9.1D01 and still using the Merant 3.6
drivers and starting the ODBC oibrkr32 broker with the procontrol on our W2K
server.
The problem I encounter is when logging off from the server the oibrkr32.exe
crashes generating a Dr Watson log. The result is that reports based on odbc
will not work.

The work around I found is to use the "Remote Desktop Connection" to login
at the server, start oibrkr32.exe with procontrol and disconnect again.
In this situation the broker continues running.

But on our NT server I haven't found any work around....

Erik Weiffenbach
Macroscoop BV

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: vrijdag 15 november 2002 17:00
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC and 5.2

I haven't tried it yet, Ted. I may actually start trying to use the SQL92
drivers in Vantage 5.2 (if/when we move there). We currently still are using
the old Merant 3.5 drivers with Vantage 5.1. Works great for us. Now that
the Error 599 is supposedly fixed in 5.2, I may give it a try in the test
database. I'd love to hear anyone's experience on this before I try,
though.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ted Kitch
To: 'vantage@onelist.com'
Sent: Thursday, November 14, 2002 9:26 PM
Subject: [Vantage] ODBC and 5.2

Is anyone using modified Vantage Crystal reports that use ODBC connections
with version 5.2? I've read an issue on the Crystal Decisions web site.
It
has do with the SQL92 connections (sysprogress) not disconnecting properly
after running these reports from within Vantage.

Just curious,

Ted Kitch
ted@...

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

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

[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

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

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

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
L ODBC and 5.2 Yahoo Archive	0	346	November 18, 2002
Crystal & odbc Yahoo Archive	6	655	September 19, 2002
Vantage 5.0 ODBC instructions Yahoo Archive	5	514	April 20, 2001
5.0 - odbc? Yahoo Archive	35	2022	November 9, 2001
Crystal - ODBC Yahoo Archive	7	361	November 28, 2001

ODBC and 5.2

Related Topics