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
>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05