Hello,
1. I have Progress OpenEdge 10.1B odbc driver installed on Windows 2003 server. Now i want to make connection to both 10.1B database and 10.2B database.
a) 10.1B database connection is working fine and I am able to query tables.
b) Connection to 10.2B failed, getting Broker Rejects Connection error message, when i checked in knowledgebase i got http://knowledgebase.progress.com/articles/Article/BrokerRejectsConnectionwhenconnectingviaODBCDatasourceDSN.
But my support team suggest to upgrade ODBC driver version to 10.2B for fixing the error.
2) I tried creating ODBC connection using DataDirect 4.20 32-Bit OpenEdge SQL v10.0B driver.
a) 10.1B database connection is working fine and I am able to query tables.
b) Connection to 10.2B failed, getting Exceeding permissible number of connections.
3) Support team advised me that cannot use the 10.2B odbc driver to connect to a 10.1B database, They suggested me to use two machines one for 10.1B database connection with 10.1B odbc driver and one for 10.2B database connection with 10.2B odbc driver. Is this statement correct?
4. Please advise on licencing details for 10.1B odbc driver and 10.2b odbc driver.
a) ODBC drivers are free to use since we already have 10.1B & 10.2B databases?
b) If it is cost, please provide details on those as well.
Steps 1 & 2 gives different error message for same database connection.
Could you please suggest solution for the above issues, I need to make connection to both 10.1B and 10.2B database.
Regards,
Venkateswaran
This is a duplicate of your other thread...From the KB I linked
"Yes, an OpenEdge 10.2x (32- or 64-bit) ODBC driver will connect to an OpenEdge 10.1x (32- or 64-bit) database."
Who exactly is telling you that 10.2B ODBC cannot connect to 10.1B?
Thank you.
Is Broker Rejects Connection error message due to ODBC driver version? Please advice.
Can you do this ?
On the DB server
in 10.1B
proenv
prodb xx sports
proserve xx -S 8880
in 10.2B
proenv
prodb yy sports
proserve yy -S 8881
assuming 8880 and 8881 are free
then go to your "ODBC" machine and set up DSN to both using 10.2B ODBC driver and do a test connect to both.
Does that work ?
I think we have a slight language barrier and some confusion here....
The 10.2B driver can connect to 10.2 and 10.1 databases. The 10.1B driver cannot connect to 10.2B.
First step is to install the 10.2B driver and set up a connection to the 10.1B database and make sure it works.
Then you need to make sure that your 10.2B database is set up to accept connections and make sure you use the proper host name and port number when connecting. You also need to make sure your -n startup parameter is set properly to allow the proper number of users.