I am trying to connect to a SQL SERVER 6.5 DB using java. CAn you please suggest whether we can achieve this by using the ODBC driver or would I have to use a third party JDBC Driver. I believe JTDS Driver is a good one for connecting to SQL SERVER 6.5. Has anybody used to before?? If yes can you please give me the code for all the steps for using JTDS driver in a java Programme and where exactly to include the jar file path in the java code.
If not, then has anybody has had any experience connecting SQL SERVER 6.5 with ODBC Driver and could give me the code, please.
Thanks for your quick reply!!