Thursday, February 16, 2012

Cannot get RDA.Pull to work

[SQL Everywhere CTP],[VS2005]

RDA.Pull method is not doing anything for me from a VSTO 2005 Outlook addin project. I have IIS & SQL Server 2005 running on my develpoment pc. I am using Integrated Windows Auth for vdir. It just stops execution at the line of code that calls RDA.Pull & doesnt return any tables nor throws an error. I have no idea where I am going wrong. I have tried using table names that dont exist in the .sdf too.

SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess();

rda.InternetUrl = @."http://localhost/WsRDA/sqlcesa30.dll";

rda.LocalConnectionString = @."Data Source=D:\_fullPahtHere\DBEverywhere.sdf;Password=sdfPwdHere";

rda.InternetLogin = "myLocalUserName";
rda.InternetPassword = "myLocalPassword";

rda.Pull("Class2", "select * from dbo.Class", @."Data Source=MyDesktop\SQL2K5;Initial Catalog=ServerDB;Integrated Security=SSPI");

Without an error msg, I dont know what the problem is. Any ideas?Ok, figured out. My connection string was missing Provider=sqloledb attribute.

No comments:

Post a Comment