I am currently porting a Linux based application using MySQL for data storage, to Windows NT, using VisualBasic & MSSQL Server 7.0. I am already familiar with the SQL language, and only need to know how to interface it with VB. I have used the DataView window to open my SQL server and view my database & tables. Could someone please provide me with some sample VB source code for connecting to a MSSQL server, performing a query, retrieving the number of results, and actually retrieving the results.

Thanks!