Data Control and SQL server?

[Steve Thomas]

I am using SQL server. I want to connect to SQL server and populate a Data Control. However, when I try and select Connect, SQL server is not one of the choices. I am using VB5. Is there now a better way to get to the table in SQL Serve rather than using a Data Control or am I doing something wrong?

Thanks in advance

[Steve Thomas]

I have a form with a data control. It takes information from an access database and populates the form. The data control points to an access database. Question: can I still use data controls if I want to convert from Access97 to SQL server? If not, what is the best control,activeX, etc to use to find, and display data from SQL server on my VB5 form.

[JHausmann]

AFAIK (and I don't know much about bound controls with ADO, yet),you're not going to be able to do it with a bound control in VB5, you'll either need to populate the control objects yourself or use VB6 with the ADO control object(s).

[Steve Thomas]

I am not in love with ADO yet as Microsoft wants, so what I need is a way to display tables using a SQL server. Is there anyway to do this using DAO or RDO using some kind of control? I know I can create a recordset and then populate my controls but I sure like having a control. Otherwise, I guess I just might have to break down and buy VB6.

Thanks