This is what i want to do but i dont know how possible it is: I want to write a program to connect to an sql server database over a lan and execute a select query and have the results returned to me and displayed in a table in the java program. Any ideas? thanks james
You need to purchase a SQL Server 7 driver (MS does not provide one, and the 2000 driver does not work) or use the ODBC bridge driver (sun.jdbc.odbc.JdbcOdbcDriver) with URL jdbc dbc:<odbc name>. Note that with ODBC you need to make an ODBC entry on the machine for the database. Also note that the odbc bridge driver performs very poorly, and gives unexpected results. It's not meant for production use.