Dear all

I created a cursor adopter and did setting through Builder after that
i opend cursor adaptor's code and i trying to change connectsring as a Variable
like

cSQlPath = "Provider=SQLOLEDB.1;";
+"Integrated Security=SSPI;";
+"Persist Security Info=False;";
+"Initial Catalog=ABC;";
+"Data Source=XYZ;";
+"Initial File Name="+"'"+\\Server\Data\data1.Mdf+"'"
loConnDataSource.ConnectionString = cSQlPath

everything is working fine except when trying to open the builder for the existing cursor
the system getting hanged.

but if i retype the existing code like this

[Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;U] + ;
[ser ID=administartor;Initial Catalog=ABC;Data Source=XYZ;]
its working fine

so, anybody help me how to set connectstring as variable.

with thanks and regards

Abdulla