MSSQL2000 jdbc driver on UNIX ...

Hi experts,
I am new in java programming. I am wana to develop an application program
which can access MSSQL2000 under UNIX platform. I downloaded the jdbc
drivers for MSSQL2000 on Microsoft download center (Windows version & UNIX
version). I installed and set up on my machines,Windows 98 and
HPUX,respectively. And then, I do a sample code and try to accesss
MSSQL2000. It is works on Windows platform. But unfortunately, it does work
very well on my UNIX machine, and have an exception as
"com.microsoft.jdbc.sqlserver.SQLServerDriver".(co mplie pass). I have been
trying many times and can not get rid of this problem. Anyone can give me an
idea to solve it ? Thank you.
F.Y.I:
OS : HPUX10.20
JDK : 1.1.8
The configurlation in .cshrc :
...
set mypath = ( ... )
set hp93kpath = ( ... )
set javapath = ( ... )
set path = ($mypath $hp93kpath $javapath)
setenv classpath
install_dir/lib/msbase.jar:install_dir/lib/msutil.jar:install_dir/lib/mssqls
erver.jar
My sample code ..
import java.io.*;
import java.sql.*;
public class TestDB{
public static void main(String[] args){
try{
String mySQL = "select * from ABC";
Class.forname("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
Connection cn =
DrvierManager.getConnection("jdbc:microsoft:sqlser ver://server_name:1433:Dat
abaseName = AAA","guest","guest");
Statement st = cn.createStatement();
resultSet rs = st.executeQuery(mySQL);
:
:
}catch(Exception e){
}finally{
rs.close();
st.clsoe();
cn.close();
}
}
}
Possibly a classpath problem. Do you see the jar's when you do:
shall> set | grep CLASSPATH
Or you could set the jar-CLASSPATH temporarely when you compile and run with
the 'env' shell statement, or on the javac/java command line.
Lars-Inge Tnnessen
www.larsinge.com

ms-sql to sapdb

hi there,

we have a ms-sql server 7.0 and want to migrate to sapdb on unix.
are there any tools to convert a ms-sql to sapdb, including
stored procedures, keys and views?

tia

stefanHi

I have never heard of sapdb, but you should ask your supplier. Microsoft
provides many tools to port to SQL Server, and there are alot of other third
party tools that will also help, but they are obviously not going to provide
you with assistance if you wish to move to a rival vendor.

John

"stefan" <stefanluedecke@.gmx.de> wrote in message
news:ea0e4b2e.0308022043.73010886@.posting.google.c om...
> hi there,
> we have a ms-sql server 7.0 and want to migrate to sapdb on unix.
> are there any tools to convert a ms-sql to sapdb, including
> stored procedures, keys and views?
> tia
> stefan|||"John Bell" <jbellnewsposts@.hotmail.com> wrote in message news:<3f2cc1e9$0$15038$ed9e5944@.reading.news.pipex.net>...
> Hi
> I have never heard of sapdb, but you should ask your supplier. Microsoft
> provides many tools to port to SQL Server, and there are alot of other third
> party tools that will also help, but they are obviously not going to provide
> you with assistance if you wish to move to a rival vendor.
hi john,

sapdb (http://www.sapdb.org) is an open source db from sap.

with the export tool from ms-sql we are able to export the pure
data, but none of the things arround the db, such as stored procedures,
trigger etc.

with access (the db-frontend from microsoft) we could also transfer
data.

microsoft provide really a lot of tools to migrate to sql-server, but not the
other way ;-))

thank you

stefan|||Ray Higdon <rayhigdon@.higdonconsulting.com> wrote in message news:<3f2d13c1$0$195$75868355@.news.frii.net>...
> Are you talking about transferring data to an SAP database? If so, hehe,
> no simple answer exists. SAP uses business and function calls for all
> data entry, you input data by calling their functions, not going to the
> underlying data. One tool I have seen out there to help with this
> process is the Business Connector (read more here
> http://www.plurb.com/ebXML/Scalable...operability.pdf) it uses XML
> in and out and you can call it by a web service and run it as a Windows
> service. I have a buddy that wrote a paper on the BC, if this is what
> you are talking about I'll see if it is published yet and get you a copy
> if you want.
hi ray,

thank you for your help, but we can transfer data. the problem is
to transfer stored procedures, keys and trigger. and it would be a
few weeks work to do it manually.

stefan|||Hi

It is highly unlikely that your database will support T-SQL, and if it does
it is probably violating copyright. Therefore about all you can do is to
script them and maybe write a few macros to globally convert the syntax,
then it will be a manual task to finish it off.

John

"stefan" <stefanluedecke@.gmx.de> wrote in message
news:ea0e4b2e.0308031042.552d0eb0@.posting.google.c om...
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:<3f2cc1e9$0$15038$ed9e5944@.reading.news.pipex.net>...
> > Hi
> > I have never heard of sapdb, but you should ask your supplier. Microsoft
> > provides many tools to port to SQL Server, and there are alot of other
third
> > party tools that will also help, but they are obviously not going to
provide
> > you with assistance if you wish to move to a rival vendor.
> hi john,
> sapdb (http://www.sapdb.org) is an open source db from sap.
> with the export tool from ms-sql we are able to export the pure
> data, but none of the things arround the db, such as stored procedures,
> trigger etc.
> with access (the db-frontend from microsoft) we could also transfer
> data.
> microsoft provide really a lot of tools to migrate to sql-server, but not
the
> other way ;-))
> thank you
> stefan