|
Тема
|
MSSQL + JSP
|
|
Автор | GoliamVapros (Нерегистриран) |
Публикувано | 29.05.05 08:33 |
|
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
| |
Тема
|
Re: MSSQL + JSP
[re: GoliamVapros]
|
|
Автор | lvo (Нерегистриран) |
Публикувано | 21.03.07 11:48 |
|
Connection connection = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PWI", "sa","");
| |
|
|
|
|