Using ODBC with Progress 83E

[mattwilkinson]

I am trying to set up a connection to out MFG database using an ODBC connector from Openlink.

At the moment I can't even connect to the database and I think the problem is to do with the port that I need to connect on. Does anyone know what the default port number is for this version of progress? or how to find it?

Thanks

 

[Kishor Chari]

There is no default port, it is the DB port nbr.

Can you upgrade your PROGRESS to 91E, datadirect is free with it and I have used it very .

Now on openlink you MUST ensure its compatible wit 8.3 esp for "c" as well.

Good Luck.

 

[mattwilkinson]

There is no default port, it is the DB port nbr.

Can you upgrade your PROGRESS to 91E, datadirect is free with it and I have used it very .

Now on openlink you MUST ensure its compatible wit 8.3 esp for "c" as well.

Good Luck.

The openlink driver has a drop down for 83C so I think I have the correct version but can't seem to connect

'Error: Unable to locate the requested server. Please use either <host>:<port> in the Server field, or choose a Zero Config server from the drop down list.'

So I thought I would need the port number.

What is datadirect? I am not a progress person but a .NET developer so this is a new area to me

 

[Kishor Chari]

Datadirect is another ODBC driver shipped with PROGRESS.

Are you trying to connect from .NET?

Were you able to connect from windows? ODBC option?

You are in the right version.

Is the DB started in Multi user mode?

You need to setup user/pass in PROGRESS sysprogress / sysprogress
and use it in your connection parameter ( To be done by MFG administrator)

 

[mattwilkinson]

Yes I am trying to connect using .NET but I am attempting to setup a System DSN first (once this is done connecting via .NET code should be easy)

The pages of the DSN Setup aer as follows:

Page 1
Name: progress
Descriptionrogress
Server:<our server name>

Page 2
Domainrogress 83E
Database:mfg
DB Connection options:<blank>
Secure connection:<not ticked>
LoginID:<my mfg username>
Password:<my mfg password>

If I try and connect at this point by ticking the 'connect now to verify that all settings are correct' then I get the error message as posted above

 

[Kishor Chari]

Page 1
Name: progress
Descriptionrogress
Server:<our server name>

Page 2
Domainrogress 83E
Database:mfg
DB Connection options:-S portnumber -H servername -N TCP
Secure connection: try both ticiked & un ticked
LoginID:sysprogress
Password:sysprogress


The login & pass issss to becreated on progres db. start mfgpro test, go to progress editor, tools -> data administration->admin->security->edit user list.

You will connect to the DB.

 

[mattwilkinson]

Thanks for the information however it doesn't seem to matter what I put in the options section because I still get this same message:

Unable to locate the requested server. Please use either <host>:<port> in the Server field, or choose a Zero Config server from the drop down list.

Which leads me back to the original question which is what port to use?

 

[Kishor Chari]

Ok lets start from top

A) Is the DB running in Multi User
B) Was it started with -S, -H parameters

Send me a copy of .pf file I shall be able to you.

 

[sanjus]

You also have to add the -S services list to the services file on ODBC clients in order to access it (in case of Windows client).

 

[mattwilkinson]

Ok lets start from top

A) Is the DB running in Multi User
B) Was it started with -S, -H parameters

Send me a copy of .pf file I shall be able to you.

I have been informed by the MFG/Pro admin that it was started in multi user mode: here is the contents of the live.pf file

-db mfg -ld qaddb -H merpla07as -S mfglive -N TCP -trig TRIGGERS
-db sbidb -ld sbiempty -H merpla07as -S sbilive -N TCP
-db mfghelp -ld qadhelp -H merpla07as -S mfghelp -N TCP
-db gui -ld qadgui -H merpla07as -S guilive -N TCP
-db cfg -ld qadcf -H merpla07as -S cfglive -N TCP
-q -d dmy -yy 1920 -Bt 350 -c 30 -D 100 -mmax 8192 -nb 200 -s 63 -p mf.p -pf mfglang.pf

 

[Kishor Chari]

OK you need to mention it as parameter.
Can you start a client MFG/PRO session? if NO. Then first fix that. This will ensure services, host file is in order.

If your still stuck skype me on kishorchari

 

[mattwilkinson]

OK you need to mention it as parameter.
Can you start a client MFG/PRO session? if NO. Then first fix that. This will ensure services, host file is in order.

If your still stuck skype me on kishorchari

Yes I can run an MFG/Pro client session with no problem so that side of things is working fine

 

[Kishor Chari]

Quite Intriguing

Final straw..
a) instead of mentioning the service name , mention the port number. it is found in the services file.
b) Instead of _mprosrv start the DB using proserve
c)Have you created user name & password on the progress DB.

Send me the snap shot of the set up. If you want I can dial in & fix it..Mail me.