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!!
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.
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.
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.
I have started a new project and would like to use the database table from a previous project with this one. Basically what I want to do is create a new shape file using the a previous database table so I do not have to create a whole new data base.
I have shp files and an external database file and I wish to merge the data from the External database to the Shp files OD table.They both have a column with entries matching so I figured I could use a Join to complete this. This is where I have run into difficulties.
I tried to import the spreadsheet using FDO but there is no XYZ data its just pure data. I added dummy XYZ data and tried again but I am unable to insert the data. the checkbox is greyed out, I select the Identity property to match the main title and it does not work.
I tried adding a new data source but I am unable to perform a join with this. right way to import the data from the excel sheet and add / merge the data to the FDO table created by the shp file.
I have imported csv files into my database but after closing the database and reopening I cannot import any more files. I can only import the events that I already brought in into the current drawing. Is this a common issue? How do you fix this?
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?
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.?
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.
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.
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.
Turning on / off a shape files layer on viewport, I couldn't figure out why turning off a shape file layer in a particular viewport (attached) does turn it off in all other viewports.
It appears that the Layer Filters functionality is broken again with 2013. Unchecking the "Apply layer filter to layer toolbar" disables the function of layer filters in the tool palette.
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?
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.
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")
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.
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.
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?
