5.0 - odbc?

system · November 9, 2001, 12:04pm

I installed 8.5 first (as recommended by Crystal) and then I installed the
downgrade they sell for $35.00 to 8.0. ODBC, Crystal and Vantage 5.0 seem to
work fine. It is Access2002 the one I have the ODBC fail calls and
corruptions.

Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, November 09, 2001 10:55 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.0 - ODBC?

What did you install - Crystal 8 or Vantage 5.1??

Troy Funte
Liberty Electronics

----- Original Message -----
From: Mario Aguirre
To: vantage@yahoogroups.com
Sent: Friday, November 09, 2001 12:00 PM
Subject: RE: [Vantage] 5.0 - ODBC?

I just finish installing it and run a report with a table containing 21k
and
some record. It worked fine. I am testing it now in the server and see how
it performs.

Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631

-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, November 09, 2001 10:05 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 5.0 - ODBC?

>install Crystal 8.5 and downgrade to 8.0

It may be best to uninstall crystal entirely before putting another
version
on your PC. I installed 8.0 over 7.0, and ended up having to reformat
before it worked entirely.

Thaddeus

-----Original Message-----
From: Mario Aguirre [mailto:maguirre@...]
Sent: Friday, November 09, 2001 8:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 5.0 - ODBC?

I have 523 mgs of mem, Pentium 4 at 1400 MHz. The server and network are
not
that sophisticated. I will keep you posted when I receive and install 5.1
and 9.1C. We need ODBC to be more stable because we use Access to
"massage"
the data used for EDI. I will install Crystal 8.5 and downgrade to 8.0 to
see how ODBC behaves. Maybe, it will be better (or worse)...

Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 08, 2001 6:37 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.0 - ODBC?

Do you think it is a memory issue? I've know Excel to blow up when there
is
too much info coming in. I really don't have any other clues. Do you
have
access to the Merant ODBC driver? I'd be curious whether that works
better.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Mario Aguirre
To: vantage@yahoogroups.com
Sent: Thursday, November 08, 2001 6:31 PM
Subject: RE: [Vantage] 5.0 - ODBC?

I AM USING WIN2000 AND ACCESS 2002. THE LINKS WORK FINE UNTIL THE
RECORDS
APPROACH 7000 TO 8000 RECORDS. I WOULD LIKE TO RE-START AND DO ONLY THE
LENGTH OF INDEX DESCRIPTION FIX. I WAS ABLE TO READ TABLES WITH MORE
RECORDS
AND DID NOT HAVE TO ENTER PASSWORDS WHEN LINKING TABLES. I AM ALSO
WAITING
FOR 5.1. WE ARE PREPARING TO JUMP FROM 4.0 TO 5.1. I HEARD 9.1C DRIVERS
ARE
MORE STABLE...

Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 08, 2001 4:50 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.0 - ODBC?

Mario,
Are you getting the error in Crystal or Access or Excel, or what?
(about the corrupt tables).

Troy Funte
Liberty Electronics

----- Original Message -----
From: Mario Aguirre
To: vantage@yahoogroups.com
Sent: Thursday, November 08, 2001 3:53 PM
Subject: RE: [Vantage] 5.0 - ODBC?

