JSP + MSSQL

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

moze niakoi ima niakakav primeren kod za vrazka i obrabotka na baza (jsp+mssql),sega tragnah da ucha jsp e za sega 4 dena stoja na samata vrazka jsp+mssql

con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433", "userName", "password");

или направо прегледай
[линк]

The human knowledge belongs to the world.

probvah :
import java.*;
public class Connect{
private java.sql.Connection con = null;
private final String url = "jdbc:microsoft:sqlserver://";
private final String serverName= "127.0.0.1";
private final String portNumber = "1433";
private final String databaseName= "PWI";
private final String userName = "username";
private final String password = "password";
// Informs the driver to use server a side-cursor,
// which permits more than one active statement
// on a connection.
private final String selectMethod = "cursor";

// Constructor
public Connect(){}

private String getConnectionUrl(){
return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
}

private java.sql.Connection getConnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
if(con!=null) System.out.println("Connection Successful!");
}catch(Exception e){
e.printStackTrace();
System.out.println("Error Trace in getConnection() : " + e.getMessage());
}
return con;
}

/*
Display the driver properties, database details
*/

public void displayDbProperties(){
java.sql.DatabaseMetaData dm = null;
java.sql.ResultSet rs = null;
try{
con= this.getConnection();
if(con!=null){
dm = con.getMetaData();
System.out.println("Driver Information");
System.out.println("\tDriver Name: "+ dm.getDriverName());
System.out.println("\tDriver Version: "+ dm.getDriverVersion ());
System.out.println("\nDatabase Information ");
System.out.println("\tDatabase Name: "+ dm.getDatabaseProductName());
System.out.println("\tDatabase Version: "+ dm.getDatabaseProductVersion());
System.out.println("Avalilable Catalogs ");
rs = dm.getCatalogs();
while(rs.next()){
System.out.println("\tcatalog: "+ rs.getString(1));
}
rs.close();
rs = null;
closeConnection();
}else System.out.println("Error: No active Connection");
}catch(Exception e){
e.printStackTrace();
}
dm=null;
}

private void closeConnection(){
try{
if(con!=null)
con.close();
con=null;
}catch(Exception e){
e.printStackTrace();
}
}
public static void main(String[] args) throws Exception
{
Connect myDbTest = new Connect();
myDbTest.displayDbProperties();
}
}

kato estestveno smenih tam username i password ..
error:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
?

да не е спрян сървъра ? или пък да имаш някаква защитна стена която да пречи?

The human knowledge belongs to the world.

Servera ne e sprian-vizdam go che raboti.. A niamam zashtitna stena..Firewalla go svalih ,zashtoto po printsip na port 8080 imam i tomcat -niakolko jsp stranichki.. Taka che ne e ot tova..
Probvah da smenia i porta: windows maj inastalira MSSQL na 3306 ,no pak ne varvi..
Probvah i nov user.. sazdadoh tam niakakav nov ,pak ne stava ..
Idea niamam kakvo e..
Estestveno imam intraliram JDBC -inache vaosbhte niamashe da tragne..

само да отбележа, че MSSQL е на 1433 порт, а MySQL е на 3306. това само за протокола.

Da prav si obarkah se!! No i tak ne promenia fakta che ne raboti:))
A i proverih MSSQL e na 1433:))

Пробвай да сложиш service pack 3

Za firewall ve4e ti kazaha, no az pak da kaja, 4e ako imash pusnata antivirustna tia sashto moje da ti blokira vrazkite.

Nice site!

[линк]
[линк]
[линк]
<a href=[линк] >online</a>
<a href=[линк] >online</a>
<a href=[линк] >online</a>

<a href=[линк] >pills</a>
<a href=[линк] >boys in underwear</a>
<a href=[линк] >online</a>
[линк]
[линк]
<a href=[линк] >online</a>
[линк]
<a href=[линк] >online</a>
<a href=[линк] >cache browser</a>

<a href=[линк] >seller</a>
<a href=[линк] >generic sildenafil citrate</a>
<a href=[линк] >cialis mail order</a>
<a href=[линк] >sildenafil citrate</a>
<a href=[линк] >buy cheap cialis</a>

Как ти е настроена базата в сървера ?

- Windows Server Authentication
- SQL Server Authentication
- Mixed?

Имаш ли средство с което да натаманисаш Server Authentication-а
Нещо като SQL Server Management Studio Express.(позабравих как се казваше тая дждджа за 2000) Много е важно как ще регистрираш базата данни с тая джаджа. От това трябва да ти зависи и конекшън стринга - трябва да го има описан за различните конекшъни.... Като регистрираш базата данни по някой от начините - опитай да влезеш на ръка...
Успех!

[URL=[линк]]online5[/URL]
[линк]
<a href=[линк] >crabs</a>
<a href=[линк] >create a south park peson</a>
<a href=[линк] >crillon paris</a>
<a href=[линк] >/cross country quarter horse</a>
[линк]