• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Plant 3D

    Reply
    Active Member
    marina.smirnova
    Posts: 9
    Registered: ‎09-27-2011

    SQL and Report Creator

    380 Views, 14 Replies
    10-13-2011 07:24 AM

    Hello,

    I have a problem with Report Creation only for projects with SQL Expess.  With other projects everything is good.

     

    Please use plain text.
    Contributor
    Posts: 17
    Registered: ‎09-10-2008

    Re: SQL and Report Creator

    11-29-2011 03:18 AM in reply to: marina.smirnova

    We have the same error with SQL.

    There is no dialog to log in.

    Please use plain text.
    Contributor
    Eshleman78
    Posts: 18
    Registered: ‎04-19-2011

    Re: SQL and Report Creator

    12-07-2011 07:14 AM in reply to: marina.smirnova

    Same issue here with the ProcessPower.dcf error.

    Please use plain text.
    Board Manager
    Posts: 68
    Registered: ‎08-02-2007

    Re: SQL and Report Creator

    12-07-2011 09:44 AM in reply to: marina.smirnova

    The Report Create will work with Windows Authentication for SQL Express. With SQL Authentication there is some issue opening project data and we are currently looking at it. Expect something soon on this.

     



    Mangesh Kalbhor
    Autodesk Plant Solutions
    Autodesk, Inc.

    Please use plain text.
    Employee
    Posts: 185
    Registered: ‎08-15-2007

    Re: SQL and Report Creator

    12-07-2011 09:46 AM in reply to: marina.smirnova

    Thanks for the heads up. We've confirmed that this is an issue and are working on it. As usual, I can't give any details on when it will be addressed.



    Peter Quinn
    Senior Product Manager
    Autodesk, Inc.

    Please use plain text.
    Contributor
    Posts: 17
    Registered: ‎09-10-2008

    Re: SQL and Report Creator

    12-08-2011 02:12 AM in reply to: marina.smirnova

    Thanks for recognizing the problem, I hope on a hotfix soon.

    Please use plain text.
    Valued Mentor
    ybogdanov
    Posts: 336
    Registered: ‎07-07-2011

    Re: SQL and Report Creator

    12-09-2011 05:03 AM in reply to: marina.smirnova

    marina.yurova escribió:

    Hello,

    I have a problem with Report Creation only for projects with SQL Expess.  With other projects everything is good.

     



    Report Creator ne rabotaet v proektax kotorie podkreplenni s SQL serverom, tak kak SQL server imeet svoi sobstvennie vozmojnosti dlya formirovaniya dokladov, na primer Report Builder.

    -----------------------------------------------------------
    Yury Bogdanov
    ASIDEK(Grupo CT)
    Barcelona (Spain)
    Please use plain text.
    Active Member
    marina.smirnova
    Posts: 9
    Registered: ‎09-27-2011

    Re: SQL and Report Creator

    12-09-2011 05:16 AM in reply to: ybogdanov

    Spasibo bolwoe, ybogdanov

    Please use plain text.
    Active Member
    marina.smirnova
    Posts: 9
    Registered: ‎09-27-2011

    Re: SQL and Report Creator

    01-25-2012 04:20 AM in reply to: marina.smirnova

     

    Hello,

    If anybody has the same problem and wants to use Report Creater with Project with SQL Express, there is one trick.

    In the project folder there is 4 files 

     iso.dcf

    otho.dcf

    Piping.dcf

    ProcessPrower.dcf

     

    Then in every file after the Integrated Seguruty paste the following

     

    <Name>Integrated Security</Name>
    <Value xsi:type="xsd:boolean">false</Value>
    </Parameter>
    <Parameter>
    <Name>user id</Name>
    <Value xsi:type="xsd:string">sa</Value>
    </Parameter>
    <Parameter>
    <Name>Password</Name>
    <Value xsi:type="xsd:string">as</Value>
    </Parameter>
    <Parameter>

    sa - is the id name

    and as is the password

     

    After that everything works good.

     

    May be there is a way how to avoid this operation?

    Thank you very much

     

    Please use plain text.
    Contributor
    Posts: 17
    Registered: ‎09-10-2008

    Re: SQL and Report Creator

    01-25-2012 04:33 AM in reply to: marina.smirnova

    How to edit this files?

    I see only strange symbols..

    Please use plain text.