views:

391

answers:

0

Here at work we want to access the data inside a .sdf file generated in a PDA with SQLServer Mobile Edition. We use the SqlJDBC4 packet for JDBC but can't get into the server. We know it's running because we can telnet into it, but from the Java code we just get once and again that we can't connect to server.

We use this connection String:

String connectionUrl="jdbc:sqlserver://localhost;databaseName=d:\\file.sdf;"+
   "SelectMethod=cursor;Password=test;integratedSecurity=true";

Any fellow stackoverflower can tell us the right connection string or whatever we are doing wrong?