AutoCAD Map 3D :: 2012 - Refresh Access Database ODBC Connection?
Feb 17, 2012
Here is the Scenario, Win 7, 64 bit, Office 2010, and yes I have installed 64 bit drivers, with Map 2012.
I have an Access Database with Water and Sewer information. I connect thru FDO and every thing is great. I make a change or add something to the Access Data Base and I don't see the change until I disconnect and then re-connect? I was under the assumption that this was a live connection? Is there a way to refresh the connection without having to dis-connect and then re connect?
View 1 Replies
ADVERTISEMENT
Feb 5, 2012
I'm using Windows 7 (64 bit) and I have to connect a file (.mdb) created with Microsoft Access 2007 to my Autocad Map 3D 2011 draw. I uninstalled Office, installed the AccessDatabaseEngine_x64.exe and re-installed Office. Then I followed step by step the process shown in the video here with ODBC but it doesn't worked for me. It says "test connection succeeded" but when I attach the database, it comes up with a red "X" symbol next to it.
View 2 Replies
View Related
Jun 7, 2009
I've been using Photoshop Elements 5.0 for a few years now on my PC running Vista. Beginning just a few days ago (and unconnected to any updates of which I am aware), I started getting an error when I tried to delete or import files in the Organizer. The error says: ODBC data source [Microsoft] [ODBC Microsoft Access Driver] Cannot open database "I". It may not be a database that your application recognizes, or the file may be corrupt. The photos are there - I can see them in Windows Photo Gallery. I can delete photos from there as well. Just not in Organizer. Wondered if anyone might be able to point me in a good direction for a fix?
View 2 Replies
View Related
Jan 9, 2012
I am new at doing a ODBC connection and when I try to connect a database through our central system, this is the error message I got.Failed to cache features.
Failed to execute Fdo command. (2 consecutive occurrences)Table does not exist for class 'dbo:View_DH_UTM_COORDS (2)' (2 consecutive occurrences)
View 2 Replies
View Related
Jun 21, 2012
I've run into a problem with my "Jet.oledb.4" connection string not working for x64 machines. I've done some research and found out a few things, but am still confounded.
The code was written on a x86 XP machine with vb.net 2010 express. AutoCAD will load the dll just fine on x64 machines. Everything will work except the connection to the database. I tried installing the Microsoft Access Database Engine 2010 Redistributable for x64, but couldn't because the MS Office installed is x86!! Instead I installed the x86 version, but got the same unhandled exception at runtime.
Do I need to have the current x86 MS Office uninstalled and then install the x64 version of MS Office on those machines? Is it that the code is compiled as x86? If so, how can I compile to x64? I didn't see any options in settings, and haven't been able to find any examples.
The thing I really don't understand is that the same connection string ( "Jet.oledb.4") works in an old VBA routine on all machines!!
View 3 Replies
View Related
May 23, 2013
I try to connect to Access on x64 operating system from Architecture 2014 (insert Field---DatabaseField). But i get an error:
"[ADODB.Recordset]Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another".
View 1 Replies
View Related
Sep 29, 2011
I'm experimenting with treadsafe progressbar, that would allow me to stop the process.
but for some reason, on this line
Dim _db As Database = AcApp.DocumentManager.MdiActiveDocument.Database
AutoCAD crashes with fatal error This runs on the new thread, so i suppose it has something to do with it, but i have no clue, why this should be a problem.
View 6 Replies
View Related
Oct 1, 2013
My company has an access database that has all of our service data on it. I am currently considering rebuilding the database because it is a database with one table and a million fields. I want to split the database up into separate tables with relationships. All of these tables would be linked based on the same key field Service_ID.
Now here is the hard part. The data would be in a one to many relationship with one record for service info and multiple records per service for pipe info. The data is currently linked to objects in AutoCAD Map 3d 2014 based on the Service_ID key field and a "service" link template.
If i rebuild this database, am I going to lose all of my links? or will i retain the links? Also, is there a way to automatically generate links based on the service_ID field? For instance there are 3 records of pipe information for 1 service. Previously all of these records would be in the same table, but now the tables are split. Since they have the same Service_ID as the Service information, will the links show up?
View 9 Replies
View Related
Aug 2, 2010
I have a program that populates an access database with part parameters. Each Inventor part can look up its own parameter values from the database when supplied with a single parameter, the ID number of the database record. The ID number is derived from a blank part that the program also updates. So in a nut shell, the program populates the blank part's parameters with all database ID numbers that would make up entire assembly. Those parameter values are derived to all the parts in an assembly. This is by far the fastest most efficient way I've found to rapidly generate an entire assembly. In a matter of seconds I can have a new 1000+ part assembly.
The rumor that Inventor will eventually sever ties with VBA has put this whole process in jeopardy. So I have been looking into using iLogic to perform the same task of looking up the data from Access. I know that iLogic has Excel functions built into it, but because the original program is Access based (changes this is not an option) any way to use iLogic to retrieve data from Access.
View 4 Replies
View Related
Nov 23, 2012
I inserted a block from a dwg drawing with the following method:
public static ObjectId InsertBlock(string fileName, Point3d insPoint) { var acadDoc = Application.DocumentManager.MdiActiveDocument; var blockId = default(ObjectId); using (var acadLockDoc = acadDoc.LockDocument()) { var dbTemp = new Database(false, true); dbTemp.ReadDwgFile(fileName, FileShare.Read, false, ""); var blockName = Path.GetFileNameWithoutExtension(fileName);
[code]........
View 3 Replies
View Related
Jul 11, 2012
This is my problem, each material in my cie. have a number code
EX.R069ARS407WLD35460
IT'S POSSIBLE TO LINK MY MATERIALS TO A XML, SQL OR ACCESS DATABASE???
View 1 Replies
View Related
Jun 25, 2012
I'm trying something I believe to be fairly basic: I'm trying to get some base mapping into my Map 3D drawing.
In particular, I need to get the World Street Map found here: [URL] ......
In Map, under Data Connections, I'm using "Add WMS Connection"
I give the connection a name, enter the Server name, and leave Version on "Default version"
I leave username and password blank.
But I always get the error message: "Failed to connect."
Do ESRI and AutoCAD just not play well together?
View 2 Replies
View Related
Oct 22, 2013
I have a problem acessing the fatigue calculation panel in the bolt connections´ tool. Whether I press enable or disable I simply can´t acess it. What should I do to access it?
View 4 Replies
View Related
Aug 22, 2013
Recently our company upgraded to office 365 with Microsoft Access 2013. I cannot seem to connect to this new format using the task manager. We used to use quite an old version, 2003 I think with no worries.
Am I doing something wrong or have the developers missed something quite fundamental to Map 3d?
View 4 Replies
View Related
Nov 9, 2012
I am currently trying to retrieve data from a MS Access Database, we currently have iProperties with number values in them. An outside programmer created a code which takes these values and exports them to an MS Access Database, where they are then translated to mean something.
Instead of exporting those numbers, I want to use them to find what they ACTUALLY mean within the database and bring that information back into iLogic. (ie. 123456 actually means "1/4 Flat Bar Steel")
In short, I wish to access the MS Access database through iLogic in order to read information from it.
I have searched for the better part of 3 hours but have not found a good answer or example code of this situation. I am not that experienced in programming, but have worked with the API before for developing Automated Drawings and have an understanding how to navigate through. If there were to be some example code, I can begin to understand the process quite well through this method as well by seeing how to go about coding this.
View 2 Replies
View Related
Sep 12, 2011
Ive recently upgraded from AutoCAD map 2011 to 2012. But my connection to ArcSDE doesnt seems to work anymore.
My connection is the same as with 2011 using the pe.dll, sde.dll, sg.dll files.
Getting this message:
Unable to establish connection to provider.
FDO Provider entry point function 'CreateConnection' returned NULL.
View 7 Replies
View Related
Sep 10, 2012
When I use the DA to generate a bolted joint that utilizes flat head cap screws (English, 82 deg), the countersunk hole is not large enough and it leaves the heads sticking out slightly proud of the surface. Most of the time when I use FHCS fasteners, the heads must be below flush.
I went into the Clearance.xls file and increased the diameter values for the 82 degree holes. However, it doesn't appear that the DA actually pulls its hole data from this file. I saved the XLS file, closed it, closed IV, retarted IV, deleted the old DA assembly and started over. And I still got the same undersized hole.
However, I did verify that if I just place a HOLE on that point and set the hole as countersunk and clearance for that size of fastener, it will use the hole size that I specified in Clearance.xls.
Inventor 2014 64-bit SP1
Win 7 Pro 64-bit SP1
View 9 Replies
View Related
Nov 17, 2011
I am using Autodesk 3D Map 2012 Enterprise. I used Infrastructure Administrator 2012 to create a File based schema with the required tables and domains. This has created a DWT file and my understanding is if i create a DWG file using this DWT as the template then i should be able to create the features with the attribute details stored in SQLLite. I am also not very clear whether this SQLLite would be embedded within the DWG.
I have an Utility network asset map of a city with OSMM background and Address Layer 2 in UK which i want to transfer to a DWG file created in this template. The source data is a ESRI filegeodatabase format with data held in 30+ featureclasses. I can convert the featureclasses into SHP files.
a)My problem is how can i import the contents of the shapefile into a DWG file created using the template defined using Infrastructure Administrator 2012 above and indicate that the attribute should go to SQLLite or is it something implicitly handled ?
b) It leaves me wondering as why Autodesk is not stressing on the adoption of SDF which is projected as a DWG with relational datatables? What is the intended use of SDF?
View 4 Replies
View Related
Sep 15, 2011
MS Access database that can export Family Tables? Or knows of a 3rd party application that all the type information can be houses in a database, and the family table's TXT is just an export. The family tables we create are nemorus, and lengthly family tabels, and Excel just is not cutting the mustard.
Or would Autodesk ever include this in Revit?
View 5 Replies
View Related
Oct 31, 2011
Ones every three years we have an upgrade of Inventor. In a few months we have an upgrade from Inventor Proffessionel 2009 to Inventor Prof. 2012. Since we often use special materials in our design process we also create/add the new material in the material database. So here's the question; is it possible to copy the material database (special mades) from Inv Pro 2009 to Inv Pro 2012? It would save us a lot of work!
View 4 Replies
View Related
Apr 20, 2012
I have an excel spreadsheet of boreholes. The spreadsheet has the format of ID, X, Y, Z
I have tried using the 'Connect to Data' feature in Map 3D 2012 64 bit.
The ODBC connection is created and tests correctly. After connecting to the ODBC DSN and loggin in, I am able to see the fields identified in the excel file. There is also the Class available from the named range in the excel spreadsheet.
I select my Identity Property, X, Y, and Z - but that's as far as I can go. I have no opportunity to set the coordinate system and the 'connect' button does not activate.
Using Win 7 64 bit - and I have the 64 bit ODBC driver's installed.
View 9 Replies
View Related
Dec 11, 2013
I have a Shapefile layer added to the map via FDO. I joined it to a SQL Server based table via ODBC. I can see all the data (shapefile & ODBC table) correctly in the attribute table, but when comes time to "Query to Filter Data...", only fields in the Shapefile are available and displayed in the Filter dialogue. I want to be able to Filter using fields in the joined. If I export that same Shapefile to an SDF and THEN try the same join and filter, all the fields from the SDF as well as the joined ODBC table are available in the filter dialogue.
View 8 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
Apr 26, 2012
Just loaded 2013. Of course right away I get an error. "Internet access is required to access the Help" Well as you can see I have internet access.
View 4 Replies
View Related
Nov 26, 2013
My code mirrors a selection by either the x-axis or the y-axis. It is working fine. Except, the drawing shows the result, when I move my cursor to the active dwg.
How can I refresh my drawing, direct after modification of a block? I use the code below to mirror a selected block by a button on a docking pallette:
private void btn_Vertical_Mirror_Click(object sender, EventArgs e){(new Modifikation()).Mirror("v");}
the code, which is called is:
public void Mirror(String axis = ""){//---------------------------------------------------------------------------------------------------------------------------------------Document dwg = Application.DocumentManager.MdiActiveDocument;Database db = dwg.Database;Editor edt = dwg.Editor;//---------------------------------------------------------------------------------------------------------------------------------------try{Auto
[code].......
View 6 Replies
View Related
Dec 18, 2013
When I start AutoCad and also if I try to select the Refresh icon on the Pallett, I get a pop up that says "There was an error while refreshing. The palette could not be refreshed" Could there be a path that is broken, if so where would it be?
View 2 Replies
View Related
Oct 2, 2013
I search for a file in Vault 2014 and find it needs refreshing i.e. the double red arrows icon in "Vault Status" column. I hit the refresh button in the ribbon and the file still has the double red arrows icon and doesn't appear to refresh.
Inventor 2014?
View 1 Replies
View Related
Dec 10, 2011
I am trying to make a simple app using .NET classes.
I made a simple Windows.Form in which are check boxes (on for each layer of the CAD drawing).
Just to set the visibility of each layer. Everything is working fine, but I have a little problem with refreshing a drawing.
Changes of visibility settings are applied after a form is closed.
I need the drawing to be refreshed after every check box check change.
I enclose a method with handles check boxes changes.
private void LayerCheckedChanged(object sender, EventArgs e)
{
CheckBox s = sender as CheckBox;
[Code].....
View 6 Replies
View Related
Dec 4, 2012
is there way to refresh sheet of drawing when an iProperty is changed trough API? When I change for example revision Number, the sheet still show old number. The value is changed, because if I open the iProperty dialog, there is new value and also when iProperty dialog is close then the sheet (title block with this property) is immediately correctly updated. I know that I can use ActiveSheet.Update method, but this update whole sheet and it take long time. There nust be something better because dialog iProperty doesnot update whole sheet and it is vvery quick.
Dim oISI As Inventor.PropertySetDim oDrw As Inventor.DrawingDocumentSet oDrw = ThisApplication.ActiveDocumentSet oISI = oDrw.PropertySets.Item("Inventor Summary Information")oISI.Item("Revision Number").Value = "test"oDrw.ActiveSheet.Update ' I would like to replace this line, this take long time
[URL]
View 3 Replies
View Related
Jul 26, 2012
I haven't done this in several years, and my notes are apparently incomplete. Enclosed is an image of the type of ordinate dimensioning that I want, and also my faulty notes. Maybe someone here can add the missing pieces. When I follow my notes, for some reason the UCS is displayed, whereas in the past it wasn't. I am using Version 2000 if it matters.
Notes: Tools/New UCS/Origin this yields small selection square select top right hand corner, for the zero point, then from the Tool Bar: Dimension/Ordinate, to mark the corner with zeroes.Image00256.jpg
View 1 Replies
View Related
Feb 8, 2011
Anyway, I just updated to the Factory Design Suite Advanced package for 2011 which, of course, includes Inventor. I have downloaded and installed all updates, service packs and hotfixes I could find btw. What happens is I'll be working in Inventor on a solid model of ANY size (even a single part) and with absolutely no warning, the display window will freeze up and won't refresh. What's really weird though is that Inventor itself is not locked up. I can click on any of the buttons or any of the items shown in the browser as though the program's running normally. I can check the task manager and it shows Inventor to be running normally. The memory status bar in Inventor shows lots of available memory. I can even hover over the display window in the area where the view steering wheel is located and the icon will change appearance as though it's working normally. I can even save the file. If I close the file, it responds like normal and goes back to the default screen. If I try to open ANY file after that, however, the screen will not refresh or show me the file I opened, even though everything else works fine and the program isn't frozen. The only way to restore full function is to completely close and reopen Inventor (on average I have to do this about once an hour). Btw, I'm also working in a local directory stored on my hard drive, not a network.
My first inkling is that it's a graphics issue but I have played with all the display settings to no avail. I ran a diagnostic on the video card and Inventor says that I'm running an Autodesk Certified driver. All the specs are within reason I think.
My workstation specs:
Dell Precision M4500 laptop
Intel core i7 processor, 2.67 GHz
4 GB RAM
Windows XP Professional SP3, 32-bit, running in 3 GB mode
NVIDIA Quadro FX 1800M, 1 GB graphics card (just updated the driver too...no change)
230 GB hard drive, 136 GB free space
View 5 Replies
View Related
