ODBC Connection

[easycode]

Hello everyone

I am new to progress and i am trying to stablish a connection to Progress using VB 6.0, I have tried many thing nothing works.

Right now what i am doing is try to use the ODBC Data Source Administrator, in the System DSN tab, i clicked Add and selected the DATADIRECT 1.10 32-BIT Progress SQL92 v9.1E and then click in Finish , this prompt a dialog box and i entered the next info
Data Source Name: myconnection
Description:
HostName : mbXYZ
Port Number: 4125
Database Name: ABC
User ID: frav
and i am getting a warning message:
[DataDirect][ODBC PROGRESS driver]Invalid attribute in connection string: Description.[DataDirect][ODBC PROGRESS driver][PROGRESS]Exceeding permissible number of connections

I have tried many combinations and it doesn't make a difference, and i havo not yet done anything with VB, so far this is a test only to the database to see it can connect. this is very frustrating, I would really appreciate some advise.

Thank you

 

[easycode]

i forgot to mention that i am working in a Windows XP Pro platform and i have Progress v 9.1E

 

[easycode]

i found out the next as explained later:

To resolve this problem, create a secondary login broker specifically for the server that hosts the Data Replication Engine. NOW the problem is how can i create a secondary login broker, i don't even know what a broker is?

-----------------------------------------------------------
I found this in a knowledge database
Status: Unverified

FACT(s) (Environment):

PDRE
Progress RDBMS

SYMPTOM(s):

E ODBC Connection failure: -1 from function Connect

E [DataDirect][ODBC PROGRESS driver][PROGRESS]Exceeding permissible
number of connections

E Unable to connect to '<DataSourceName>'

Replication fails

CAUSE:

This problem occurs if the Replication Engine Server does not have its
own dedicated server to connect to the Progress database.


FIX:

To resolve this problem, create a secondary login broker specifically
for the server that hosts the Data Replication Engine.