从Netbeans连接到SQL Server [英] connecting to SQL Server from Netbeans
问题描述
我正在尝试连接到最近使用NetBeans安装的SQL Server 2010的服务器实例。我已经下载了最新的MS SQL Server JDBC驱动程序,但是我无法获得正确的连接字符串来连接到这个数据库。我想我在连接中缺少以下值:
I am trying to connect to a server instance of SQL Server 2010 that I installed recently using NetBeans. I have downloaded the latest JDBC driver for MS SQL Server, but I cannot get the right connection string to connect to this database. I think I am missing the following values in the connection:
- 端口
- 实例名称
- 我不确定我的用户名是 / ***还是只有/ 后出现的名称
- Port
- Instance Name
- and I am not sure if my username should be /*** or only the name that appears after the /
'jdbc:sqlserver://'
'jdbc:sqlserver://'
感谢任何帮助,
Ted
推荐答案
这应该会有所帮助:
http://netbeans.org/kb/docs/java /gui-db.html
编辑:根据下面的评论,这是针对德比的东西。这是一个更有用的链接,但它没有提供有关提供数据库用户名或密码的任何信息。根据您的具体要求,这可能就足够了。
Edit: As per comment below this was for derby stuff. Here is a more useful link but it's not got any information on supplying the DB username or password. It might be enough depending on your exact requirement.
这篇关于从Netbeans连接到SQL Server的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!