barnameye_man
پنج شنبه 07 آذر 1392, 18:06 عصر
دوستان من کد زیر برای وصل شدن به sql server استفاده کردم ولی با errore زیر مواجه شدم لطفا راهنمایی بکنید
the driver could not establish a secure connection to sql server by using secure sockets layers ssl encryption error ulable to make socket non blocking
public void ConSql()
{
try
{
int port=1433;
Socket s;
Toast.makeText(this , " ConSql 1 " , Toast.LENGTH_LONG).show();
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
Class.forName(driver).newInstance();
Toast.makeText(this , " ConSql 2 " , Toast.LENGTH_LONG).show();
Connection conn =DriverManager.getConnection("jdbc:sqlserver://127.63.95.161 :1433 ; databaseName=myDBName ;user=UserDB ;password=PassDB ; ");
Toast.makeText(this , " ConSql 3 " , Toast.LENGTH_LONG).show();
System.out.println("connected");
Statement statement=conn.createStatement();
ResultSet resultSet=statement.executeQuery("select * from userinfo ");
Toast.makeText(this , " resultSet = " , Toast.LENGTH_LONG).show();
while(resultSet.next())
{
System.out.println(" "+resultSet.getString(1)+" "+resultSet.getString(2));
Toast.makeText(this , resultSet.getString(1)+" , "+resultSet.getString(2) , Toast.LENGTH_LONG).show();
}
} catch (Exception e) {
Toast.makeText(this , " Erore == "+ e.getMessage().toString() , Toast.LENGTH_LONG).show();
TextView1.setText( e.getMessage().toString());
e.printStackTrace();
}
}
دوستان من کد زیر برای وصل شدن به sql server استفاده کردم ولی با
public void ConSql()
{
try
{
int port=1433;
Socket s;
Toast.makeText(this , " ConSql 1 " , Toast.LENGTH_LONG).show();
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
Class.forName(driver).newInstance();
Toast.makeText(this , " ConSql 2 " , Toast.LENGTH_LONG).show();
Connection conn =DriverManager.getConnection("jdbc:sqlserver://192.168.0.161 :1433 ; databaseName=myDBName ;user=UserDB ;password=PassDB ; ");
Toast.makeText(this , " ConSql 3 " , Toast.LENGTH_LONG).show();
System.out.println("connected");
Statement statement=conn.createStatement();
ResultSet resultSet=statement.executeQuery("select * from userinfo ");
Toast.makeText(this , " resultSet = " , Toast.LENGTH_LONG).show();
while(resultSet.next())
{
System.out.println(" "+resultSet.getString(1)+" "+resultSet.getString(2));
Toast.makeText(this , resultSet.getString(1)+" , "+resultSet.getString(2) , Toast.LENGTH_LONG).show();
}
} catch (Exception e) {
Toast.makeText(this , " Erore == "+ e.getMessage().toString() , Toast.LENGTH_LONG).show();
TextView1.setText( e.getMessage().toString());
e.printStackTrace();
}
}
ولی error یی که با نوشتم برام میده نمدونم مشکل کجاست لطفا کمکم کنید
the driver could not establish a secure connection to sql server by using secure sockets layers ssl encryption error ulable to make socket non blocking
public void ConSql()
{
try
{
int port=1433;
Socket s;
Toast.makeText(this , " ConSql 1 " , Toast.LENGTH_LONG).show();
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
Class.forName(driver).newInstance();
Toast.makeText(this , " ConSql 2 " , Toast.LENGTH_LONG).show();
Connection conn =DriverManager.getConnection("jdbc:sqlserver://127.63.95.161 :1433 ; databaseName=myDBName ;user=UserDB ;password=PassDB ; ");
Toast.makeText(this , " ConSql 3 " , Toast.LENGTH_LONG).show();
System.out.println("connected");
Statement statement=conn.createStatement();
ResultSet resultSet=statement.executeQuery("select * from userinfo ");
Toast.makeText(this , " resultSet = " , Toast.LENGTH_LONG).show();
while(resultSet.next())
{
System.out.println(" "+resultSet.getString(1)+" "+resultSet.getString(2));
Toast.makeText(this , resultSet.getString(1)+" , "+resultSet.getString(2) , Toast.LENGTH_LONG).show();
}
} catch (Exception e) {
Toast.makeText(this , " Erore == "+ e.getMessage().toString() , Toast.LENGTH_LONG).show();
TextView1.setText( e.getMessage().toString());
e.printStackTrace();
}
}
دوستان من کد زیر برای وصل شدن به sql server استفاده کردم ولی با
public void ConSql()
{
try
{
int port=1433;
Socket s;
Toast.makeText(this , " ConSql 1 " , Toast.LENGTH_LONG).show();
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
Class.forName(driver).newInstance();
Toast.makeText(this , " ConSql 2 " , Toast.LENGTH_LONG).show();
Connection conn =DriverManager.getConnection("jdbc:sqlserver://192.168.0.161 :1433 ; databaseName=myDBName ;user=UserDB ;password=PassDB ; ");
Toast.makeText(this , " ConSql 3 " , Toast.LENGTH_LONG).show();
System.out.println("connected");
Statement statement=conn.createStatement();
ResultSet resultSet=statement.executeQuery("select * from userinfo ");
Toast.makeText(this , " resultSet = " , Toast.LENGTH_LONG).show();
while(resultSet.next())
{
System.out.println(" "+resultSet.getString(1)+" "+resultSet.getString(2));
Toast.makeText(this , resultSet.getString(1)+" , "+resultSet.getString(2) , Toast.LENGTH_LONG).show();
}
} catch (Exception e) {
Toast.makeText(this , " Erore == "+ e.getMessage().toString() , Toast.LENGTH_LONG).show();
TextView1.setText( e.getMessage().toString());
e.printStackTrace();
}
}
ولی error یی که با نوشتم برام میده نمدونم مشکل کجاست لطفا کمکم کنید