MSSQL + JSP

1 отговора 315 прегледа
#1

MSSQL + JSP

Probvam da svarza MSSQL baza danni kojato se kazva PWI z jsp
:
public class test {
public test() throws Exception {
// Get connection
/* DriverManager.registerDriver(new
com.microsoft.jdbc.sqlserver.SQLServerDriver()); */
Driver d = (Driver)Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Connection connection = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://127.0.0.1:3306/PWI","","");

if (connection != null) {
System.out.println();
System.out.println("Successfully connected");
System.out.println();
// Meta data
DatabaseMetaData meta = connection.getMetaData();
System.out.println("\nDriver Information");
System.out.println("Driver Name: "
+ meta.getDriverName());
System.out.println("Driver Version: "
+ meta.getDriverVersion());
System.out.println("\nDatabase Information ");
System.out.println("Database Name: "
+ meta.getDatabaseProductName());
System.out.println("Database Version: "+
meta.getDatabaseProductVersion());
}
}

Error: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

Kade barkam ,moze niakoi se doseshta,
mersi za pomoshta

Отговор
в отговор на GoliamVapros #2

Re: MSSQL + JSP

Connection connection = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PWI", "sa","");

Отговор