Home > Informix Error > Informix Error 387 No Connect Permission

Informix Error 387 No Connect Permission

thanks ! Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... rename c:\mydb\mydb.exp\mydb.sql to c:\mydb\mydbcopy.exp\mydbcopy.sql Second, you need to be pointing to the directory that the export directory (xxx.exp) is in. 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? navigate here

Really it does not have rights for basis outswapping?dbexport does normal , i.e. You cannot access the database that this statement requests because you have not been granted CONNECT privilege to it. Read Previous news items End of Support Dates IDS 11.10 - 30 Sep 2012 Subscribe to notifications Home Member Area About IIUG Help Resources IIUG Insider IIUG Hotspots Informix Links Here something another. http://www-01.ibm.com/support/docview.wss?uid=swg21424400

Since this task is of medium priority, and since I'm currently overbooked with other of highest priority, I try to avoid by all means an expensive try/catch error experimentation. SQLSTATE=HY000, SQLDriverConnect: -387 [Informix][Informix ODBC Driver][Informix]No connect permission. I made several signifiant progress and dbexport works now. I'm not familiar with the term BDD, my Windows experience with Informix is limited to IDS (Informix Dynamic Server) 7.3 on WinNT4.

  1. Resolving the problem 1.
  2. His goal is to replicate a DB (db1) datas into ànother DB (db2).
  3. Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe?
  4. The problem is that there is absolutely NO ONE (including me) experimented with Informix who knows how to do this.
  5. My mistake !
  6. Read 16 May 11 - Business Wire - HiT Software Announces DBMoto for Enterprise Integration, Adds Informix.
  7. Por favor, ingresa o regístrate. 1 Hora 1 Día 1 Semana 1 Mes Siempre Ingresar con nombre de usuario, contraseña y duración de la sesión Noticias: Bienvenidos al foro de
  8. So if I wanted to replicate a database to another machine where IDS was already installed I would use on UNIX Code: dbexport -ss -o filename database or: dbexport -ss -t
  9. Programmer's Town »Databases »dbexport - No connect permission???
  10. I have been assigned the task to perfom an Informix databse data dump, for backup purpose and replication.

Read 10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. dbexport - No connect permission??? Typical install installs it to C:\ where I do not have enough space. In the Linux environment I work with it happens every night on a replication server but then it's in single user mode of course.

Environment ------------ I have an informix BDD, named 'mydbtest', on a windows 2000 server. Put this in a .sql file (or generate however you want : > cat aa.sql CONNECT to "@someserver" user "someuser" USING "somepassword"; database sysmaster; select current from systables where tabid = Problem in ignorance of English language :-)No coonect permission - there are no rights to connection to basis etc. 3 Reply by Zhuravlyov Denis 2012-06-21 09:32:28 Zhuravlyov Denis Member Offline Registered: Apparently the way you tried to perform dbexport was the right one because from your error output I make up that you got connected but the database needed to be in

Creating additional user informix in Windows wastes lots of space for My Documents and other unwanted stuff. At me Win2000 AdvServ.1. man is for UNIX. But these has no effect to the error.

Read 9 Jan 12 - planetIDS.com - DNS impact on Informix / Impacto do DNS no Informix... jclju125th October 2002, 08:42Connect to Informix - dbaccess (I think you must be user informix on OS) and execute command: grant resource to username for Baan user. Database selected. (expression) 2009-03-02 12:10:11.607 1 row(s) retrieved. Now, when I try dbimport -c -i c:\mydb\mydb.exp mydbcopy I get a 'could not find the sql file' I tried dbimport -c -i c:\mydb\mydb.exp\mydb mydbcopy added '.sql' to the file with

United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search. check over here We have installed an new Baan Server on a sun primepower. 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 With Code: dbimport -c -i filename database or: dbimport -c -t tapedevicename -b blocksize(KB) -s tapesize(KB) database the database can be created on the second (UNIX) machine.

Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Having DBA in all instances, is there a way to get access to this instance without the password? Thanks in advance for your wisdom, and pardon my bad english, sne. his comment is here So...

CLOSE databasename; DROP DATABASE databasename; SQL! If it's just a backup you want you still should consider 'ontape'; writing definitely can be done while the database is in concurrent state. Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?...

For many of the options like Logs -> Admin Command History Space Administration -> Storage SQL ToolBox -> Schema Browser Following error is seen : Connection Failed.

I just want to select from the passworded instance from my script that will be used by other users who will not know the password or much else really. Login into Baan is possible. Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... I'm logged as 'administrator' on this server.

What did I missed ? What is in the configs that is telling dbaccess to do this? The time now is 17:43. weblink So restore to the same IDS will work fine, for replication to another IDS it must be a copy of the source server.