We do have accounting program based on SQL 2005 and shipping base on Custom VB6 program.
Shipping VB 6 program is pointing to accounting Database and getting Sales Order info and then writing back to accounting once data is processed. We now upgrading accounting program to run on SQL 2008R2. While testing connection to a new system we re-pointed VB program to new SQL server 2008R2.
We can still pull data out but getting an error on writing back from VB to SQL. We tested security rights and it is not a problem.
Shipping Client machine with VB 6 program is running on XP SP3.
i tried native SQL string but it didn't even read from 2008r
strCnn = "Provider=SQLNCLI10;Passwo
w;Persist Security Info=True;User ID=sa;Server=my_SQL2008R2;
ATTACHED IS A PIECE OF VB6 CODE WHICH IS FAILING