JDBC

[ice78991]

I have just downloaded the JDBC Drivers for SQl Server 2005 from Microsoft. Can I use these drivers to connect to a sql server using a TCP connection. I am looking for something similar to the following c# code in java

string str = "Data Source=127.0.0.1,1909;" +
"Network Library=DBMSSOCN;" +
"Initial Catalog=master;" +
"User ID=sa;" +
"Password=pass;";


try
{
myConnection = new SqlConnection(str);
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}

 

[stefanwagner]

Look at file:/%JAVA_HOME%/docs/technotes/guides/jdbc/index.html
for a general guide to jdbc.
Look at the documentation from your specific database vendor for details like portnumber.

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung

 

[rainwly0819]

You can try the URL below to get the format of the connection string to connect to kinds of DBs.
Hope it can help.

http://www.connectionstrings.com/