AutoCAD .NET :: Application Which Uses Oracle Database As Backend
Jun 22, 2012
I am working on an application which uses an oracle database as backend. The application uses a login dialog in void IExtensionApplication.Initialize()
so my application knows the credentials for the oracle database. I use a drawing-template which has a database link in it. This points to a UDL-file in 'Data Links'. If i add the Credentials to this file and set the Parameter Persist Security Info=True the Credentials are ignored. So i thought i can avoid the additional loginprocesses if I add the following
var acadApp = (Autodesk.AutoCAD.Interop.AcadApplication)Autodesk.AutoCAD.ApplicationServices.Application.AcadApplication;dynamic cao Connect = acadApp.GetInterfaceObject("CAO.DBConnect.16");cao Connect.Connect("myconnection.UDL", "username", "password", false);
If i don't execute the code above i need two logins for the new drawing. After I added the code to my application I still need one oft this.
View 1 Replies
ADVERTISEMENT
May 31, 2011
I have just installed Map3d 2012 on a new windows 7 machine and connect to data using oracle! I have some .layer files that are stored on my server which worked perfectly in 2011! The problem I have now is when I use Load layer from the task pane I receive an message that reads..
Failed to open FDO connection
ORA-01005: Null password given: Logon denied
I can log in to my oracle database which gets rid of the error but no data is bought in! Also if I try to connect with query (polygon region on Map) from data connect (polygon region on Map) no data shown, just a red polygon where the data should appear!!
View 8 Replies
View Related
Aug 29, 2011
Is this possible, create a .Net 3.5 Dll(A.dll), reference to Oracle 11g 32 bit client Oracle.DataAccess.dll. this dll will be used in another dll(B.dll), which load in AutoCAD 64 bit application. 32 bit version of AutoCAD is not allowed to install on Windows 7 64 bit. Right now I set my B.dll as 'Any CPU', and A.dll as 'Any CPU' as well. Do I have to use 64 bit oracle client in my A.dll?
View 1 Replies
View Related
Jun 14, 2013
ORacle spatial connected via FDO.
Oracle Table uses a user defined SRS.
Drawing entities (CAD) in DWG file.
command: mapexportfdo
If no CS is assigned in Map 3D, the export of the autocad entities works ok, the result geometries are written with the correct (table/metadata) SRID.
If a CS in MAP3D is assigned (for example as a result when using a WMS from a public server), the export fails.
It seems that MAP3D is trying to "translate" the CR to SRID somehow and it fails if these are different. As this is a "plain CAD" to GIS export, I expect MAP3D to behave like:
Either it just works as in the first step (write geometries) and pick the SRID from the metadata, without applying any transformation.
Or it applies a transformation if feasible ONLY when I the user checks the thick box: Convert Coordinate to (in the options tab on the Export dialog box.
In my case I do not want to transform, I just need the geomes being exported into the target table. So far I have only managed to do so when both drawing cr and oracle SRID are "MAP3D technically equal" (based on a similar EPSG code)
Specifically, because MAP3D does not recognize the user defined SRID in ORacle, obviously it is up to the user to know what to do with the data.
NOTE1: "export fails" is the only message as a user I get from the software, not knowing what is going on. I had to drill down this issue by trial and error, great error messaging (or better refusing message).
NOTE2: Export via another file format is NO option! I need a direct export (as it always worked, also when creating features from geometry). This time I need to exportway.
View 5 Replies
View Related
Apr 19, 2013
I would like to save the data generated by LISP program at command prompt area to any data base app or any simillar app from where I can retrieve the stored data again in autocad for further usage.
For example, A LISP program generate the result as shown in above Fig. I would like to save the data of step 5, "Shear force in tonnage is : 50.868" to any database application or any simillar one from where I can retrieve the stores data for further usage.
View 9 Replies
View Related
Nov 30, 2011
I have a new requirement from company to save a static drawing's dimensions' data into DB table. We have hundreds of drawings. DBConnect connects with oracle using ODBC. But how it is possible that we draw a drawing and its attributes are saved in DB.
View 3 Replies
View Related
Aug 6, 2013
I am working on the AutoCAD customization and doing the same by VB.Net & C#.Net. But I just want to know the difference as mentioned below:
1. Insert Block In AutoCAD
Using VB.Net without using DataBase services..Only 1 statement is required to Insert the Block objAcadDocument.ModelSpace.InsertBlock(Required Arguments are here) Using C#.Net with DataBase services
There are many statments are there to insert only 1 block..Like Start Transaction, Lock the document, Get the Object Id Block etc...So my quetion is that when I have to use DataBase services and when not
what is the advantage of doing customization using DataBase services rather than go for wihout DataBase services.?
View 4 Replies
View Related
Aug 1, 2012
I have created a template file but whenever I open and display data in AutoCAD Map 3D 2012 it does not apply to the opened data from Oracle 10g. Infact, it change every time I open the data from database!
Using the symbol in AutoDesk Map 3D 2012. Also note that my database is Oracle 10g.
View 4 Replies
View Related
Apr 3, 2012
setting up Industry Model using Oracle 10g and 11g XE edition. I cant make it working, trouble starts when trying to create MAP 3d System User "MAPSYS" in Industry Model Setup, during user creation(about 68%) error popups" Could not create user MAPSYS"XE: Unable to deploy java package. Does XE version is suitable for Industry Models. Direct connection to Oracle 10g or 11G XE with MAP 3d working for me perfectly.
System I have is: WIN 7 Enterprise( 64 bit), database is Oracle 10g and 11g XE(32bit), client is Oracle 11g R2(administrator),all autodesk software is 2013 versions(64 bit). I tried it also with 2012 software but same result.
View 4 Replies
View Related
Jan 5, 2011
I have been tasked with finding a way to link data from Oracle and SQL databases with CAD files of rooms in certain buildings. My goal is to be able to select an arbitrary room within a building and be able to access certain information. I don't actually have access to the databases yet, but I would like to know how to do this when I do. My data consists of "human" data such as: name, email, position, sex, etc; as wells as "physical" data such as: square footage of the room, who uses it, computer serial numbers, or what department is in charge of it. Using this data we will cross reference the tables to determine what our needs are.
My AutoCAD skills are good but I've never come across anything like this in the class room. Most of my knowledge is Civil based and more focused on design.
View 9 Replies
View Related
Nov 24, 2013
How do I re-install a corrupted Photoshop CC app when the Desk Top CC shows the app as "up to date"?
View 2 Replies
View Related
Sep 3, 2012
I bought Adobe Photoshop Elements 9 but get the following alert: "Some of the application components are missing from the Application directory, Please reinstall the application." Can it be reinstalled? It is not available under "History" and none of the available installs appear to be for Mac OS X (Version 10.7.4). S
View 2 Replies
View Related
Mar 19, 2014
I have PSE9 and a macbook pro 10.9. I lost the original DVD that came with my purchase of PSE. Some files must have gotten corrupted because I can't open the program without reintalling. It says, "Some of the application components are missing from the application directory. Please reinstall the application." I have the serial number and all and I registered the product. Is there somewhere I can download a new copy to install?
View 7 Replies
View Related
Nov 5, 2012
at photoshop cs6 extended downloaded in july, i now get the following message: "some of the application components are missing from the application directory. please reinstall the application."
View 2 Replies
View Related
Aug 20, 2011
Is it possible to take Current User Coordinate System of external Database object, like
Application.DocumentManager.MdiActiveDocument.Editor.CurrentUserCoordinateSystem?
View 7 Replies
View Related
Dec 18, 2012
I'm trying to add a database (excel ) as source for object in Map3D.
I start but when i select the excel file that i've created and stored in my pc map3d says that the cration of the data source doesn't work.
View 7 Replies
View Related
Jun 2, 2011
what is the best way of getting (modified) event triggered for some specific object?
i see a lot of examples doing: if database is modified, then trigger event, then iterate our list to if that object is in it.
is that the better that way, like to add handler to the specific object, and then when each of them is modified, then each of them call handler?
View 3 Replies
View Related
May 31, 2013
Any equivalent ObjectOverrule for the PnId Database?
If an entity is copied I dont want certain field values to be copied.I've tried an ObjectOverrule but I can't get the RowId at that point.
I also noticed that the field values are set as XData. I edited the XData in my ObjectOverrule but the values still gets copied.Is there a setting at project level to control which fields not to copy?
View 1 Replies
View Related
Jun 8, 2012
I am trying to convert several drawings that are linked to an SQL database to SQL spatial. The drawings are from a Autodesk map 2004 system. I have Map D 2013 64Bit installed on a laptop along with SQL server 2012 RC0 (Microsoft SQL Server Management Studio 11.0.1750.32 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 4.0.30319.269 Operating System 6.1.7601).
To keep my rouge laptop off the company network I exported our existing SQL data to a access database that I placed on the laptop and converted back to SQL and linked it to the 2004 drawings. That part worked fine. I would like to convert all of them to SQL spatial. I have converted a small drawing but it took a couple of hours. I am in the process of a larger drawing that has 60,000 entities and it has been working for 8 hours and only has 4550 of them completed. I am using the output to fdo connection.
View 8 Replies
View Related
Mar 27, 2013
As part of the automation requirements we are working on (through the .NET interface), we would like to find out whether a given drawing contains a sphere and if it does we would like to know its properties. We are doing something like this, to loop through the database and am able to get all Solid3d type of objects.
What I would like to know, if a given solid3d object is a sphere or otherwise. The code snippet is pasted here for reference:
bool bContainsSphere = false;
foreach (ObjectId Id in Ids)
{
DBObject oObject = ts.GetObject(Id, OpenMode.ForRead);
if (oObject.GetType().Name == "Solid3d")
[Code] ......
View 8 Replies
View Related
Jun 27, 2011
I want to create an application that intensively uses dynamic blocks, cross checking any new or changed block entity with existing ones.
It needs to be almost instantaneous but the only way I know will be impractical.
Looping through the property collection of each block reference, searching for each parameter then checking for a match.
Is there some sort of database functionality I can use to quickly compare block information?
View 1 Replies
View Related
Sep 17, 2007
I have created a new database: Database newDb = new Database(true, true) Inserted a block into modelspace and now I want to zoom extent before saving.
Can this be done working on a new database in memory? all the examples I have seen on this board use Interop on a open document.
View 9 Replies
View Related
May 10, 2012
How can I link an external database(say access/oracle) to a drawing so that I m able to insert/update attribute directly from the autocad map drawing.
View 1 Replies
View Related
Sep 3, 2012
How i can browse all objects into an autocad database?
View 5 Replies
View Related
Oct 18, 2012
I have a preview control on a window that I want to display temporary custom entities that the user can build before adding to the current working document. Is there a way to create a temporary document and database that I can show in my preview control? The Preview Control was created with the guidance of the BlockView.net sample.
What I mean by temporary, is a document / database that cannot be displayed or edited in the editor window.
View 2 Replies
View Related
Sep 21, 2011
I'm having a problem accessing data manager tables in the 2011 version. My C# .NET code worked fine with 2010. Here is a sample of the 2010 code that works, but returns zero length tables in 2011.
C#
ProjectPartCollection oPP = PlantApplication.CurrentProject.ProjectParts;
PlantProject oPProj = PlantApplication.CurrentProject;
Project oProj = oPP["PnId"];
try
{
//get ACAD data table
[code].......
The last two lines fail to object any meaningful data in 2011. In 2010, I would have all the table rows and could access tags and asset information.
View 2 Replies
View Related
Apr 22, 2013
what's the different between
Dim oDb As Database = HostApplicationServices.WorkingDatabase
and
Dim oDb As Database = Application.DocumentManager.MdiActiveDocument.Database
View 3 Replies
View Related
Aug 17, 2006
I have 1 drawing open, I have another drawings Database open . I have found the LinetypeTableRecord (in the Database) of the line type I want to copy to the open drawing.
How do I copy a LinetypeTableRecord from one drawing to another?
View 8 Replies
View Related
Jun 17, 2011
I'm having a complete blockout on my attempts to create a new material with VB.NET.
Dim db As Database = Application.DocumentManager.MdiActiveDocument.DatabaseDim tm As DBTransMan = db.TransactionManagerDim myT As Transaction' myT = tm.StartTransaction()Dim tt As Autodesk.AutoCAD.DatabaseServices.Material = New Autodesk.AutoCAD.DatabaseServices.Materialtt.Name = "Mat_new"tt.Description = "New Material"myT.AddNewlyCreatedDBObject(tt, True)myT.Commit()
It was noted that this code didn't work (which I can confirm):
"Just a guess, but you probably have to add it to the Database in order to use it."
I can't find any way to add this to the database. I'm working with the R2010 drawing format it that is relevant.
View 6 Replies
View Related
Mar 12, 2012
Can you have a database and the dwg file open at the same time and not be in read-only mode?
For example: I have access database file open and editing it while in the dwg file with the graphical info that is linked to the database.
View 8 Replies
View Related
Feb 23, 2012
i have a point file specifically a PNEZD file. when i import points into the survey database the coordinate in the database is correct but the coordinate on the drawing tends to be 5 feet off one way and 1 foot off the other. When I import point through the points pull-down menu the coordinates are correctly shown. When I import point into survey database from drawing the coordinate is incorrect in the database but correct on screen.
View 3 Replies
View Related
