MSSQL2000 jdbc driver on UNIX --- (again)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: david (huangjuichung_at_seed.net.tw)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 22:16:52 +0800

Hi sir,

First of all, please accept my deep appreicate upon your helps. Thank you.
Yes, it was classpath problem. I revised my .profile and then it can work.
\^O^/
Although I solve this problem, but other problem occur ... Here, could you
please
give me an idea to solve it ?

My environment setting are showed as below:

In my .profile :

PATH = $PATH: /opt/java/bin
export PATH
CLASSPATH =
.:/opt/jdbc/msbase.jar:/opt/jdbc/msutil.jar:/opt/jdbc/mssqlserver.jar
export CLASSPATH

In my /etc/passwd :

david ... :/usr/bin/sh

I am going to show a simple form on UNIX, therefore, I do a sample code and
it works very well on windows platform.
But can not show anything on UNIX. I do some changes in my /etc/passwd file,
that is, I revised the shall setting from
"/usr/bin/sh" to "/sbin/sh". And then I relogin again. Strange ??? , it
works. But can not find java command. (I think that it
didn't run .profile while I relogin again. Also, can not access MSSQL2000).
So,I typed "/opt/java/bin/java sample" to
run it ---- success.

Is there any idea to set up this environment ?
(1) Can show a form.
(2) Can access the MSSQL2000.
(3) /usr/bin/sh is neccessary, but not /sbin/sh

Thanks for your attention and time.
I expect to have an idea from you.

Best regards,

David Huang

Relevant Pages

  • RE: CLASSPATH in .profile not used.
    ... Ensure your HOME directory setting within your OMVS Segment is the same ... CLASSPATH in .profile not used. ... what environment variables have been set by your .profile. ... I have defined the CLASSPATH variable in my .profile file. ...
    (bit.listserv.ibm-main)
  • Re: MSSQL2000 jdbc driver on UNIX --- (again)
    ... CLASSPATH in .profile. ... David Huang ... $SHELL ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: Anyone use variables to shorten classpath declaration?
    ... one profile sourced another, but the variable it uses as a shortcut ... isn't defined at the time the CLASSPATH is defined, however, if I ... Nigel Wade, System Administrator, Space Plasma Physics Group, ... University of Leicester, Leicester, LE1 7RH, UK ...
    (comp.lang.java.help)
  • Anyone use variables to shorten classpath declaration?
    ... Anyone use variables to shorten classpath declaration? ... where an application failed to find some jar files, ... one profile sourced another, but the variable it uses as a shortcut ...
    (comp.lang.java.help)
  • Re: [meta] -- Dont you guys know about these other groups?
    ... contributing to this group, lest the unthinkable were to happen, that ... correctly with your browser or in some cases the "advanced" button does ... the Confirmation Number in the upper righthand corner of your Profile. ... mine runs perfectly when i ssh from nt to unix, ...
    (rec.gambling.poker)