File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes connecting mssql7 through odbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "connecting mssql7 through odbc" Watch "connecting mssql7 through odbc" New topic

connecting mssql7 through odbc

Varma dandu

Joined: Apr 29, 2005
Posts: 16
Hi dudes,

Could anyone help me in connecting to mssqlserver7 through odbc on linux platform().

msql server resides on the windows box which i have to access via network.

this is very urgent.

Varma dandu

Joined: Apr 29, 2005
Posts: 16
Sorry this is me again.
OR could anyone tell me how to create datasource on linux platform(KDE 3.3) to a remote mssql server.

Varma Dandu.
Varma dandu

Joined: Apr 29, 2005
Posts: 16

I just downloaded jtds jar file and kept in classpath.

and used

Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://serverip:1433/databaseName",
"userName", "password");

Varma Dandu.
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30057

Thanks for posting the solution!

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: connecting mssql7 through odbc
Similar Threads
oracle9i not being connect
JDBC, ODBC, Drivers, etc.
Servlet connecting to a database Network is unreachable
Cannot create JDBC driver of class '' for connect URL 'null',