I want to connect to a SQL Server using ODBC. (I have been successful using ADO and ODBC to connect but not for the following procedure) I am currently waiting for VB6 but my employer tells me they will not get it through purchasing for about a month.

Here is the problem:

- I have a DAO data control on my form.(I understand I can not use the ADO control until I upgrade to VB6)

- I set the Data Control Connect = ODBC;DSN=TESTSQL;UID=SA
- I set the Data Control DefaultCursorType = 1 - ODBC Cursor
- I Set the Data Control DefaultType = 1 - UseODBC

And then I try and Set the Data Control RecordSource but It will not let me do it through a drop down list. I did some reading and I believe I must use a SQL statement for RecordSource. I use the following: Select * from tTable.

It gives me an error.

'**************************
I can connect if I set the DefaultType to 2 - UseJet but then when I click on my data control to move forward or Back it locks up and freezes.

If anyone has had this same problem, I would love to here your solution.

Thanks