• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

connecting mssql7 through odbc

 
Varma dandu
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanx
Varma
 
Varma dandu
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Regards
Varma Dandu.
 
Varma dandu
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
gotcha...

I just downloaded jtds jar file and kept in classpath.

and used

Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:jtds:sqlserver://serverip:1433/databaseName",
"userName", "password");

Cheers
Varma Dandu.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34225
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Varma,
Thanks for posting the solution!
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic