Again... Technote (troubleshooting) Problem(Abstract) You try to connect or select a database but you see errors 387 and 111. Read 19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... I use the command E:\mydb\Informix\bin>dbexport -ss -o c:\mydb mydb and I get a -387 - No connect permission. -111 - ISAM error: no record found. (I've created the directory c:\mydb before, weblink
I have been assigned the task to perfom an Informix databse data dump, for backup purpose and replication. So your import statement would look like: dbimport -c -i c:\mydb mydbcopy Fred Prose Reply With Quote 09-15-06,08:29 #11 snichele View Profile View Forum Posts Registered User Join Date Sep 2006 Read 17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Read 28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"...
So I beg an experienced administrator for help ! Informix Dynamic Server Version 9.21 UC4 we are using to store the data. Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... CLOSE databasename; DROP DATABASE databasename; SQL!
As a side note, don't worry about the term BDD, it's just a localized accronym for 'database'. Something I appeared to be forgotten because initially I stated that the server could be in on-line mode for dbexport. But if we want to create a Table with "ttaad4230m000" it doesn´t work. usage of dbimport, dbaccess etc. (even some things in French, if that's what your native language is...) http://www-306.ibm.com/software/data...ary/ids_9.html Hans Last edited by Tyveleyn; 09-16-06 at 05:50.
Reply With Quote 09-16-06,05:46 #12 Tyveleyn View Profile View Forum Posts Registered User Join Date Aug 2006 Location The Netherlands Posts 248 You could try this entry in your script: Code: The problem is that there is absolutely NO ONE (including me) experimented with Informix who knows how to do this. Read 6 Feb 12 - PRLOG - Informix port delivers unlimited database scalability for popular SaaS application ... Even if i want to create a table the error "Cannot create table ttccom010 (error 26572)" appeared in the Baan Session.
Programmer's Town »Databases »dbexport - No connect permission??? Connect to the database as a DBA user, informix, or the user who created the database. 2. Again, thanks for your help, sne. sqlerrm(sysusers) DSN:informix:host=test;service=3001;database=sysadmin;protocol=onsoctcp;server=ol_test Also I am not able to connect through ODBC in Control Panel -> Administrative Tools to this database.
Finance - IBM and Cable&Wireless Worldwide Announce UK Smart Energy Cloud... have a peek at these guys man is for UNIX. Creating dbspaces, logical logs all is possible as informix. United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search.
So, I think i didn't gave enough informations, so let's clarify some points. So restore to the same IDS will work fine, for replication to another IDS it must be a copy of the source server. First of all, you can't re-import mydb and call it mydbcopy without tricking dbimport. http://colvertgroup.com/informix-error/informix-error-log.php What did I missed ?
Really it does not have rights for basis outswapping?dbexport does normal , i.e. Jump to forum: .NET .NET GUI ASP.NET ATL/WTL C/C++ C/C++ Applied COM/DCOM/ActiveX Delphi & Builder Java MFC Qt Unix Visual Basic WIN API XML / SOAP Declarative programming Dynamic languages Tools To start viewing messages, select the forum that you want to visit from the selection below.
Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Regards Reply With Quote 09-08-06,10:50 #3 snichele View Profile View Forum Posts Registered User Join Date Sep 2006 Posts 5 perfect ! To push three known keys consoles Ctr-Alt_Del and to look on the screen2.
Also i can make an odbc-connection to the database. Read 20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Given your file structure in the example you will need to: 1. http://colvertgroup.com/informix-error/informix-error-951.php Reply With Quote 09-14-06,17:22 #10 fprose View Profile View Forum Posts Registered User Join Date Apr 2003 Location Phoenix, AZ Posts 177 Regarding your import.
Another, and possible better, way to dump on-line data with more options but also more configuration necessary is to use ON-Archive, but I'm not familiar with that. grant connect to username username - name of user trying to connect to the database. Reply With Quote 09-08-06,11:16 #4 Tyveleyn View Profile View Forum Posts Registered User Join Date Aug 2006 Location The Netherlands Posts 248 Are you logged in as a DBA? Additional question: how to learn a name of the current user in the console?I mean, when the server only is launched, without coming in dbaccess. 6 Reply by Zhuravlyov Denis 2012-06-21
What is in the configs that is telling dbaccess to do this? And since at home I'm the only one using the database I only work in single user mode... Reply With Quote 09-11-06,07:00 #7 Tyveleyn View Profile View Forum Posts Registered User Join Date Aug 2006 Location The Netherlands Posts 248 Can you tell me what the %username% is after jclju125th October 2002, 09:26There are two Unix variables, INFORMIXSERVER and INFORMIXDIR.
Re: connection to informix 11.7 windows local syst (views: 576)PRAJAKTA CHIKHALE -- Tuesday, 17 July 2012, at 8:22 a.m. [ View Thread ] [ Post Response ] [ Return to Index As I said, I would use account 'informix' for at time of installation in NT this account is created as a member of the 'administrators' group and automatically gets dba privileges Can anybody help us??? So I suppose I must drop the database db2 before importing datas ?
BTW, it's mentionned in the faqs that Dynamic Server doesn't use the DBTEMP var to choose his 'temp' directory anymore, but it's not specified WHAT directory it then use as a Read Previous news items End of Support Dates IDS 11.10 - 30 Sep 2012 Subscribe to notifications a> Home Member Area About IIUG Help Resources IIUG Insider IIUG Hotspots Informix Links What I try ---------- I launch an informix console that set the env vars for mydbtest. Regards Reply With Quote 09-11-06,15:21 #8 Tyveleyn View Profile View Forum Posts Registered User Join Date Aug 2006 Location The Netherlands Posts 248 Hi, I just looked at your last post
Further, I come into OS as Administrator, this name is presentIn group Informix-Admin. The time now is 17:43. Still if I allow it to create informix account will it allow me to access database when looged in as other user. reads the data from tables, and at the manager of wasps, such rights are not present, and should not be.
Once the replication database(s) is (are) defined you can make an on-line IDS dump with Code: ontape -s -L 0 and restore off-line to IDS with Code: ontape -r For 'ontape' So, many thanks for your advices. Read 28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm...