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
If it's not broken, fix it until it is.
My Blog