Hi, I want to see my 9.1D database structure in Architect 10.1C, but is just the view via sql driver... what i need to do?
Thanks.
You can't use 10.1C OEA to connect to 9.1D with the 10.1C SQL drivers. You will need to manually setup the 9.1D drivers with DB nav for this to work.
Go into Preferences -> DB Navigator -> JDBC Drivers.
Click the Add button.
Name the driver, e.g.: Progress 9.1D JDBC Driver
Set up the Example URL to be this:
jdbc:JdbcProgress:T:hostname:port:databasename
Go to the "Extra Class Path" tab.
Add \java\jdbc.jar
Click List Drivers (should get com.progress.sql.jdbc.JdbcProgressDriver)
From \bin\ copy JdbcProgress.dll, procli92.dll and pronls.dll to somewhere which lies in your %PATH%, e.g. your working directory or C:\Windows.
Once you have added the Driver, you should be able to create a Database entry using that JDBC Driver.
Before anything, thanks for your answer..
With this I have solve the first part of the problem.. I have a question.. when I setup the new connection, using the new driver, I need to replace the port string with the port number, as the hostname , as the database name.. that is correct?
do I need to change "T" for anything?
my url string look like this:
jdbc:JdbcProgress:T:192.168.2.168:2070:ache
and when test connection, I got a error message:
Connection Failed.
Unable to create connection. Check your URL.