ODBC Connection Error.

[Kalan]

Hi All,

I am using Openedge 10.1B, windows 7 OS. I am trying to create ODBC system DSN using C:\windows\syswow64\odbcad32.
I have defined the service name and port number for openedge adminserver at c:\windows\system32\drivers\etc\services file with the line
localhost 20931/etc. Also started the database sports in progress explorer. After this entered the below odbcad32 connection input values,

Hostname = localhost
PortNumber = 20931
Database Name = Sports
Username and password as blank <space>

But when I test the connection receiving the error message 'ODBC Progress Socket closed'. Could any one pls help me by providing the step by step guidelines to make the connection successful?

FYI: I have also confirmed that openedge adminserver is running.

Thanks in advance.

Alan.

 

[Rob Fitzpatrick]

20931 is the TCP port on which the Admin Server listens for connections. This is not the port you need.

When you configure a database to start, either via scripts or Admin Server, you specify which broker(s) you want to run and which service port(s) they will listen on. What you need when configuring your system DSN for this database is the port on which your database's SQL broker listens for connections. It is the value of the "-S" startup parameter for that database broker.

Look at the portion of your database log from when it was last started. The first line will look like "BROKER 0: (333) Multi-user session begin.". Depending on whether the SQL broker is your primary logon broker or a secondary broker, you should either see a (4262) message or a (5644) message indicating the service port number or service name of your SQL broker.

Examples (without the time stamp, etc.):

BROKER  0: (4262)  Service Name (-S): 6666.                                    <--- primary broker, port 6666 (4GL in this case)
BROKER  1: (5644)  Started for 6667 using TCP IPV4 address 0.0.0.0, pid 897.   <--- secondary broker, port 6667 (SQL)

Alternatively, you can look for the broker ports in promon. In R&D | Status, look at option 3 (Servers) or, depending on your 10.1B service pack, you may also have option 17 (Servers by Broker). Either will show you the port numbers currently being used by brokers and servers.