[HELP] ODBC connection OpenEdge 10.0B-Borland Delphi 5(Server not respond)

[sevendp]

hi, i'm new here
please help

i want to set ODBC connection from Openedge 10.0B on Linux Redhat (15.59.254.91) to Borland Delphi 5 on Windows XP Pro.


database startup script:
/dlc/bin/_mprosrv /database/master/master -H localhost.localdomain -Mn 3 -Mpb 4 -N TCP -Mi 1 -Ma 5 -S 30071 -n 25 -cpinternal ibm850 -cpcoll basic -L 1024000 -c 250 -B 13500 -d dmy -yy 1980 -numsep 44 -numdec 46 -rereadnolock
/dlc/bin/_mprosrv /database/master/master -H localhost.localdomain -m3 -Mpb 2 -Ma 5 -Mi 1 -N TCP -S 30079 -n 25 -cpinternal ibm850 -cpcoll basic -L 1024000 -c 250 -B 13500 -d dmy -yy 1980 -numsep 44 -numdec 46 -rereadnolock

[root@localhost ~]# upmaster
09:35:05 BROKER 0: Multi-user session begin. (333)
09:35:05 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
09:35:05 BROKER 0: Physical Redo Phase Completed at blk 0 off 1473 upd 0. (7161)
09:35:05 BROKER 0: Started for 30071 using TCP, pid 7400. (5644)
09:35:05 BROKER 1: Started for 30079 using TCP, pid 7402. (5644)
09:35:05 BROKER 1: This is an additional broker for this protocol. (5645)
09:35:05 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)

[root@localhost ~]# $DLC/bin/slib_env
[root@localhost ~]#
[root@localhost ~]# $DLC/bin/java_env
[root@localhost ~]#
[root@localhost ~]# ldd $DLC/bin/_sqlsrv2
libprosqlsnd.so => /dlc/lib/libprosqlsnd.so (0x002fa000)
libprosqlrds.so => /dlc/lib/libprosqlrds.so (0x00998000)
libprosqlsnw.so => /dlc/lib/libprosqlsnw.so (0x00fde000)
libprosqlgeneric.so => /dlc/lib/libprosqlgeneric.so (0x00111000)
libprosqldb.so => /dlc/lib/libprosqldb.so (0x0041d000)
libprosqlmm.so => /dlc/lib/libprosqlmm.so (0x001cb000)
libpronls.so => /dlc/lib/libpronls.so (0x0079e000)
libprosqlss.so => /dlc/lib/libprosqlss.so (0x0037e000)
libprosqljava.so => /dlc/lib/libprosqljava.so (0x00276000)
libprosqlos.so => /dlc/lib/libprosqlos.so (0x00402000)
librocket_r.so => /dlc/lib/librocket_r.so (0x005ac000)
libusort.so => /dlc/lib/libusort.so (0x001fb000)
libjvm.so => /opt/jdk1.3.1_12/jre/lib/i386/classic/libjvm.so (0x00479000)
libhpi.so => /opt/jdk1.3.1_12/jre/lib/i386/native_threads/libhpi.so (0x00e35000)
libnsl.so.1 => /lib/libnsl.so.1 (0x001fe000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x00214000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00226000)
libdl.so.2 => /lib/libdl.so.2 (0x0068d000)
libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3 (0x006c6000)
libm.so.6 => /lib/tls/libm.so.6 (0x00693000)
libc.so.6 => /lib/tls/libc.so.6 (0x007ac000)
/lib/ld-linux.so.2 (0x00549000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00255000)

i already do this : stop firestarter service, create _user : SYSPROGRESS with blank password

i think all path are ok, but when i try to connect from ODBC win XP using Data Direct 4.20 32-BIT OpenEdge SQL v10.0B

Data Source Name : testing
Host Name : 15.59.254.91
Port Number : 30079
Database Name : master.db
User ID : SYSPROGRESS

