SQL Sever:
1. because protocol of VIA is enabled, SQL Server can not be started.
2. enable feature of connecting SQL Sever by TCP/IP
jdbc:jtds:sqlserver://192.168.1.100:2374;DatabaseName=***
open tool of 'SQL Server Configuration Manager', select sqlserver protocols, enable TCP/IP
3. check port of SQL Server
in sql server protocols, open property of TCP/IP, click tab of 'IP Addresses', view 'TCP Dynamic Ports' of 'IPALL'.
4. Login failed for user 'test'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
Solution: open 'SQL Server Management Studio', right-click the properties of SQL Server instance, click 'Security', enable 'SQL Server and Windows Authentication mode' of 'Server authentication'.
1, Utilize jTDS instead of Microsoft SQL Server JDBC driver
1) Introduction of jTDS
jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005 and 2008) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, concurrent (completely independent) Statements and implementing all the DatabaseMetaData and ResultSetMetaData methods. Check out the feature matrix for more details.
For more detail, refer to http://jtds.sourceforge.net/
2) It exists in Maven repository.
分享到:
相关推荐
Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration.Drawing ...
Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the ...
关于数据库开发的 I originally approached Java as “just another programming language,” which in many senses it is. But as time passed and I ...point there were always other issues that were consid
SQL Server 2005 is the most exciting release of SQL Server for years. It may be the only release in the last five years, but it’s genuinely an exciting release full of new and useful features. In ...
I will be taking some of the tips, like the Tools database and Aaron Bertrand's version of a great utility script to easily show the important info on active tasks, and putting them to use as early ...
Where appropriate, some level of discussion will be at the technical level. But, for the most part, the book is about issues and techniques. This book is meant to serve as a guideline for the designer...
An intent lock indicates that SQL Server wants to acquire a shared (S) lock or exclusive (X) lock on some of the resources lower down in the hierarchy. For example, a shared intent lock placed at the ...
on PL/SQL, ideally suited to answering your questions about how to perform some programming tasks and reminding you of the characteristics of functions, triggers, and other elements of the database ...
25.3 Creating Reports Using DSN of the SQL Server 2000 Database 451 25.4 Creating Connection Using DSN 456 Chapter 26. Error Handling 465 26.1 Key Handling 465 26.2 Key Locking at Key Press ...
data文件夹下面有SQL SERVER 数据库文件,附加到SQL SERVER 上即可, 然后更新连接字符串;Initial Catalog=IssueTrackerStarterKit2;Integrated Security=True"/> 建好虚拟目录后,根据实际访问路径,填写根目录,...
No matter what DBMS you are using—Oracle, DB2, SQL Server, MySQL, PostgreSQL—misunderstandings can always arise over the precise meanings of terms, misunderstandings that can have a serious effect ...
SQL Server Compact support Code-First Development with Entity Framework 4 (data access) More flexible ACL implementation More user-friendly admin area Added unit tests Improvements ...
SQL Server Compact support Code-First Development with Entity Framework 4 (data access) More flexible ACL implementation More user-friendly admin area Added unit tests Improvements ...
Microsoft, Active Directory, Internet Explorer, Hyper-V, Silverlight, SQL Server, Windows, Windows Azure, and Windows PowerShell are trademarks of the Microsoft group of companies. All other ...
There is apparently some malware going around that blocks execution of Cheat Engine (Saying file missing, check filename, etc...) If you have been a victim of this then try this windows repair tool to...
and some scenarios of how you can use them. This chapter also guides you through the basics of testing your installation and configuration. Chapter 3, "Basic Features" This chapter covers the basic ...
* TDataSetProvider generates incorrect SQL in response to a RefreshRecord request in some cases and fails to update all fields properly (Quality Central 4014). * When TDataSetProvider obtains the DB ...
Examining Some Other File- and Site-Administration Issues G From Here G Chapter 11 Database Interaction Justifying Perl/Database Interaction G Examining the Database Options DBI and DBD Database ...
Keeping Track of Server Items What is Active When? Notes about Metafiles Transitions The In-Place Frame Menu Negotiation Updates UpdateAllItems() Verbs Serialization Serialize() Beyond ...