>>First, try to get a connection without passing the string:
>>
>>gnConHandle = SQLSTRINGCONNECT()
>>
>>Choose the data source from the dialog box. You may have to select the DSN from the Machine Data Source tab. When you get the Login form, enter the UserID, Password. The server name should already be there.
>>
>
>>If that works, do a CREATE CONNECTION conAMCS to create a connection in your Database. Specify the Connection String option. Then click the Builder button to the right of the Connect String textbox. Select your DSN from Data Source dialog box and click OK. The Connect String it builds is what you have to pass in the SQLCONNECTSTRING function.
>
>I GET to "CREATE CONNECTION conAMCS " then the message "NO database is open or set as the current database" I followed your instructions verbatim.

Open your DBC. If you don't have one, you have to create a database. A connection has to be a member of a DBC.