Home > Informix Error > Informix Error 387 No Connect Permission

Informix Error 387 No Connect Permission

Read 19 May 10 - The New Blog Times - Misurare il consumo energetico: DEHEMS è pronto... Read 27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Will changing password deny access to database for informix also ? 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 have a peek at these guys

Reset the password of the database user first, then use the $BSE/bin/inf_admin6.1 utility to update the $BSE/lib/inf_groups file. Does the problem exist for all versions of 11.7 or will installing 11.7x4 work ? Where the 'SQL!' keyword is just a label that marks the beginning of the statementlist and must be repeated on a newline at the end. Re: connection to informix 11.7 windows local syst (views: 619)FRANK J.

Read 19 May 10 - ZDNet - IBM software in your home? 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. I choose the db [email protected] I am connected.

  1. 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
  2. Is not present unambiguouslyMake you will not understand yetgrant connect to public; 9 Reply by vasilis 2012-06-21 17:11:30 vasilis Member Offline Registered: 2012-05-06 Posts: 2,063 Re: dbexport - No connect permission???
  3. Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh...
  4. We have installed an new Baan Server on a sun primepower.
  5. Something I appeared to be forgotten because initially I stated that the server could be in on-line mode for dbexport.
  6. Further, I come into OS as Administrator, this name is presentIn group Informix-Admin.
  7. thanks !

Cause The user trying to connect does not have connect privilege for this database. At attempt of export of basis produces an error- 387 - No connect permission.- 111 - ISAM error: no record found.In what a problem? 2 Reply by Andron 2012-06-21 09:27:28 Andron Read 31 May 11 - Smart Grid - The meter data management pitfall utilities are overlooking... Read 8 Jul 11 - Database Trends and Applications - Managing Time Series Data with Informix...

Maybe you can get error explanation with: finderr 25572. Contact your Database administrator and make sure connect permission is granted for the database user that the baan login is using. Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... to AndronWith English at me everything is all right.

reads the data from tables, and at the manager of wasps, such rights are not present, and should not be. This information must be in tabledef6.1 or Unix variable must be set. foster25th October 2002, 08:21Thanks for your answers! Using the same drivers I am able to connect to other databases on Linux systems.

Both the servers can be on-line for this. http://comunidad.siu.edu.ar/foro/index.php?topic=7051.0 But db2, so as db1 and db3, is accessed by a J2EE application without any problem, and I can launch a 'dbaccess' on it without any problem. Forum New Posts Today's Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders dBforums Database Server Software Informix Data Import / Export If this is your first dbexport , .. , , , . su, . 9

To get a (textfile) dump of a complete database, including schema, for migration to another server/OS probably the 'dbexport' and 'dbimport' utilities are the simplest. http://renderq.net/informix-error/informix-error-271.php But when I log in as local system account, sysmaster (many times) and always sysadmin database does not get built. Index Register Login You are not logged in. 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 =

Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... jclju125th October 2002, 09:02Informix error 25572 (26572 –1000) means »Network driver cannot bind a name to the port«. It should not be 'administrator' unless that account has dba privleges granted. check my blog If it is necessary to learn from the command file or the program that to look a variable of surrounding USERNAMEset user 10 Reply by vasilis 2012-06-21 17:31:30 vasilis Member Offline

Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 13 ] 1 Topic by junior 2012-06-21 09:14:27 junior Member Offline Registered: 2003-11-02 Posts: 541 Please login or register. BUT I have an error when importing, talking about "duplicate unique key".

I'm not familiar with the term BDD, my Windows experience with Informix is limited to IDS (Informix Dynamic Server) 7.3 on WinNT4.

Read 2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... The user of a DBMS means for Informix' is a user of OS? (Except Connect from dbAccess)And to come into a DBMS under user Informix it is necessary to make Log Read 09 Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. I hope it will help.

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? Read 10 February 2010 - The Wall Street Journal - International Business Machines is expanding an initiative to win over students and professors on its products. 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 http://renderq.net/informix-error/informix-error-329.php 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.

JDBC connectivity also not possible. Read 20 Jul 10 - IBM Announcements - Software withdrawal: Elite Support for Informix Ultimate-C Edition... Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... So restore to the same IDS will work fine, for replication to another IDS it must be a copy of the source server.

What did I missed ? The time now is 17:43. that we have often checked. foster25th October 2002, 09:33This is an entry from our tabledef6.1: *:*:informix(INFORMIXDIR=/informix,INFORMIXSERVER=ol_wibro,ONCONFIG=onconfig):N And this are the settings in /etc/profile: INFORMIXDIR=/informix INFORMIXSERVER=ol_wibro ONCONFIG=onconfig SQLEXEC=/informix/lib/sqlrm INFORMIXSQLHOSTS=/informix/etc/sqlhosts DBMONEY=.

To start viewing messages, select the forum that you want to visit from the selection below. You cannot access the database that this statement requests because you have not been granted CONNECT privilege to it. what did I missed ? The problem with OAT, ODBC, JDBC connectivity exists even when logged as informix.

To push three known keys consoles Ctr-Alt_Del and to look on the screen2. 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 I think the 'ontape' utility is the easiest way of performing a complete datadump, including logical logs, of data managed by a server. That looks good.

Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility Whats New in 12.10 Certified for Informix 11.10, 11.50, 11.70 and Watson Product Search Search None of the above, continue with my search Trying to connect to a database but see errors 387 and 111. Hi folks. Read 3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency...

Grts Reply With Quote 09-08-06,14:19 #5 fprose View Profile View Forum Posts Registered User Join Date Apr 2003 Location Phoenix, AZ Posts 177 You didn't give it the database name you And I don't know if the [email protected] syntax is correct in this case; try, on the Belgacom host, Code: dbexport -cc -o C:\belgacom belgacom and before that, create directory C:\belgacom. Disconnected. export INFORMIXDIR INFORMIXSERVER ONCONFIG SQLEXEC DBMONEY INFORMIXSQLHOSTS The variables must be correct.

© Copyright 2017 renderq.net. All rights reserved.