Hi everybody,

I have SQL Server 2008 R2 64 installed. I'm trying different connection strings and all result in errors. I use udl file and the connection succeeds, but trying to use it from VFP fails.

Do you know what can I use to make it work?

TEXT TO lcConnectioString NOSHOW PRETEXT 15
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CardNumbers;Data Source=NAOMI-DELL
ENDTEXT

Handle = SQLSTRINGCONNECT(lcConnectioString)
IF Handle < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF