ODBC using progress

  1. Create a secondary SQL broker: KB P7843 (http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=P7843)
  2. Set permissions for SQL user(s): KB 20143 and P21021
    (http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=20143 and http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=P21021)
  3. Run dbtool (9.1D06 and up) option 2: KB 24496 (http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=P24496)
  4. Run update statistics: KB 20992 (http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=20992)
  5. Configure DSN in windows
  6. Use this DSN to connect MS-access with progress database.
HTH,

casper.
 
The way I would normally do is
1. Have the ODBC driver installed on the machine you want to connect from
2. Make sure the progress database is running as a service (Either as 4GL or SQL broker)
3. Configure a DSN source using Progress ODBC driver to the configured database using the port/service and IP
4. Sometimes when you use the SQL broker you may have to have a SQL user configured.
5. When accessing tables be sure to use the PUB schema prefix.....
i.e. PUB.""mytable""

Hope this helps.
 
Hello,

Are you using the DataDirect, OpenLink, or another driver?

If you are using our driver, we can post very explicit directions on how to configure the actual DSN.
 
Hi Im new in this forum, may I ask a question?

I have here HP-UX with Progress Database - MFG/Pro System, my client as Win XP, is there any chance for me to use ODBC as linkage for me to use the Crystal Report?

I would like to use crystal report as my reporting for my MFG/Pro. :D:D
 
Follow the steps I descibed earlier and you should have no problems with it.
(set default isolation level of your odbc driver at "READ UNCOMMITTED" )

Casper.
 
Yes you can connect from a XP machine, but I do believe you need to have the ODBC drivers installed on your client machine, and then point to the database along with server and port where the database is hosted off. As for crystal reports I haven't used it but if crystal reports can connect to a DSN source then you should be able to do the same.
 
You must log in or register to reply here.
Back
Top