SQL Eplorer Tool

system · February 22, 2008, 12:52pm

I have error :

Exception in thread "main" java.lang.NoClassDefFoundEror: com/progress/sql/explorer/SQLExplorer

???

----- Original Message ----
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Friday, February 22, 2008 9:05:51 AM
Subject: RE: [Vantage] SQL Eplorer Tool.

> Is anybody know what's happend with SQL Explorer Tool in OpenEdge 10.1 ?
> What is the best tool to use instead of SQL ET ?

About a month ago, Kersten MacLennan posted a potential solution that uses
Java:

http://www.squirrel sql.org

The 8.03.400 ODBC kit has a command file that allows one to send a SQL
commands to Progress. The contents of the batch file look like:

set dlc=c:\epicor\ oe101b
call c:\epicor\oe101b\ bin\sqlexp mfgsys -H localhost -S 5555 -user sysprogress
-password sysprogress
-infile C:\epicor\odbctable List.txt -outfile C:\epicor\odbcresul t.txt
-sqlverbose

(the -infile line is a newline) The infile parameter is the name of the file
that holds your SQL statements and the outfile captures the output from the
command. The sqlexp command/batch file that calls also calls Java.

Mark W.

____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping

[Non-text portions of this message have been removed]

system · February 22, 2008, 9:28am

Hello,

Is anybody know what's happend with SQL Explorer Tool in OpenEdge 10.1 ?
What is the best tool to use instead of SQL ET ?

Thank you.

____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

[Non-text portions of this message have been removed]

system · February 22, 2008, 10:11am

> Is anybody know what's happend with SQL Explorer Tool in OpenEdge 10.1 ?
> What is the best tool to use instead of SQL ET ?

About a month ago, Kersten MacLennan posted a potential solution that uses
Java:

http://www.squirrelsql.org

The 8.03.400 ODBC kit has a command file that allows one to send a SQL
commands to Progress. The contents of the batch file look like:

set dlc=c:\epicor\oe101b
call c:\epicor\oe101b\bin\sqlexp mfgsys -H localhost -S 5555 -user sysprogress
-password sysprogress
-infile C:\epicor\odbctableList.txt -outfile C:\epicor\odbcresult.txt
-sqlverbose

(the -infile line is a newline) The infile parameter is the name of the file
that holds your SQL statements and the outfile captures the output from the
command. The sqlexp command/batch file that calls also calls Java.

Mark W.