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:sqlser ver://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.SQLSer verDriver");

connessione = DriverManager.getConnection("jdbc:microsoft:sqlser ver://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.