How do you connect to a SQL server?

I have used VB to connect to access many times. But now I need to connect to SQL server. I create a recordset object on my form and the list for the connect field gives me choices of Access, Excel, text and so forth but no SQL server.

I tried to use the dataform wizzard which was what I really wanted to do and all I could do is connect with ODBC.

Thanks
Brandon

you can click on project then on add data environment. then you'll be automatically transfered to the data environment window. right click on connection, click properties, and just go through the selections in all tabs.

when you're already connected, click on the data view toolbar button and drag the item(s) you want into the data environment window.

if you want to know more about the data environment, click on http://www.vbpj.com..you need to register first, though (it's free), then click on Locator+ and type VBPJ0799 into the box.

hope this helps.