Dear Mark, Thanks a lot for you help. I will follow your suggestion to try.
best regards John --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Hi John, > In answer to your questions... > > --- In [email protected], "bbs_bbp" <bbs_bbp@> wrote: > > > > Dear all, > > > > I am trying to export the 3D ojects in dwg file to oracle database > > and meet with some problems. I could not find the exact answer from > > the maillist. Please give me your suggestion. > > Any comment is much appreciated! > > > > Software: > > Autodesk Civil3D 2007 > > Oracle 10g (remote) > > Oracle 10g client > > WinXP > > FME 2006GB > > > > 1. I noticed FME doesnt work for 2007 dwg format, i have to convert > > 2007 format to old format. Is it true? Any plan to support it? > > FME2006gb doesn't support 2007 DWG format. FME2007 should support it - > I think it may even be in the current beta version since in our > monthly testing sprint it was remarked... "Able to read 2007 and write > to 2004, read 2004 and write 2007, viewer displays 2007 correctly. > Used workbench and translator." > > > > > 2. I want to connect the remote Oracle server, so the parameter i > > used is like: > > destination oracle service: (ip of oracle server) > > x.x.x.x:1521/oracledb > > userid: caduser > > password: xxx > > But I got the following error messages when excuting: > > > > Using Oracle 8 SC Writer Version 1.0 (Nov. 05, 1998) to write tables > > to database `', server type `ORACLE', server name `x.x.x.x.x:1521 > > \oracledb', user name `caduser', password `***' > > Database Writer: Starting at transaction 0 with a transaction > > interval of 500 > > Database Writer: Translation aborted -- rerun > > specifing "ORACLE_1_START_TRANSACTION 0" > > Database Writer: Unable to open database: [SERVERMESSAGE] ORA- 12545: > > Connect failed because target host or object does not exist > > (Vendor Message 1 is: ) (Vendor Message 2 is: ) > > Database Writer: Unable to open database: [SERVERMESSAGE] ORA- 12545: > > Connect failed because target host or object does not exist > > (Vendor Message 1 is: ) (Vendor Message 2 is: ) > > FME Session Duration: 0.5 seconds. > > > > Did I make wrong parameters format or some other reasons? > > I also tried the command from FME ora8list.exe in command line, but > > nothing returns. > > That's a good call to try the ora8list - it shows the problem is in > the connection parameters rather than FME itself. > > A couple of quick suggestions... > > 1. Connect to the database using the Oracle Enterprise Manager. If you > can not do this, there is a problem with the Oracle Client or database. > > 2. Check you have a clean Oracle client installed on the machine. If > several versions of the Oracle Client have been installed and removed > over time, the Oracle client may be corrupt. To fix this, you will > have to uninstall the old client (including orphaned registry > settings), then, reinstall the new client. > > > > Best regards > > John > > Hope this helps > > Mark > > Mark Ireland, Senior Product Specialist > Safe Software Inc. Surrey, BC, CANADA > [EMAIL PROTECTED] http://www.safe.com > Solutions for Spatial Data Translation, Distribution and Access > Join us at the FME Worldwide User Conference Sept. 21-22, 2006 Vancouver BC Canada. For more information, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
