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?