I apologize. I did not ask the question properly.

I also need to find out if the SQLPREPARE and SQLEXEC functions are implemented in the same way as they would be with a DSN.

The reason I ask is that I cannot make it work.

Here is my code:

CREATE DATA worktbls\dataconn
CREATE CONNECTION ConVar CONNSTRING "DRIVE={SQL Server}SERVER=LISTMAKER_II;UID=sa;PWD=;DATABASE=listmaker"

=sqlprepare(ConVar,"Select * from list","list")
=sqlexec(ConVar)

When the SQLPREPARE executes I get the following error: "Variable ConVar is not found."

Is there something obvious that I am missing?



>Hiya Bob ---
>
>OPEN DATABASE mydata
>CREATE CONNECTION myconnection DATASOURCE cDSN
>
>cDSN=Character string of the system DSN.....or:
>
>CREATE CONNECTION myconnection USERID cODBCUser PASSWORD cODBCPW DATABASE cODBCdatabase CONNSTRING cODBCConnectString
>
>>How do I create a connection by using a connection string?
>>
>>Bob