1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
try
{
// Chargement du pilote JDBC
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance();
//"Integrated Security=true;Pooling=true;Max Pool Size=100;Timeout=15;MultipleActiveResultSets=true;Type System Version=SQL Server 2014;database=COHERENCE;server=xantia\\SQLEXPRESS"
Properties props = new Properties();
props.setProperty( "Initial Catalog", "Northwind");
props.setProperty( "Auto Reconnect", "true");
props.setProperty( "AttachDbFilename", "C:\\Programmes\\Microsoft SQL Server\\MSSQL12.SQLEXPRESS\\MSSQL\\DATA\\Coherence.mdf");
props.setProperty( "Type System Version", "SQL Server 2014");
props.setProperty( "Pooling", "true");
props.setProperty( "MaxPoolSize", "100");
props.setProperty( "MultipleActiveResultSets", "true");
props.setProperty( "Timeout", "15");
props.setProperty( "Driver", "Microsoft SQL Server Express Edition (64-bit)");
props.setProperty( "Driver Version", "12.0.2000 RTM");
props.setProperty( "databaseName", "Coherence");
props.setProperty( "integratedSecurity", "true");
props.setProperty( "instance","Xantia\\SQLEXPRESS");
props.setProperty( "user","XANTIA\\JeanNoël");
// URL de connexion
String url = "jdbc:odbc:login_DSN";
connection = DriverManager.getConnection( url, props);
stmt = connection.createStatement();
Data.m_bServerConnected = true;
}
catch( Exception ex)
{
ex.printStackTrace();
Data.m_bServerConnected = false;
} |
Partager