Hi Guys, I am new to windows programing, and my computer is running Windows XP Home Edition. Would somebody tell me how to connect from VB6.0 to SQL Server 2000, and if it's possible, then where I can download for free windows component update for VS.NET? Stan

I have answered this question about a hundred times (I wish this forum was easier to search, or organized better)... anyhow: It is possible, simply use the ADODB objects. Dim CN As ADODB.Connection Dim RS As ADODB.RecordSet Set CN = New ADODB.Connection Set RS = New ADODB.RecordSet SQL = "SELECT * FROM MyTable" CN.Open "Driver={SQL Server};USR=username;PWD=Password;Databse=DatabaseName" RS.Open SQl, CN Do While RS.EOF = False     ' Do Something     RS.MoveNext Loop RS.Close CN.Close Set RS = Nothing Set CN = Nothing