Connect to Sqlserver using Windows 10?

Asked

Viewed 131 times

0

I am using Windows 10 and have to connect to a Sqlserver 2000 database using the command line in a java application. However, I am receiving an error. 

 run:
ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
SQLException: No suitable driver found for jdbc:microsoft:sqlserver:

It is possible windows 10 systems connect to old database like Sqlserver 2000

in a java class, made in NETBEANS IDE I gave this command:

 con = DriverManager.getConnection("jdbc:microsoft:sqlserver://servido:1433","sa","senha");
java sql sql-server netbeans

  • Have you added a lib containing the sqlserver driver to your project? Download of this link and add to your project’s classpath. The error is because it did not locate the sqlserver driver.

  • yes sqljdbc.jar or com.microsoft.sqlserver.jdbc

  • Try this https://www.microsoft.com/pt-br/download/details.aspx?id=21599 the link I gave you does not seem to be compatible with versions prior to 2008.

1 answer

0

Browser other questions tagged java sql sql-server netbeans

You are not signed in. Login or sign up in order to post.