This was one of the documents I used to connect to ODBC. Since then, I
have
applied all fixes (.r's) and follow all instructions. I am still
having
the
problem that if a table has more than 7000 or 8000 records, I get an
ODBC
failed error message and corrupt the table.

-------------------------------------------------------------
How to connect an ODBC Client to eManufacturing database

Go to your ODBC Datasource Admininstrator in the Control Panel.

If you don't see the driver
MERANT 3.60 32-Bit Progress SQL92 v9.1A
Under User DSN, You will need to add it by choosing the Add button and
finding the above mentioned driver and then choose finish.

The next screen will be the configuration screen

Enter the Data Source Name -- Progress 9.1A ODBC
Enter the Description -- eManufacturing by Epicor
Enter the Host Name -- (Name of your Server)
Enter the port Number associated with the Database -- (Located in your
services file)
Enter the Database Name -- vantage
Enter User ID - sysprogress
No password is needed

Try clicking on the test connect button and then OK
You should get a message saying Connection established.

Mario Aguirre
Lakin General
2865 N. Paulina
Chicago, IL 60657
Ph: 773-871-9631
Fx: 773-871-1265

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, November 08, 2001 8:07 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 5.0 - ODBC?

I would love it if you didn't need a password, but all that I've read
says
it's required - and is built into the SQL-92 drivers. If anyone can
get
it
working otherwise, PLEASE let me know. It seems to me that Jay
Erickson's
instructions of imbedding the password in the ODBC configuration file
was
meant to work with programs like Access and Excel, but not with
Crystal.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Mario Aguirre
To: vantage@yahoogroups.com
Sent: Wednesday, November 07, 2001 11:22 AM
Subject: RE: [Vantage] 5.0 - ODBC?

Do you mean the user ID? Sysprogress should be the user ID and
password
should be clear. I set up the client (with the user id) and the ODBC
settings in Progress Explorer following the instructions and
installing
all
patches. Whenever an ODBC link is used, ODBC will call the connect
window
and clicking OK should be enough.

Did you assign a password to user id sysprogress?

Mario Aguirre
Lakin General
Chicago, IL 60657
Ph: 773-871-9631

-----Original Message-----
From: sarah.vareschi@...
[mailto:sarah.vareschi@...]

Sent: Wednesday, November 07, 2001 9:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 5.0 - ODBC?

With the new ODBC, is there a ways to shut-off the password so that
users
running reports don't have to type it in each time they run access a
database or reports?

[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/

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]

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/

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]

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/

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]

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 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 http://docs.yahoo.com/info/terms/

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]

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 6, 2001, 11:02am

I think I'm missing something. We went to 5.0 this past weekend and I am
unable to connect a client using ODBC. I have searched the Egroups file
sand I found instructions to set-up the "ODBC Server Configuration" and for
"CONFIGURING the ODBC CLIENT". I followed the directions as listed, but
when I click 'Test Connect' on the client, the system just hangs. Has
anyone else run into this and possibly have a solution?

Thanks,

Sarah

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

system · November 6, 2001, 11:21am

I changed the port from the vantage database to port(2500) to the odbc port
(2550) and the test connect now works. However, now when I go to access to
refresh my links, I get the error:

