Shulou(Shulou.com)05/31 Report--

In view of how to configure MyEclipes in sql server 2008, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way.

1. I don't know which one to choose in Driver template?

Because there are three related to sql server: Microsoft Sql Server, Microsoft Sql Server (JTDS Driver), Microsoft Sql Server 2005, but there is no 2008, so we will struggle here. No, we went on to choose Microsoft Sql Server 2005.

2. Connection URL doesn't know how to write again.

I'm not afraid to write it the same way I wrote it in 2005. Jdbc:sqlserver://localhost:1433;databaseName=testDB

3. Does Driver JARs also use 2005 JAR?

It doesn't work. There is a difference between 2005 (sqljdbc.jar) and 2008 (sqljdbc4.jar) JAR, so it's easy to be one online.

4. Do you want to change the port of 2008?

There is a related article on the Internet that says to change "SQL Server configuration management"-"SQL Server network configuration"-"SQLEXPERSS protocol"-"TCP/IP"-"address" to change the dynamic port in IPA11 to the same as the port in your program. I have personally tested that the newly installed sql server 2008 configuration does not need to be changed, much less the dynamic port of IPAll.

Note: test environment Win 7+MyEclipes8.6+Sql Server2008

This is the answer to the question about how to configure MyEclipes in sql server 2008. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.