Home.... | log in.... | Pub my question! | Sign-up....
Java-index >> Database Connectivity >> Java Database Connectivity (JDBC)

SQL Server 2005 URL

hi,i have problem regarding SQL Server2005 connection in Netbeans IDE.i hava downlaoded driver and installed it.but the problem is that i don't know that is the URL .if someone explain it i will be greatfull to one.thanks
[264 byte] By [khan_vu2007a] at [2007-11-27 5:36:08]
«« switch connection
»» JTree image question
# 1

I used that at work, but it's the weekend and I don't have that code here. But no problem, I just googled "sql server 2005 jdbc url" and the first link has the answer:

http://msdn2.microsoft.com/en-us/library/ms378428.aspx

You could try that too the next time you have a question. It's amazing how often you find the answer.

DrClapa at 2007-7-12 15:06:17 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

The connection URL for the default SQL Server 2005 database is jdbc:sqlserver://localhost:<port>.

<port> is obtained from the SQL Server Configuration Manager. To obtain the <port>, select SQL Server 2005 Network Configuration > Protocols for SQLEXPRESS in SQL Server Configuration Manager. Right-click the TCP/IP node, and select Properties. Select the IP Addresses tab in the TCP/IP dialog. In the IP ALL section, the TCP Dynamic Ports specifies the <port> value

dvohra09a at 2007-7-12 15:06:17 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
Database Connectivity
Java Database Connectivity (JDBC)

Database Connectivity Hot Topic

Database Connectivity

All Classified