R
Roberta Miller
Guest
Welcome to Progress, Zev! You are correct, you found the right driver, and you can pick anything you want for the Data Source Name. To use SQL with an OpenEdge through ODBC or JDBC, a database broker must be started for network (TCP) connections. The person or script that started the database specified a host name with the -H startup parameter, and a port to connect through with the -S startup parameter. Use these values for "Host Name" and "Port Number". SQL users must also have a user IDand password stored in the database _User table in order to connect. You can enter the user ID in the "User ID" field if you want the DSN to be just for one user, or you can leave it blank and supply it at run time. You will always have to supply the password at run time. Your database administrator (whoever starts the database) will know the host name, port number, user ID and password that you should use. If you want to read more, please see OpenEdge Data Management: SQL Development, Chapter 3, "ODBC Client Configuring data sources Configuring Windows clients" in the OpenEdge documentation. The OE 10.2B documentation set is available on line at community.progress.com/.../1164.openedge-10-2b-product-documentation.aspx .
Continue reading...
Continue reading...