Holy shit - Eclipse is absolute dog shit when it comes to this. All the default SQL Server stuff is "broken" as you say and I fully agree. Was setting up and it wasn't giving me any properties window, no error messages, nothing to help me figure out why it wasn't working AT ALL. Wasted so many hours trying to figure this out. Using "Other Driver" and your settings was the saving grace. They should link your video from that window no joke. Your video freggin saved me so much, thank you!!!
The TCP/IP connection to the host SV5503DB1021 qlexpress, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
thank you so much , this video really help me ... when I tried to edit the data this message appear "Cannot edit table. An unknown or unsupported data type encountered for column Template."
1/I had an error when I try to edit data from a table. The error message says: "Cannot edit table. An unknown or unsupported data type encountered for column " . That column name "Hoten" and it's data type is nvarchar(50). So pls help me .. 2/When I try to add new connection URL. It's only work when I use URL "jdbc:sqlserver://localhost;databaseName=JavaWebDemo". So why it's must be "localhost" instead of /[serverName[\instanceName][:portNumber]] I'm learning Java Web for my school Java Project and I'm VietNamese too but I want to practice English so I wrote this comment:))
I had a problem during setup: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "No appropriate protocol (protocol is disabled or cipher suites are inappropriate)". I'm using sqljdbc_12.4.1lib How can I fix it?
hi anh em đã tạo được nhưng tới đoạn edit table(14:27) nó báo lỗi Cannot read the array length because "editors" is null # các table của em đều đã có dữ liệu rồi ạ mong anh phản hồi sớm
I couldn't able to edit the url connection in Properties. I am literally connecting MSSQL server with IP adddess. But i was need to add Encrpt: true,Trustcertificates:true; but it was neglacting
Thank you so much for this. I was struggling to connect for a JPA project and my problem was that the Spring Boot connection string has \\sqlexpress where from the IDE it is a single \sqlexpress SAVED my bacon. Thanks again
@@CodeJava in url do we have to write the same thing that u have written. Cuz I m getting an error that says the connection to host sqlserver, named instance sqlexpress failed. No such host is known...help me with this.
then you should use the JDBC URL like this: jdbc:sqlserver://localhost;integratedSecurity=true; Reference: www.codejava.net/java-se/jdbc/connect-to-microsoft-sql-server-via-jdbc
em bị lỗi này ạ com.microsoft.sqlserver.jdbc.sqlserverexception: the driver could not establish a secure connection to sql server by using secure sockets layer (ssl) encryption
@@CodeJava i already use jdbc river 12.(the latest one) but still mess the same error like him. but when i add trustServerCertificate= true; in URL the error disappear, it not last long until reconnect. any helpful suggestion?