AutoCAD Map 3D :: Layer Files And Oracle Database
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
ADVERTISEMENT
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
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
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
Sep 26, 2013
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.
View 1 Replies
View Related
Oct 25, 2011
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.
View 3 Replies
View Related
Apr 25, 2013
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?
C3D2012 SP2
Win7
View 2 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
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
Apr 2, 2013
Automator script to backup Smoke 2013 database and other vital files? If not, where could I find a list of those files?
View 5 Replies
View Related
Mar 3, 2014
Here's the text:
1. Should Media Cache Files and Media Cache Database be in separate folders? Does it matter?
2. Can I open an "in progress' project from P Pro CS4 with CC P Pro and continue editing?
View 2 Replies
View Related
Nov 29, 2013
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.
View 5 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
Feb 20, 2013
Is there a way to identify the files with a non-standard layer convention? Once identified and located,I plan to clean up manually
The folder I'm working with contains thousands of DWGs and I've discovered some layer names which differ from our standard naming conventions.
View 5 Replies
View Related
Aug 1, 2012
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.
View 5 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
