AutoCAD Plant 3D Forum
Welcome to Autodesk’s AutoCAD Plant 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Plant 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

SQL and Report Creator

14 REPLIES 14
Reply
Message 1 of 15
marina.smirnova
913 Views, 14 Replies

SQL and Report Creator

Hello,

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

 

14 REPLIES 14
Message 2 of 15

We have the same error with SQL.

There is no dialog to log in.

Message 3 of 15

Same issue here with the ProcessPower.dcf error.

Message 4 of 15

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.

Message 5 of 15

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.

Message 6 of 15

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

Message 7 of 15
ybogdanov
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) - Partner Directo de Autodesk
Barcelona (Spain)
Message 8 of 15
marina.smirnova
in reply to: ybogdanov

Spasibo bolwoe, ybogdanov

Message 9 of 15

 

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

 

Message 10 of 15

How to edit this files?

I see only strange symbols..

Message 11 of 15

I opened with notepad

Message 12 of 15

It works, thank you!

Message 13 of 15
Gaituuth
in reply to: marina.smirnova

Thanks for this solution.

It's a solution which Autodesk unfortunately didn't provide. 😞 :(Smiley Mad

 

Best regards,

 

Gerald

 

Message 14 of 15
ybogdanov
in reply to: Gaituuth

The solution it is in the Service Pack 1 for Plant3D 2012:

 

"Report Creator

Corrected a problem that prevented Report Creator from opening projects that require SQL authentication"

 

http://usa.autodesk.com/adsk/servlet/ps/dl/item?siteID=123112&id=18430575&linkID=14116968

-----------------------------------------------------------
Yury Bogdanov
ASIDEK(Grupo CT) - Partner Directo de Autodesk
Barcelona (Spain)
Message 15 of 15
marina.smirnova
in reply to: ybogdanov

Ohhh:)

Thank you very much. It's very very good!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost