I found the problem. I was missing a semicolon after one of the Connection String arguments/
Thanks again.
>Thanks, Bob ---
>
>Check the value of nConVar. It should be a positive number (like 1). If it is not, there is something wrong with the connection. Try recreating the connection using the wizard in the Database Designer and then restarting this exercise from the nConVar=SQLCONNECT("ConnectName") .
>
>
>>You are not only the BEST you are also the FASTEST! Thanks for the quick response.
>>
>>I did as you said and came up with the following error:
>>
>>nConVar=SQLCONNECT("ConVar")
>>=sqlprepare(nConVar,"Select * from list","list")
>>
>>Error:"Connection handle is invalid."
>>
>>When I test the connection it is successful.
>>
>>Any other ideas?
>>
>>Thanks again, Bob
>>
Database Development Team