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
Database Development Team