i got error : Server not Respond

when i try on Linux:

[root@localhost ~]# sqlexp -char -H localhost -S 30079 -db master -user sysprogress
PROGRESS Version 9.1E as of Tue Oct 12 14:40:19 EDT 2004
Connecting user "sysprogress" to URL "jdbc:jdbcprogress:T:localhost:30079:master"... (8920)
Error: No suitable driver. (8933)
See "/root/sqlexp.log" and "/root/SQLExplorer.exceptions" files for more information. (8950)


================
/root/sqlexp.log
================
[1/8/10 8:43:31 AM]
[1/8/10 8:43:31 AM]=== Start logging. Local time: 1/8/10 8:43:31 AM. ===
[1/8/10 8:43:31 AM]
[1/8/10 8:43:31 AM] [3] [SQLExplorer] Default properties will be used. (SQLMsg037)
[1/8/10 8:43:31 AM] [3] [SQLExplorer] Setting Connect to jdbc:jdbcprogress:T:localhost:30079:master
[1/8/10 8:43:31 AM] [3] [SQLExplorer] === SQLExplorer starting. ===
[1/8/10 8:43:31 AM] [3] [SQLExplorer] ### ARGS: -char -H localhost -S 30079 -db master -user sysprogress
[1/8/10 8:43:31 AM] [3] [SQLExplorer] Connecting user "sysprogress" to URL "jdbc:jdbcprogress:T:localhost:30079:master"... (8920)
[1/8/10 8:43:31 AM] [3] [SQLExplorer] Loading JDBC driver com.progress.sql.jdbc.JdbcProgressDriver.
[1/8/10 8:43:31 AM] [0] [*UnexpectedError*] * recorded as exception #1 in file /root/SQLExplorer.exceptions.
[1/8/10 8:43:31 AM] [3] [SQLExplorer] === SQLExplorer ending. ===


============================
/root/SQLExplorer.exceptions
============================
====== Start exception logging == "/root/SQLExplorer.exceptions" opened == Fri Jan 08 08:43:31 JAVT 2010 ======


**** 1 ****

Exception at Fri Jan 08 08:43:31 JAVT 2010: java.sql.SQLException
Message (throw): ### Connect stack trace. ###
Message (excp): No suitable driver
Stack Trace:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at com.progress.sql.explorer.SQLConnectServer.call(SQLConnectServer.java:37)
at com.progress.common.rmiregistry.TryIt.run(TryIt.java:186)


whats wrong with my setting? please advice

thanks a lot
Denny

 

[Casper]

I am not sure what is happening but there are few things which seems strange to me:

1. If you want to have SQL connection to progress database then it is better to configure a dedicated 4GL and SQL broker.
2. You say you are using 10.0B but the sqlexplorer you are starting is Progress 9.1E so it seems like you are mixing up progress versions.
3. You forgot to tell us the version of RedHat you are using.

Regarding point 2: If you're database /is/ OE 10.0B and the version of Progress for sql explorter you are using is 9.1E then it might be that you got a conflict in environment. I am not sure if a 9.1E driver can connect to a 10.0B database. It might or it might not.

Casper.

 

[sevendp]

thanks Casper,

yes, there are enviroment conflict there ...
so i try that on new server with RH4, OpenEdge 10.B, and now i can make successful connection to Delphi 5 ODBC
thanks

i try to browse data in a dbgrid,
the problem is Delphi 5 table (TTable) can not recognize my 1st index.
i have 1 table with 2 index, the second index is ok, the 1st index got "error in row" it said index not opened yet


any advice or link ?
thanks a lot
dp

 

[tamhas]

You might try telling us something about the problem index and you might try experimenting with other tables to see if there is a pattern.

 

[sevendp]

hi ...
sorry for long reply....
now i can connect & update succesfull... i recreate the database (prostrct)
problem solved ...

thanks a lot for your help

case closed
:lol: