Thanx for suggesion but can you tell me how to set IP address in ODBC means which tab in ODBC window for SQL server. But i think if we create system DSN only then we can specify IP address in JDBC code directly, i have seen like this code somewhere.
The IP address is entered in the box where you provide the server name.
However, you should not use the JDBC-ODBC bridge for SQL server access. Use the SQL Server JDBC driver instead. JDBC-ODBC bridge is a kludge and isn't robust enough for production use, especially for multithreaded environments.
An IDE is no substitute for an Intelligent Developer.
We noticed he had no friends. So we gave him this tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user