SQL SERVER

[nitin kumar]

Hi guys,
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
Connection connection = DriverManager.getConnection(
"jdbc:microsoft:sqlserver://<Host>:1433",<"UID>","<PWD>");

Im using driver type-4 .Im able to connect to a database in my SQL SERVER but I do not know how can this code locate the driver since I did not mention the database name nor the dsn.Can anyone please tell me how they locate the driver
bye
nitin

[Vijayanandraj Amaladoss]

So Simple . The driver is in ur classpath.
[ May 05, 2004: Message edited by: Vijayanandraj Amaladoss ]

[nitin kumar]

Sorry I mean to say the database not the driver.How can it locate to any database

bye
Nitin

[Jeanne Boyarsky]

Nitin,
It can go at the end of the url string. For example,
"jdbc:microsoft:sqlserver://111.111.111.111:1433;DatabaseName=name"

[nitin kumar]

Hi jeanne,

Thanks for your reply.My problem is solved by your help

bye
Nitin

[nitin kumar]

Hi ,


Can anyone tell the difference between obtaining connection through
DriverManager and through DataSource.

bye
nitin

[Jeanne Boyarsky]

Nitin,
If you use driver manager, you need to manage the connection all by yourself. If you use datasource, the server can help you by doing things like connection pooling.