Forums Register Login

connecting mssql7 through odbc

+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
Varma,
Thanks for posting the solution!
I didn't say it. I'm just telling you what this tiny ad said.
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 934 times.
Similar Threads
Cannot create JDBC driver of class '' for connect URL 'null',
java.net.ConnectException: Network is unreachable
JDBC, ODBC, Drivers, etc.
oracle9i not being connect
Servlet connecting to a database
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 07:34:46.