Kbase P135400: Cannot connect to Linux DB using a Windows client machine via ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/9/2009 |
|
Status: Unverified
SYMPTOM(s):
Cannot connect to Linux DB using a Windows client machine via ODBC
Windows ODBC connection to 9.1E DB on Linux returns "DB not started" error
SQLSRV2 returns error "error while loading shared lib.: libprosqlsnd.so: cannot open shared object file: no such file or directory"
FACT(s) (Environment):
ODBC connections to other Linux Servers can successfully be established
9.1E
Red Hat ES 4.0 Linux
CAUSE:
This is probably caused by the way in which the Linux machine is configured
FIX:
Make sure that the following are carried out or verified:
-- Execute the command "Set CLASSPTH=<disk> :<installationdirectory>/DLC/java/progress.jar"
-- Make sure that Java 1.3.1 is properly installed on the Linux machine.
-- Read the Java 1-3-1 installation notes before installing the JDK
-- Check that the path specified in your Shared Library (LD_LIBRARY_PATH) is pointing to the right place
-- Check that the users and processes accessing the DB have read access to all the folders mentioned abpve
-- Execute proenv.bat. In the console that appears, execute the command sqlexp -db <dbname> -S <portnumber> -H <host>