AutoCAD Map 3D :: Unable To Connect To Excel File Using ODBC FDO Provider
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
ADVERTISEMENT
Feb 26, 2013
To access MYSQL with FDO where should we place de file libmySQL.dll? With MAP its is in the <installation>FDOin directory but how come there is no such directory with Civil?
extract from Map help "If you cannot connect to your MySQL data source, you may see an error message: "Specified credentials are not valid or the provider is unable to establish a connection." To resolve the issue, copy the libmySQL.dll file into the AutoCAD Map 3DFDOin folder and try again."
View 2 Replies
View Related
Jun 21, 2011
I am building a big catalog for hundreds of products, and it would be a life savior if i could connect dynamically the (customized) text (fields) in the .cdr file to an external excel file data. For example smth like the text field "Title" to be taking its values from the column "Description" of the excel file, incrementally as each line of the excel file could represent a record. This way also when the excel file changes, (because it will be probably like 10 more versions before it gets final), the content inside the corel draw file will change automatically as well.
Download sample corel file here :
[URL]....
and sample excel file here :
[URL]....
How to accomplish smth like that or even faster / simpler ......
View 2 Replies
View Related
Apr 12, 2013
I am attempting to import a shape file in Civil 3D 2014 and get an FDO error (see attached). I have performed this task nearly everyday for an entire year in 2012 with the same file, method, etc. I change my workspace to 'Planning and Analysis", select 'Map Import' and select my shape file...error!
View 4 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
May 24, 2013
i'm trying to add a WMS connection to theOpenstreetMap service, but i receive error message "impossibile connect"
I tried several link adresses, but the results still remain the same. I don't use proxy servers.
View 1 Replies
View Related
May 29, 2013
I have AutoCAD 2013 and often "paste special" excel files that automatically update when the excel file changes.The problem I'm running into is I work with a person who has uses an older version of CAD 2004, so I always save to the older format for him.
When I etransmit, I be sure to add the excel file, but when he opens the dwg, only the outline of the excel appears in his dwg, no content.
View 8 Replies
View Related
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
Oct 24, 2011
I have had PSP X3 for sometime but have never been able to connect to my scanner. The options for Twain acquire and Twain Source are dimmed. Everything works fine with PSP X2 but since upgrading I can no longer use my scanner. I've tried to log a question with the knowledge base but for some obscure reason I am unable to get that to work.
View 2 Replies
View Related
Aug 25, 2013
Usually when I bring up Elements 10, it says welcome back Kenny,now when I type in my password it is showing Error 400. I have tried several times to create a new ID.....no luck. It just started doind this last night. What do I need to do?
View 3 Replies
View Related
Aug 26, 2013
I am trying to connect with Adobe Elements 10 on line. Normally when I bring up Elements, it says "Welcome Back Kenny" this is what it says now! Photoshop.com services are currently unavailable. try again, or check your network connections. Error 400. I have never had this happen before. I am for sure on line.
View 7 Replies
View Related
Apr 8, 2011
I just purchased the PSP X3 Ultimate. Installed everything with no issue. Rebooted edited a photo saved it then opened Project Creator to upload it to Facebook. Put in my correct email and password. Yet I get the error of:
Unable to connect Please check your network connection.
the same machine that has PSP/Project Creator there is nothing wrong with my network connection. I've checked my UN/PW for Facebook and my connection and everything is correct.
It appears I can not even connect via PSP to check for updates etc.
View 10 Replies
View Related
Aug 26, 2013
Received the message " unable to connect to editor application". What do I do ?
View 1 Replies
View Related
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
View Related
Jun 11, 2010
I'm trying to export photos to Flickr using the Flickr publish service. When I try to log in to Flickr in order to authenticate my account, I get the error message "Could not contact the Flickr web service. Please check your Internet connection." Similarly, I have tried to use Jeff Friedl's "Export to Flickr" plugin. When I try to enable this plugin, Lightroom can't contact Flickr - I get the error message "cannotconnectToHost", and Lightroom just keeps retrying to connect with no success.
I have Internet access, and can log into Flickr without any problems using my browser.
View 10 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
Sep 6, 2013
I am editing a Postgis table using the OSGeo FDO Provider for PostgreSQL/PostGIS in AutoCAD Map 3D 2012. As i have noticed that the serial type of the ID field does not give an automatic value to de ID field after inserting a new feature in the layer and after checking in (AutoCAD Map seems not to understand de nextval(sequence_name) function in the DEFAULT property of the ID field(thats how the autonumeric numbers work in PostgreSQL)), i am using a database side trigger which gives the next sequence value to the ID field of the new record. The trigger is launched BEFORE inserting a new record.
The problem is that after executing the trigger, in AutoCAD Map all the fields are still shown as null, and they are not displayed until i manually refresh the layer.
Is there any way to auto-refresh the layer after checking in a new feature?
View 2 Replies
View Related
Jan 26, 2011
I'm having problems in exporting a window schedule from ACA 2010 to Excel. I have Excel 2010 installed on my home computer.
when I try to export I get the message that excel application may need to be loaded.
View 1 Replies
View Related
Nov 20, 2012
I'm unable to open or otherwise query an Excel spreadsheet.
I get the following error message. see attached.
What steps must I take to open and query Excel spreadsheets?
I'm using Inventor 2013, Excel 2007 and Vista 64.
Inventor 2012
AutoCAD 2012
Product Design Suite Ultimate 2012, 2013 & 2014
View 1 Replies
View Related
Dec 27, 2011
I'm fairly new to Map 3D and I'm trying to attach either an Excel or Access file as a data source. I started out with a simple test case and created both Excel and Access files following the steps outlined in the first reply in post:
[URL].......
When I get to the drag & drop step to attach the data I get the following error messages:
Invalid Wordspace file format: My DocumentsTEST.xlsx
Invalid Wordspace file format: My DocumentsTEST.accdb
Not to be deterred, I saved the source files back to earlier xls and mdb file versions and was successful at attaching the data in both cases, but Map reported that there were no tables when I tried to define a link template.
View 5 Replies
View Related
Jul 26, 2013
I am trying to insert an Mr Sid file using Data Connect. I am running 2011 C3D. When I try adding the file to the dwg, it tries to execute the query, but then I get an error "There was a problem adding data to map."
The folder containing the SID file has two other files...the .sdw file and the metadata file. Is there another file missing? Or is the SID file too large...it's 1.6GB.
View 3 Replies
View Related
Dec 4, 2012
I am trying to export each sheet in an Excel file to an separateTXT files.
I currently have code to read each cell in a sheet, but unfortunately some of the Excel sheets have in excess of 5000 cells and it is taking too long to read. So I am switching to another method.
The program will check dates of TXT files and XLS file to make sure TXT files are current (if not, open and recreate TXT files).Then read the TXT files (much faster).
Where I am getting stuck is 2 places -
Get the names of each sheet in the excel file (not always a known name)
Save each sheet as separate TXT file.
Here is condensed code so far without error checking, etc -
(defun E2TXT (FileName /)
(if (and (setq XLfile (findfile FileName)) (vl-file-systime XLfile) (setq XLapp (vlax-get-or-create-object "Excel.Application")))
(progn
[Code]....
View 4 Replies
View Related
Dec 6, 2012
I'm linking an excel file to an .ipt file with iLogic code determining if the Material type is a certian value it will find the correct material thickness. These file work great when working on them thru Vault but when I "Save As Template" and create this file where our other template files are located (not Vault) this fuction does not work. I have realized that I had to place the a copy of the excel file in the same file folder as the template ipt, but even this does not fix the issue.
I recieve this error:
Error in rule: Material, in document: Part6
'MWW Materials (Inventor).xlsx' could not be found. Check the spelling of the file name, and verify that the file location is correct.
If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted.
It seems completly countintutive that just saving the file as a template file would cause this not to work when all files that are required are located in the same file folder. Maybe I need a reference to the excel document within the iLogic code.
View 3 Replies
View Related
Aug 4, 2005
i have deleted the excel file from the ipt file but when i open the part file it is still looking for the excel file. i am using inv 10 sp1 and excel 2000
View 7 Replies
View Related
Feb 15, 2012
i have been a long user of romcat... but would like to use the new corel connect. i use the folders selected to my HD folder that has all my cdr files (20yrs worth from ver 1). when i type in a search word that is in 100's of my cdr files keywords... connect doesnt display them. In romcat it does display them, even older files, with the same key word. connect only shows cdr files that have in its file name part of the search word, but seems to ignore the key words in the files.
I have all my job files with important key words within them, but the actual file names are simple job numbered names. i noticed on searches from X5 content on dvd, the files also are just numbers, but the search finds key words.
View 2 Replies
View Related
Jul 11, 2013
When the attached shape file (change soilmu_a_a.txt to .shp) is imported using MAPIMPORT the data aligns with other imported georeferenced raster imagery (said imagery was imported using the MAPIINSERT command). If the same shape file is imported using the data connect tool it shows up in a much different location (see word document).
The drawing coordinate system code is "UTM83-18F" and the data was downloaded from the Web Soil Survey's data download with the identical coordinate system (see attached readme.txt).
I prefer to use the data connect option when importing this type of shape file because I can label them all using a theme and use stylize the data for visualization/presentation.
As an aside, I have found that data connect does not automatically transform data coordinate systems to match your drawing coordinate system as advertised. I've used the edit coordinate system to no avail; however, again when the file is imported using MAPIMPORT and saved as a drawing (with native data coordinate system) and then that drawing is queried from a drawing in a different coordinate system it seems to transform the coordinate system just fine. Is this a problem with data connect?
View 7 Replies
View Related
Jan 12, 2014
it is possible to render to mpeg 2 with specific settings for VOD content cable provider in Premiere Pro?
Is there a specific preset for it? Or do you really need an external plugin (like the very expensive QT plugin from PIXELtools?
For a cable provider I need to make SD content.Encoded some MPG 2 TS test files and uploaded them to the test-environment of the Cable provider.
The calbel provider said the files are almost approved, they need a little more tweaking.
But the cable provider only gives me a list of errors in return. Errors they see in in the testing environment before publishing.
1. Rendered MPG's have PCR errors (deviation in clock frequention)
2. to get better quality encoded MPG's, they say to stretch the GOP.
Since I'm not in to GOP's, M frames and I-pictures.They gave me a white paper with the following rules....
1. The first byte of the video elementary stream MUST be the first byte of a sequence_start_code.
2. The video elementary stream MUST contain an integral number of access units.
3. A Sequence Header and a Sequence Extension MUST precede each I-Picture.
4. All B-Pictures in the video bit stream MUST use prediction based on pictures present in the bit stream. Specifically, the first GOP in the video elementary stream MUST NOT begin with a B-Picture predicted from a reference picture that does not exist in the stream. That is, the first GOP MUST be closed.
5. For MPEG2 encoding, the length of each GOP SHOULD be 12 frames.
6. For MPEG2 encoding, the number of consecutive B-Pictures between anchor pictures (I-Picture or P-Picture) MUST be two or less.
how to set the above requested into the Premiere Pro exportsettings from below (my settings, to make an MPG
View 3 Replies
View Related
Dec 4, 2013
I am working on a flood inundation, I would like to find a lisp or command(i'm not finding) to connect two points with a given elevation following the surface file or surface entities.
here is a small section as example right now it's just guesswork, some of these have taken a week to connect all the sections.
View 7 Replies
View Related
Feb 5, 2014
I had an additional hard drive installed but have not used it yet, but now when I go to Adobe Photoshop 10 organize section and click on a photo, it cannot find the file. I have tried the reconnect segment but it still doesn't work. Each photo has a box with a question mark in it.
View 1 Replies
View Related
Apr 25, 2013
I have create an excel file with a description and a hyperlink.With this way the user is able to open all the file that was able to open in only one excel.So far everything is OK.My problem is this. Have added 3 new lines for 3 different adobe illustrator files.When the user makes a click in the hyperlink open the adobe illustrator but is empty.They don't opening the file that has added in the hyperlink. (It happens only in the .ai files all the other files .pdf - .doc - .jpg opening without any problem)
I use windows XP with SP3 and adobe illustrator CS4
View 5 Replies
View Related
Oct 28, 2011
I have used Paste Special to insert an excel schedule into my AutoCAD drawings. When I try to print to Adobe PDF the excel schedule disappears. When I print to DWG to PDF the schedule is there but the text is really heavy and the file size is extremely large. This is causing a problem when combining PDF drawing sets, the files crash. why when I try to print an excel file to Adobe PDF that the schedules disappear?
View 3 Replies
View Related
