>>>I tried both of them:
>>>
>>>lcCstr="DRIVER=SQL Server;Application Name=OZCOM-STEP;SERVER="+Alltrim(M.XServer)+;
>>> ";uid="+Alltrim(M.XUser)+";pwd="+Alltrim(M.XPassword)+";database="+Alltrim(m.xdatabase)
>>>
>>>
>>>lcCstr="DRIVER=SQL Server;ApplicationName=OZCOM-STEP;SERVER="+Alltrim(M.XServer)+;
>>> ";uid="+Alltrim(M.XUser)+";pwd="+Alltrim(M.XPassword)+";database="+Alltrim(m.xdatabase)
>>>
>>>lcCstr="DRIVER=SQL Server;App=OZCOM-STEP;SERVER="+Alltrim(M.XServer)+;
>>> ";uid="+Alltrim(M.XUser)+";pwd="+Alltrim(M.XPassword)+";database="+Alltrim(m.xdatabase)
>>
>>This is a connectionstring I use against a SQL2008 database from VFP9.
>>
>>gcConnectionString = "Driver={SQL Server Native Client 10.0};server=DELL2800\SQL2008;Database=HeartlandCube;Trusted_Connection=Yes;APP=MDP_using_native_client"
>
>I put the APP parameter end of the string and it's working now.
>Thank you,
Connectionstrings are very picky for no apparent reason.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________