ODBC - Call Failed
[Merant][ODBC Progress driver][PROGRESS]Access denied(Authorisation
failed)(7512)(#-20228)

Anyone know what this is or how to fix it?

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

system · November 6, 2001, 11:25am

Sarah,

Did you run the odbcfix.r and the fixuser.r from Epicor? It will not work
until these "patches" are run.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"

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

system · November 6, 2001, 11:27am

Look at how you've NAMED your data source on the server and how you've NAMED
the data source on the workstations. If they aren't precisely, exactly the
same, no connection.

Shirley H. Graver
(End User)
Systems Administrator
Rubber Associates Inc.

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

system · November 6, 2001, 11:27am

Thanks, Rick. No, I didn't find those. I will check the website for a
download or call epicor support to get them. THANKS!

-Sarah

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

system · November 6, 2001, 12:40pm

Which ODBC are you trying to set up - Merant or SQL-92?

If using the SQL-92, there are three fixes you will want to apply. They are on the eGroups files list in a zip file which contains: odbcfix.r, odbsuser.r and the registry fix. http://groups.yahoo.com/group/vantage/files/_Misc/
There are several ODBC helps in the Misc Directory.

Troy

----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Tuesday, November 06, 2001 11:14 AM
Subject: [Vantage] 5.0 - ODBC?

I think I'm missing something. We went to 5.0 this past weekend and I am
unable to connect a client using ODBC. I have searched the Egroups file
sand I found instructions to set-up the "ODBC Server Configuration" and for
"CONFIGURING the ODBC CLIENT". I followed the directions as listed, but
when I click 'Test Connect' on the client, the system just hangs. Has
anyone else run into this and possibly have a solution?

Thanks,

Sarah

[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 the Yahoo! Terms of Service.

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

system · November 6, 2001, 12:43pm

I am working on the SQL 92. Thanks for your feedback. I have located those
files and will now wait until after hours to do the update as the
instructions say that all users have to be logged off.

Thanks,

Sarah

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

system · November 6, 2001, 6:49pm

I ran the two fixes that were posted (ODBCfix and ODBCuser). They both said
they completed successfully, but now I can't even test connect without
getting an error. (I could test connect before the fixes)

The error I am getting when I test connect is:

[MERANT][ODBC PROGRESS driver]Invalid attribute in connection string:
Description. [MERANT][ODBC PROGRESS driver][PROGRESS]Access
Denied(Authorisation failed)

Anybody know what's going on?

Thanks for any feedback,

-Sarah

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

system · November 6, 2001, 7:02pm

How about using the old TELNET test. It should at least tell you whether
the server is listening on the port.

eg Start, Run, TELNET, Connect, Remote System, IP address, change "telnet"
to 2550 (or whatever you are using for ODBC). Should connect with nothing
displayed on the screen, and allow you to disconnect.
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, 7 November 2001 11:01
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 5.0 - ODBC?

I ran the two fixes that were posted (ODBCfix and ODBCuser). They both said
they completed successfully, but now I can't even test connect without
getting an error. (I could test connect before the fixes)

The error I am getting when I test connect is:

[MERANT][ODBC PROGRESS driver]Invalid attribute in connection string:
Description. [MERANT][ODBC PROGRESS driver][PROGRESS]Access
Denied(Authorisation failed)

Anybody know what's going on?

Thanks for any feedback,

-Sarah

system · November 6, 2001, 7:08pm

I'm willing to try anything, except I've never used telnet before. I can
get to start, run, and typing in 'Telnet' fine, then a dos-looking window
pops up with a Microsoft telnet> prompt. What do I type there?

Thanks!!

---------------------------------------
How about using the old TELNET test. It should at least tell you whether
the server is listening on the port.

eg Start, Run, TELNET, Connect, Remote System, IP address, change "telnet"
to 2550 (or whatever you are using for ODBC). Should connect with nothing
displayed on the screen, and allow you to disconnect.

----------------------------
Sarah Vareschi
Systems Engineer
NyproMold, Inc.
Tel: 978-368-4718
Fax: 978-365-4548
sarah.vareschi@...

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

system · November 6, 2001, 7:11pm

Does anyone know if anything needs to be added to the client services file
referencing the 2550 port?

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

system · November 6, 2001, 7:19pm

Er yuck ... I only have 95 and NT and they have a GUI TELNET (at least with
the standard MS stuff I have loaded). Anyway, from a command prompt try
"TELNET <IP> <PORT" and it should do the same thing.
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Wednesday, 7 November 2001 11:20
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 5.0 - ODBC?

I'm willing to try anything, except I've never used telnet before. I can
get to start, run, and typing in 'Telnet' fine, then a dos-looking window
pops up with a Microsoft telnet> prompt. What do I type there?

Thanks!!

---------------------------------------
How about using the old TELNET test. It should at least tell you whether
the server is listening on the port.

eg Start, Run, TELNET, Connect, Remote System, IP address, change "telnet"
to 2550 (or whatever you are using for ODBC). Should connect with nothing
displayed on the screen, and allow you to disconnect.

----------------------------
Sarah Vareschi
Systems Engineer
NyproMold, Inc.
Tel: 978-368-4718
Fax: 978-365-4548
sarah.vareschi@...

[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 6, 2001, 7:45pm

Sarah,

I assume you set up the ODBC in the Progress Explorer tool, correct? You have to add another group below the DefaultConnections, it has to be SQL, and this is where you set the port number, and the service name. Is the ODBC part of it running?

You've checked that the port number on the server to verify it matches the client? 2550 sounds like the recommended port number for Vantage 5.0. And NO, you shouldn't need to reference that port in the services file with SQL drivers.

Are you typing in the password "sysprogress"? You didn't need a password for Merant, but you do need one for each login with the SQL-92 drivers.

I can send you screen shots of what I have if you need.

Troy Funte
Liberty Electronics

----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Tuesday, November 06, 2001 7:22 PM
Subject: RE: [Vantage] 5.0 - ODBC?

Does anyone know if anything needs to be added to the client services file
referencing the 2550 port?

[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 the Yahoo! Terms of Service.

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

system · November 7, 2001, 9:10am

Thanks you to everyone who helped me out with this ODBC problem and thank
you Troy for the screen shots and notes. You were exactly right; I was
leaving the password blank. In the instructions I downloaded it
specifically says 'No Password is needed' however, when I followed your
instructions and put in the password in, I get the 'connection established'
screen. Thanks so much for taking the time. I really, REALLY appreciate it
(Especially as the president of my company is waiting for the access reports
we have through ODBC to work again). Next step for me is trying to update
those...

Thanks again!!

-Sarah

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

system · November 7, 2001, 10:01am

With the new ODBC, is there a ways to shut-off the password so that users
running reports don't have to type it in each time they run access a
database or reports?

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

system · November 7, 2001, 10:10am

I was just watching the performance monitor on the Vantage server while I
was running an ODBC report (which took a couple minutes to run) and it shot
to 100% and stayed there until the ODBC application was closed. Does
anybody know if this is normal, or if there is a way to reduce that?

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

system · November 7, 2001, 10:12am

Sarah,

Jay Erickson at Epicor sent me this some time ago. I could never get it to work, but maybe you can. I wasn't too motivated at the time because we don't use SQL-92 on a live database. Maybe you can get it going???? Let us all know.

Troy

-----------Beginning of forwarded message --------------------
You asked for this some time ago and we finally got it to work.
Below are instructions for bypassing the UserID and Password when connecting
to the database using ODBC. Now it appears there is a limitation in the
fact that Microsoft products works just fine, however Crystal does not know
what the PWD= parameter is and pops up the Login box anyway.
We have found for Crystal if you use the "Report Distribution
Expert" and create a distributed report, it does save the LoginID and
Password.

===========================================

How to save a password in an ODBC Data Source that uses MERANT ODBC
driver (SQL-89 or SQL-92).

EXPLANATION:

Some customers ask how can they save the user id and password in the
ODBC Data Source in order to connect to the Progress Database from
another application through ODBC (using the MERANT driver) without any
user input.

SOLUTION:

This kb is valid for SQL-89 and SQL-92, it has been tested with ODBC
MERANT driver 3-60 SQL-89 and SQL-92.

You will have to create a File DSN (instead of a System DSN or User
DSN) through the ODBC Data Source Administartor.

Once you have created it and tested the connection you will modify the file
just created. By default this file is kept in the directory: C:\Program
Files\Common Files\ODBC\Data Sources. Using Notepad or Wordpad edit and add
(or modify) the following lines:

UID=<userID>
PWD=<password>

The UID will already be present as 'sysprogress'. Simply open a new line
just beneith it and add PWD=sysprogress

*** NOTE: Once you have done this, you can't modify or save the File DSN
again on this workstation through the ODBC DS Administrator because it will
overwrite the file that you have modified and you will need to add one or
both of the lines again.

Afterwards if you, for example, use Excel to get the external data from a
Progress Database you will see that it doesn't ask for any user ID or
password.

==============================================

Example of a "SQL-92" File DSN after the modifications:

[ODBC]
Driver=MERANT 3.60 32-BIT Progress SQL92 v9.1A
UID=sysprogress
PWD=sysprogress
HOST=ntserver1
PORT=2550
DB=vantage

==============================================

Example of a "SQL-89" File DSN after the modifications:

[ODBC]
DRIVER=MERANT 3.60 32-BIT PROGRESS
UID=sysprogress
PWD=sysprogress
DB=vantage
OIDP=TCP
OIDS=prosv02
OIDH=pcjnunez2
DBAM=Via Server
DBPR=TCP
DBS=prosv01
DBH=pcjnunez2
DBOS=Windows
ASC=0
SR=1
GST=0

Thanks, Jay Erickson
Vantage Technical Support Analyst
Epicor Software Corp.
jaerickson@...
SupportNet: http://www.epicor.com

------------------End of Forwarded message -------------------------------

----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Wednesday, November 07, 2001 10:12 AM
Subject: RE: [Vantage] 5.0 - ODBC?

With the new ODBC, is there a ways to shut-off the password so that users
running reports don't have to type it in each time they run access a
database or reports?

[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 the Yahoo! Terms of Service.

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

system · November 7, 2001, 10:14am

Thanks again, Troy. I'll try it out and report back.

Thanks,
Sarah

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

system · November 7, 2001, 10:21am

Sarah,
Here's all we know on the subject. Again, from Jay at Epicor - Performance tuning for Progress Explorer and ODBC.

Troy

----------------Beginning of Forwarded message ---------------------------
PROBLEM DESCRIPTION: How to set and fine tune the Progress Explorer
Tool, Default Configuration Settings and Parameters for both Vantage Clients
and ODBC Clients.

XA500

PROBLEM RESOLUTION:

=======================================
OPTIMIZING the PROGRESS EXPLORER TOOL
=======================================

To get the most out if each parameter, you will need to know the following
information ahead of time. Also consider the total number of users that
would potentially connect via ODBC. Fill in A through C below with the
appropriate values.

A) Your server's total RAM. Total: ____________MB

B) Total number of con-current connections being made to the database. This
would typically be the sum of all Vantage users (Office and DataCollection)
plus Report Builder users and Results Report users. These users are
considered "4GL Users". This total number is typically increased by 10 to
15 percent to compensate for dropped, hung or forgotten connections.
Total:___________________ 4GL Connections.

C) Total number of ODBC connections. These users are considered "SQL
Users". Each ODBC broker is a one-to-one with the user. So for example,
if you create a Crystal Report using ODBC and embed this report into the
Vantage menu where potentially all of your users could access it at the same
time, then the ODBC/SQL value would equal your total number of con-current
4GL user connections in the field above. Total ODBC
users/connections:_________________ SQL Connections.

HOW and WHERE to make the Changes:
=================================

NOTE: Changes to the Progress Explorer Tool can be made at any time. For
the changes to take effect, the database will need to be stopped and
restarted. In addition, we would recommend the Server be re-booted after
changes are made and the database has been stopped.

At the NT Server console

1. Open the Progress Explorer Tool for 9.1 and Log into Progress MMC.
Select CONSOLE --> OPTIONS. Make sure the "Open Console in Author Mode" is
checked.

** Note for Windows2000 you will need to add a switch to the Progress
Explorer Tool icon properties line. Add the switch /a into the Target
line ( ...mmc.exe /s /a "d:\91a\proexp.msc" ) Ok and save the icon changes.
See doc 996MPS for more details.

2. Double click on LocalHost server icon to display Databases. Again
double click on the Databases folder icon to display installed databases.
You should see two blue drums one titled EPIC50 and one titled EPIC50TRN.

3. Locate the Epic50 Database and double click. Double click again on the
"Configurations" folder to display the DefaultConfigurations blue drum.

4. Right mouse click on the DefaultConfigurations, select Properties. The
numbers entered in this screen will be TOTAL values on the one or two
ServerGroup screens under the DefaultConfiguration in the tree. This will be
based on whether or not you are implementing ODBC connections.

Change the following fields under each group that best reflects your setup
and environment.

** The fields discussed in this document will be only those that should be
changed from the default configuration value.

GENERAL:

- # Blocks in DB Buffer =

For the Live Production Database, this should be set at 1/3 to Â½ of your
server's
total RAM. Leave the Training database at zero. So if your Server has 512
MB
RAM, you would want to allocate approximately 170 to 256 MB RAM. Use the
grid below to best select the Number of Blocks you wish to put into the
Buffer.

Setting RAM Allocated
====== ============
10000 42.2 MB RAM
20000 83.8 MB
30000 125.3 MB
40000 166.5 MB
50000 210.7 MB
60000 252.9 MB
70000 295.1 MB
80000 337.3 MB
90000 379.5 MB
100000 421.7 MB
110000 463.9 MB
120000 506.1 MB
etc...

* Each 10000 unit increase equals approximate 41.5 MB RAM

- # Hash Table entries = 0 (Leave at default - DO NOT CHANGE)

- # Lock table entries = 8192 (Leave at default)

- Maximum Users =

Maximum Users is your total number of ALL users + 10 to 15 %. IF, you are
considering ODBC connections, add these in now. (i.e. 100 Vantage and
Report Builder Users + 15% = 115, plus 50 ODBC users = 165 Maximum Users).
Enter the number in this field.

- Maximum Servers =

The Maximum Servers on this page/screen is an accumulative total of the
Vantage (4GL users) divided by 4 PLUS the total ODBC or SQL users PLUS one.

--> If ODBC is being implemented, and we use the example above, 115 4GL
users divided by 4 = 28.75 or 29 + 50 + 1 = 80 Maximum Servers.

--> If you are NOT implementing ODBC at this time, simply take the total
number of 4GL users (item B from above) and divide by 4. So again, 115
4GL users divided by 4 = 28.75 or 29. Always round up to the next whole
number.

The number 4 is the total number of users allowed per 4GL Server broker.
This number has been chosen for optimum performance. This number can
range from 1 to 10. The performance tradeoff to consider is the "swapping"
overhead for many Servers versus overloading a server with too many clients.
This number 4 will be set later.

BACKGROUND WRITERS Section:

- Asynchronous Page Writer:
# APW's to Start = 2

We have found 2 to be the optimum number of APW's. Set this value to 2.

** See the FINE TUNING section at end of this document.

FORMAT: No Changes Required

ADVANCED:
- Spin Lock Retries =

The values used in this field can range from 1 to 10000. We recommend
setting
this value to at least 1. Typically for a single processor use 1000, for a
dual
processor use 2000.
If 3 or 4 processors are being used you can increase to 3000, 4000 or
higher,
however it is rarely necessary to increase this number above 2000 and can
sometimes cause problems. Therefore, we would recommend for 2 or more
processors use 2000.

Click [OK] and close the DefaultConfiguration Properties window.

=============================

STOP! --> QUESTION: Are you implementing ODBC connections at this time?
If YES, proceed to next step. If NO, jump to step # 7.

=============================

5. Right mouse click on the DefaultConfiguration, select NEW. Give the
new group the name: ODBCGroup. All one word, no spaces. Click OK.
This will open the new ODBCGroup screen properties.

6. At the top of the screen, for CLIENT TYPE: click on "SQL Only".
Next, fill in the remaining fields for the new ODBCGroup:

GENERAL Section:

- Service Name or Port Number:

This Service Port Number will be new and unique from the Epic50 and the
Epic50trn port number. Using port number 2550 should work fine. This
new Port Number is the number you will use when setting up the workstations
DSN.

- Number of Servers:

Number of Servers will equal item C on the first page. Again, this is the
total number users who will using ODBC.

CLIENTS Section:

- Maximum clients per server: Set this to 1

- Minimum clients per server: Set this to 1

Click [OK] and close the ODBCGroup properties window.

This completes the setup of the ODBCGroup for SQL Clients only.

7. Right mouse click on the DefaultServerGroup and select Properties.

8. At the top of the DefaultServerGroup - "Properties" screen, a
selection will need to made for the CLIENT TYPE:

- If you have just finished doing steps 5 and 6 for setup of the ODBC
clients, click on "4GL Only".

- If you are skipping directly to step 7 bypassing the ODBC setup,
then leave the "Both 4GL and SQL" option selected.

Next, fill in the remaining fields for each section listed below:

GENERAL Section:

- Service Name or Port Number:

The Service number that was added to this field at the time Vantage was
installed.
Do not change.

- Number of Servers:

This is the Number of Servers necessary to handle all of the 4GL client
connections to the database. This number is obtained by taking item B on
page 1 which was the total number of Vantage and Report Builder users
divided by 4.

If you have NOT implemented ODBC then this number will be the same as
Maximum Servers on the DefaultConfiguration screen.

- Message buffer size: (default is 1024)

The Message Buffer determines the size of the message buffers Progress uses
for
sending and receiving messages in client-server configurations. Using
TCP/IP, it
is much more efficient to send one 1,000 byte long message than it is to
send ten
100 byte long messages.

The default value of the message buffer size is 1024 bytes. If you wish to
improve
performance, increase this parameter to 4096. This will allow the server to
send
much more data per network message when it can. When there are less data
than a
full buffer, shorter messages will be transmitted.

If you are planning on changing this value, you will need to change it in
the client
parameter file (Vantage.pf) also.

First, change this value here to 4096

Second, modify the Client's startup parameter and value in your
C:\Epic50\Vantage\Db\Vantage.pf. Right mouse click the Vantage.pf file and
select EDIT. Change the -Mm 1024 to -Mm 4096.

Third, edit the C:\Epic50\Progress\Startup.pf file and add the -Mm 4096
parameter to the end of this file.

Please note that if you have a local installation of Vantage and Progress,
then the Vantage.pf will be locally on the machine. This file needs to be
edited as well, as in the case of a Gateway local installation. If in
question as to where the client is reading the Vantage.pf, it is easily
learned through viewing the parameter file .vtg that launches the session.
Find the vantage.vtg and right click Edit then the value of
'ParameterFile='.

CLIENTS Section:

- Maximum clients per server:

This is the value used to divide the total number of 4GL (Vantage and Report
Builder) users on page two of this document. If 4 was used as recommended,
enter number 4 here.

This parameter tells the system the maximum number of users per Server
broker.
By default, any users over 5 per server broker get to wait for other users
requests
to complete before it responds to the 6 user and so on.

- Minimum clients per server:

Set this number equal to the Maximum clients per server value. This
parameter tells Progress not to spawn another Server Broker until there are
at least a minimum number of users on the first broker.

Click [OK] and close the DefaultServerGroup properties window.

9. The database must now be Stopped and Re-Started for the new parameter
settings to take place. Again, we would recommend re-booting the server
after the database is stopped. This will clear all brokers in shared
memory.

===========================

FINE TUNING:

Using PROMON and to review parameters for necessary changes.

At the peak of the day when processing is at it best, start a
PROMON session against your 5.0 eManufacturing database on your server.

Select #5 "Activity" from the menu.

At the bottom of the Activity menu press "U" to allow an automatic 8 second
refresh of the Activity screen.

Take note of the BUFFER HITS percentage. This should be at least
90% or higher. If it is still at or below 90%, increase the "# of Block in
DB buffer" under the DefaultConfiguration --> Properties window by another
10000.

Also, on the "Activity" screen, note the "Writes by APW" value. If
this is at 100% all of the time, increase the "# APW's to start" value.
This parameter value is found under DefaultConfiguration --> Properties
window, Background Writers section. Do this ONLY if the Writes by APW is
pinned at 100%.

Finally, Stop and Restart the database if Progress Explorer Tool parameters
were changed. Again, monitor the Promon --> Activity screen to see if
additional changes are necessary.

Thanks, Jay Erickson
Vantage Technical Support Analyst
Epicor Software Corp.
jaerickson@...
SupportNet: http://www.epicor.com

--------------End of forwarded message -------------------------------

----- Original Message -----
From: sarah.vareschi@...
To: vantage@yahoogroups.com
Sent: Wednesday, November 07, 2001 10:22 AM
Subject: RE: [Vantage] 5.0 - ODBC?

I was just watching the performance monitor on the Vantage server while I
was running an ODBC report (which took a couple minutes to run) and it shot
to 100% and stayed there until the ODBC application was closed. Does
anybody know if this is normal, or if there is a way to reduce that?

[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]

Topic		Replies	Views
Crystal & odbc Yahoo Archive	6	763	September 19, 2002
Odbc Yahoo Archive	24	1324	October 13, 2003
Vantage 5.0 ODBC instructions Yahoo Archive	5	551	April 20, 2001
Crystal - ODBC Yahoo Archive	7	406	November 28, 2001
ODBC and 5.2 Yahoo Archive	7	449	November 18, 2002

5.0 - odbc?

Related topics