locked
custom aspx page in outlook offline RRS feed

  • Question

  • Dear all, I have a custom aspx website and in online mode it works fine, in offline it doesnt. :(
    I found some problems with autentication...
    What I did:
    I copied the folder from server to client PC to a folder under C:Program Files/Microsoft Dynamics CRM/Client/res/web/customfolder
    The page is quite simple it runs SQL statement (somethink like select A from FilteredB) and returns it to iFrame on my custom entity.


    The problem is I think in authentication, because online I can use windows authentication but I dont know how does it work in offline, the local SQL server (CRM instance) uses shared memory protocol and I cannot connect.

    Please could you:
    1) point me what should be done to run custom aspx page in outlook offline mode? (I have many pages running online, I think the problem is in authentication and in a different way the page connects to SQL express)
    2) probably similar problem is with my custom reports, online they work fine (writen in Visual studio, uploaded via CRM (.rdl file), i use CRMAF_ prefix and filtered views to keep the security; I can "manage them" via CRM and synchronize them to offline mode, but i'm not able to run them offline), any idea what should be done?

    Thank you

    Jan
    Wednesday, July 22, 2009 6:56 PM

Answers

  • Hi, Jan.

    I suggest you to use Crm Web Services to retrieve full functionality and this is supported way instead of Direct Sql Queries.

    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Wednesday, July 22, 2009 7:28 PM
    Moderator

All replies

  • Hello Jan - If you've got  CRM 4 Programming guide, scroll through Chapter 7 & 10 - Developing iFrame for offline Solutions. That will give the insight.


    You can check here as well: http://rc.crm.dynamics.com/rc/downloads/Prog_CRM_4.0_Ch10.pdf


    Thanks
    Arul
    Wednesday, July 22, 2009 7:12 PM
  • Hi Arul, I found it, went through but it is unfortunately in C#, my pages are in VB... there should be way in VB as well, am I right?

    And please could you also help me with Q2, with reports?
    I have only one connection there, data source called crm, which points to crm server (http://crm) the problem is I think same it doesnt retrieve data because of authentication....

    Thanks Jan

    Wednesday, July 22, 2009 7:25 PM
  • Hi, Jan.

    I suggest you to use Crm Web Services to retrieve full functionality and this is supported way instead of Direct Sql Queries.

    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Wednesday, July 22, 2009 7:28 PM
    Moderator
  • Dear Andryi, I use it now but I cant access (create) custom entities (connot create record in a custom entity) when in off-line, could you help me? What is the magic behind?

    Thank you
    Monday, July 27, 2009 3:21 PM