>>

>> *-- Connect to  Server
>>  gnConnHandle = SQLCONNECT(gc_sqlconnect, gc_sqluser,gc_sqlpasswd)
>>
>>IF gnConnHandle > 0
>>    * you are connected
>>ELSE
>>      
>>   * you are not connected
>> ENDIF
>>
>>
>>

>
>Thanks Bill, I did try that. I was hoping you had a clever alternative :) Very weird this problem. Seems to me that VFP cannot find the right driver even though I have tried every variation I can think of for the connection string. I am wondering if its a 32bit/64bit thing but before installing new stuff on the server I thought it best to get some feedback.

Are you running 32 bit version of ODBC to create the DSN? You need to use 32 bit version to create DSN. If you get that 32 bit version to work, then you should specify that DSN in the connection string and it should work.