I try to connect to my SQL database to do some syncronisation
And I' block on this kind of message
Unable to resolve host name ???

I use Windows seven with SQL Express database
I build a .NET application and I want to syncro address book to my new
Nexus 7 with Jelly Bean android
I use my lan and I can go to web easy, but I can't connect to my SQL
database.

my ManifestAndroid.xml contain this lines

manifest xmlns:android="*http://schemas.android.com/apk/res/android"*<http://schemas.android.com/apk/res/android%22>
 package="com.example.com.andre.repartiteur2"
 android:versionCode="1"
 android:versionName="1.0" >
  <uses-sdk
 android:minSdkVersion="16"
 android:targetSdkVersion="15" />
  <uses-permission android:name="android.permission.INTERNET"/>
 <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE" />
  <application
 android:icon="@drawable/ic_launcher"
 android:label="@string/app_name"
 android:theme="@style/AppTheme" >
 <activity
 android:name=".MainActivity"
 android:label="@string/title_activity_main" >
 <intent-filter>
 <action android:name="android.intent.action.MAIN" />
  <category android:name="android.intent.category.LAUNCHER" />
 </intent-filter>
 </activity>
 <activity
 android:name=".OrderScreen"
 android:label="@string/title_activity_order_screen" >
 <meta-data
 android:name="android.support.PARENT_ACTIVITY"
 android:value="com.andre.repartiteur2.MainActivity" />
 </activity>
 </application>
</manifest>

Here is my code I used
and where is Yellow is where I catch the error

public class ClasseSQL {
 String Message = "<p>I'm into my sql class<p>";
 public String getMessage() {
 return this.Message;
 }
 public void setMessage(String value) {
 this.Message = this.Message + "<p>" + value;
 }
 public void dbConnect(String db_connect_string,
 String db_name,
 String db_userid,
 String db_password)
 {
  StrictMode.ThreadPolicy policy = new
StrictMode.ThreadPolicy.Builder().permitAll().build();
 StrictMode.setThreadPolicy(policy);
  Connection conn = null;
 String connectionUrl = null;
  try {
 this.setMessage("loading class jtds...");
  //2012-07-26 use jtds instead of jdbc
 //net.sourceforge.jtds.jdbc.Driver
 //com.microsoft.sqlserver.jdbc.SQLServerDriver
  Class.forName("net.sourceforge.jtds.jdbc.Driver");
  this.setMessage("class jtds loaded ...");
  connectionUrl = "jdbc:jtds:sqlserver://" + db_connect_string + ";" +
 "databaseName=" + db_name + ";user=REPAPP;password=REPAPP;";
  this.setMessage("Open my connection...<p>" + connectionUrl);
 // Establish the connection.
  conn = DriverManager.getConnection(connectionUrl);
 if (conn !=null) {
 Statement statement = conn.createStatement();
 String queryString = "select [UID_Region],[Description] from
[dbo].[Courtage] WHERE [NumeroAvantage] <>''";
 ResultSet rs = statement.executeQuery(queryString);
 while (rs.next()) {
 this.setMessage( rs.getString(1));
 }
 }
 }
 catch (SQLException se) {
 this.setMessage("SQLException : " + se.getMessage() + "<p>" +
se.getCause() + "<p>" + se.getStackTrace() + "<p>");
 }
 catch (ClassNotFoundException e) {
 this.setMessage("Class not found") ;
 }
 catch (Exception se) {
 this.setMessage("Exception error: " + se.toString() + "<p>" +
se.getCause() + "<p>" + se.getStackTrace() + "<p>");
 this.setMessage(connectionUrl);
 }
 }

Screenshot_2012-07-26-21-58-51.png 84K Download

Screenshot_2012-07-26.png 196K Download

Any OS except for Windows uses forward slashes '/' instead of backslashes
for separating path elements. Your screen shot shows something like

<IP ADDRESS>\<XYZ>

Which is probably interpreted as the domain name as a whole and therefore
cannot be resolved. Try using forward slashes instead.

The XYZ is the instance of the SQL server not a path
So IPADRESS/instance are not working
Any idea ?

Hum !!! .. my program working very well on other one SQL Server 2005
except if I tried to connect on my computer on Microsoft SQL Server Express
Edition with Advanced Services
This can be a problem with port lan or restriction on SQL Express
When I will found a way, I will post my solution, just in case !
Thanks

2012/7/27 Andre St-Onge <zaramu...@gmail.com>

And who need to know how the connection string work for SQLEXPRESS on the
Android

XXX.XXX.XXX.XXX:1434;instance=SQLEXPRESS;databaseName=WorkAdventures;user=* *****;password=******

Replace XXX.XXX.XXX.XXX by computer name or IP Adress and **** by the SQL
user information

and under AndroidManifest.xml

<

manifest xmlns:android=*http://schemas.android.com/apk/res/android*

package=*"com.example.com.andre.repartiteur"*

android:versionCode=*"1" *android:versionName=*"1.0"* >

<uses-sdk android:minSdkVersion=*"16"** *

android:targetSdkVersion=*"15"* />

<uses-permission android:name=*"android.permission.INTERNET"*/>

<uses-permission android:name=*"android.permission.ACCESS_NETWORK_STATE"* />

2012/7/27 Andre St-Onge <zaramu...@gmail.com>