Progress ODBC connection..

B

balaji.n

New Member
Hello,

I'm trying to access Progress db from my local machine ( w2k)
It is on unix system ( sun solaris with 9.1D) and I've progress 9.1D on my local windows machine too. I'm trying to connect through ODBC connection and getting some issues here..
On unix side, OID and OIB are running using the port 2501 (tcp) and same setup in done on my services file in windows..I'm using MERANT 3.6 32-bit progress SQL92 v9.1D driver.. In the System DSN connection configuration, I provided datasource name ,hostname and port ( 2051) and try to test the connection.. Do I need to do any more setup on my windows PC ?
It does not give any error message..it just hangs ( for ever) - no response..
Since there are no error message , I guess it tried to establish connection but no response from server or something.. I tried accessing this from ACCESS or Excel ( of course, it did not work- just hangs )

Any ideas ...
 
Dear Balaji,
The setups to be made in progressdb, Create db level userid and password to access to connect to Progress DB through ODBC.The port no to be defined in unix for database u are accessing.The database need to be started with -S parameter using this port no.Then do the setting in windows like server ip, port no; the database name is optional because progress connects through port no rather than db name.enter user id and password(database level).
try this u will b able to connect now.But to download tables grants to be given for each table through sql explorer provided with windows Progress using sysprogress user id.

With Regards,

Raveendra.S
 
Hi Raveendra,

We made some progress here and I was using wrong broker/driver ..
I was using sql89 setup while connecting with sql92 driver.. I resolved those things..Now, I'm having some issues while starting _sqlsrv2 using the command "sqlexp db mynewd -S port-no" ...it throws me a null message
Connecting user "movers" to URL "jdbc:jdbcprogress:T:localhost:6543:mynewd"... (8920)
null

What are the various setups required on server side ?

Thanks a lot...
 
Hi Balaji,

Find below the extrct from ProgressKB.I think this may resolve your problem to some extent.



FACT(s) (Environment):
Progress 9.1D

FACT(s) (Environment):

UNIX

SYMPTOM(s):

Connecting user "sysprogress" to URL

"jdbc:jdbcprogress:T:localhost:2090:intime" ... (8920)

null

Unable to establish connection via sqlexp

Null message when connecting via sqlexp to a database

CAUSE:

Database has been started using exec $DLC/bin/_mprosrv "$@" which

causes not all necessary parameters have been passed onto database

broker

FIX:

Modify your script to call proserve, eg exec $DLC/bin/proserve "$@" in

this case.



 
ODBC issues

Make sure you have the entries in \winnt\system32\drivers\etc:-

services - add the same port/services as defined on Unix
hosts - IP and hostname defined as on unix
 
You must log in or register to reply here.
Back
Top