General information
Title:
VFP6 ado connection to SQL Server 2008 as Backend
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only