Terry,

 

I have tried every thing you guys are telling me on this post. I created the udl file copied the url from there paste it in your exe file. did every thing a developer can do. But the line in the step 4 that
 
"In the User Adapter Type and Data Provider Type fields, you need to specify the full type name of the provider and the name of the assembly containing the provider implementation"
 

 

made me confused that i am missing something. I checked the users roles too to corrrect the sql server problem.  I think the above point is not a problem. Hope it will get solve. If i want to specify DataProviderType and the UserAdapterType by myself what should i need to mention over here. Import.xml don't have anything about their values.

Regards,

Ghazala