MSSQServer 2000 for pocket pc

Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");

Ok?

Which are the driver that i needed?

Thanx,

SimonaOriginally posted by simona
Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");

Ok?

Which are the driver that i needed?

Thanx,

Simona

Sorry but i'cant help you.

But i'm interrested for your java application.

which is the JVM which you use ?
Could you give me a java for ppc sample code 'HELLO WORLD!' ?

thank you,

Guiguix.|||Hi,
yhe java code is traditionally.

You write a "Hello world" java code and you copy it in the pocket pc.
The jvm is Creme. It support swing! But the needed java version is very old. I use the java 1.1.8 ;(

Bye :)|||There are two steps to establish a connection:

(1) loading the driver
If you want to use the JDBC-ODBC Bridge driver, the following code will load it.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

(2) making the connection
If you are using the JDBC-ODBC Bridge driver, you can use

String url = "jdbc: odbc:ODBC_DataSourceName";
Connection con = DriverManager.getConnection(url, "myLogin", "myPassword");

Note that there is no space between jdbc: and odbc in url. If I remove it a sign will be shown in the code.|||And is this ok for pocket pc?
Wow!|||When you say "pocket PC", it is a laptop, right? I didn't try the connection on SQL Server 2000 Windows CE Edition, but it works for the other versions of SQL Server 2000.|||Pocket pc is a palm. Not Palm OS, but pocket pc.
MSSqlServer 2000 works on pc desktop but not on pocket pc.
Moreover the strings

----------------------
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String url = "jdbc: odbc://localhost:1433;databasename=AeMMobile";

connessione = DriverManager.getConnection(url, "sa", "sa");
-----------------------

don't work.

While with

----------------------

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=AeMMobile", "sa", "sa");

--------------------

on pc desktop is ok.
My problem is on pocket pc?
Do you know the solution?|||I do not know what the pocket PC is. I have a question. Since the SQL server is on the desktop which should be a Windows server, is your pocket PC connected to that server?|||The pocket pc is an hp 2002.
If you means that pocket pc is connected with replication data... yes.

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