V9.1E ODBC connection

[franktang]

Dear All,

I wanna to access progress database on UNIX from windows client, but I am not clear about this.

Someone told me just install a ODBC driver (Merant) on client is okay, Progress 9.1e has already include ODBC service. It's means I no need to configure or start the service on UNIX server. Is it right?

My environment is Progress 9.1E and QAD MFG/Pro EB2sp9, database server installed on UNIX, File server installed on Windows 2003.

Could you please list the detial progress step by step?

Thank you very much!


Best Regards,
Frank

 

[vdennis]

You will need to set up a SQL access within progress to do this. Check out the Knowledge Database on how to do this. Once the SQL has been set up access should be easy.

 

[franktang]

Thank you Dennies.

I used following command to start 4GL and SQL server, but when I try to test connection, system give me erorr message "-219901". I don't know whether my command has problem.

$DLC/bin/proserve $DLC/db/test/mfgtest -L 8000 -c 350 -B 1000 -S odbctest -N tcp -n 50 -Mn 15 -Mi 3 -Ma 5 -Mpb 4 -ServerType SQL

$DLC/bin/proserve $DLC/db/test/mfgtest -L 8000 -c 350 -B 1000 -S
mfgtest -N tcp -n 50 -m3 -Ma 4 -Mpb 10 -ServerType 4GL




Frank

 

[Tharanga herath]

ODBC Connection

hi buddy
Following steps can be used to make the ODBC connection to progress database.
1.) Connect to the Database using DBA tools and add new user
User Name : sysprogress
Password : sys
2.) Connect to the progress SQL Explorer using above user name and password
3.) Execute the Grant command

GRANT DBA TO (other user that u created in database and need to use ODBC connection) ;
COMMIT;


4.) Go to the Administrative tools in Windows and Make an ODBC connection using Progress9.1E ODBC driver.
5.) Test the connection

if you need more information refer the progress KB. or just drop me a mail

cheers
Tharanga

 

[Casper]

Are you sure you're classpath variable has been set properly on the database server?

As per KB P3363

Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
Caldera Open UNIX/SCO UnixWare
Compaq Tru64 UNIX
HP-UX
IBM AIX
Linux Intel

SYMPTOM(s):
Error attempting to connect to database via ODBC/SQL92
Startup of SQLSRV2 process in database log file shows no Classpath
being set.
SQLSRV2 1: CLASSPATH from DEFAULT is:

ODBC testconnect : [Merant SQL92 - ODBC Progress Driver [Progress]
-219901]
SQL92 internal error 219901

CAUSE:
The log file shows that there is no CLASSPATH environment variable set
for the SQLSRV2 process.

FIX:
1) Add CLASSPATH system environment variable pointing to
%DLC%\java\progress.zip.
Example: set CLASSPATH=D:\Progress9\java\progress.zip
Note: In Progress 9.1D, the progress.zip file has been renamed to
progress.jar
2) Restart AdminService. /* if you use it.... */
3) Restart the database.

HTH,

Casper.

 

[franktang]

Thanks for all.

I solved the problem. It's concerned with enveriments and start commands.

Thanks again.