>>Hello,
>>I am connecting to a SQL sevrver 2008 using ADO.
>>In my vfp program, I have problem getting the value of auto-increment field after I do an rs.addnew and rs.update.
>>The record is added/updated on the server side with no problem.
>>
>>I used to be able to get the value of the auto-increment field when I run the same program to connect to an MS Access DB
>>
>>Here is my connectin string:
>>adoDBC.Open ("Provider=SQLNCLI;Database=pcMPISQL1;Server=insvb01038adx05;Integrated Security=SSPI")
>>
>>Any suggestion ?
>>
>>Thanks,
>>Kam Lee
>>SUNY DMC
>
>What is the reason for using ADO? Just wondering, in our applications we're using SQLPassThru and don't have a problem.
Because I wrote this code to connect to MS Access using ADO about 10 years ago... and now trying to switch the backend from Access to SQL server.. and trying not to re-invent the wheel using other access method..

Thanks,