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/