>Kendall
>
>It's been nearly a month and I'm still struggling with this problem. Perhaps you could shed some insight. Although the code works here on my server, it fails at the client site with the message is that The Connection Handle is Invalid. Since I am 1500 miles away and have no remote access to the server, it's a little hard to know what is going on. Here's the command I use to create the connection:
>
>nHandle = SQLStringConnect('driver={SQL Server};server=ABC;database=DEF;Trusted_Connection=Yes')
>
>I check to see that nHandle is > 0, and then attempt to set the connection to asynchronous:
>
>nResult = SQLSetProp(nHandle, "ASYNCHRONOUS", .T.)
>
>I suspect this is the line that generates the error since my error trapping before and after this command would yeild different messages...
>
>Any ideas?

Not really, I'm stumped with the facts so far because the code supplied looks OK. And, if it works at one site and not another I would look at the environment factors, OS, network, service packs, etc.

Are there any differences between the 2 installations? Does the trusted user account have sufficient permissions setup? Can you use the handle returned to set other SQLSetProp properties, or is it just failing on the attempt to set the asynchronous property? What are the OS, network and SQL Server versions you are using?

Not much help I know, but maybe it will spark some ideas you hadn't thought about, but after a month I'm thinking that you've probably exhausted the possibilities.

You might also try posting on the Seattle VFUG Yahoo group for help with this too, and at the meeting in a couple of weeks. Sorry I can't getcha out of this one. :-(