More... Also, can you confirm it didn't close the tunnel when telnet exited? An attempt was made to access a database,
The solidDB SQL Editor (solsql) behavior has been modified so that native error is returned in addition to the SQLState error. With the option to run the Informix service as local system, the database server is started using the Windows local system account, instead of user informix. I know other databases require creation of userids for access, but I have yet to find out how/if informix does this. vBulletin ©2000 - 2016, Jelsoft Enterprises Ltd. http://www.ibm.com/support/docview.wss?uid=swg21660182
jgray 120000P3EU 2015-03-17T21:50:50Z I uninstalled Informix (which was a hasstle because it leaves a lot unremoved), and did a TYPICAL installation. Results 1 to 4 of 4 Thread: Problem trying to connect to Informix Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Please try 'nslookup myhostname', if this doesn't succeed, jdbc connection would have same problem. Which version of Informix ODBC are you using?
For further discussion on this topic, visit this developerWorks forum thread: https://www.ibm.com/developerworks/community/forums/html/topic?id=1cd04237-a9dd-4061-9c38-f9043786691a Related information Type 4 JCC connection String: Document information More support for: DB2 for Linux, UNIX and Windows OTHER Check that you have permission to connect to the server that you specified. Sign up Your way to IBM with CURSORDB2InformixCognosGuardium Events 69. Db2 Error Code Does it show any message like "invalid message received from sqlexec"? -908 is an error that happens when something is wrong at the lower layer (TCP).
Can you check the online.log of your instance at the time you did the connect using telnet? Any suggestions on what might be wrong, or how to debug the failure? 6 images associated with this topic View Images Log in to reply. The desired database server is unavailable, or the network is down or is congested. http://www-01.ibm.com/support/docview.wss?uid=swg21453250 I have been working on this for a few days when time allows and I'm stumped.
In my services file at: c:\WINDOWS\system32\drivers\etc\services, is this added content for Informix: ol_informix1210 9088/tcp dr_informix1210 Learn something new. Errorcode=-4499, Sqlstate=08004 Db2 Can you suggest which manuals to research for this information? Dsra0010e Sql State 08004 Error Code From: epsilon Re: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
Escape character is '^]'. check over here This is the accepted answer. Updated on 2015-07-15T20:15:59Z at 2015-07-15T20:15:59Z by LaiKuen Show: 10 25 50 100 items per page Previous Next Feed for this topic United States English English IBMÂ® Site map IBM IBM When I installed Informix, I used a custom installation, because in the IBM Informix Installation Guide for Windows under "Installing database server to run as local system account", it said: "sqlcode: -1060"
Watson Product Search Search None of the above, continue with my search InfoSphere CDC for Informix terminates with database connection error: The SQL error code is '-908'. It is free to join and you can choose which lists you receive. How to create a company culture that cares about information security? his comment is here From: Fernando Nunes Re: Trouble connecting to IDS 11.5 development server using SQuirrel SQL with IDS JDBC driver.
Note the server name in the current statement. DistroUbuntu Development Release Re: Problem trying to connect to Informix " theory" is like "dreaming", better to really check if the necessary packages are installed (respect the order) into synaptic. Is the Informix server on the same machine?
I am so glad I found this post because I had uninstalled and installed several times and on different computers. I had a typo in the "ssh" port syntax I was trying to use. How to DM a no-equipment start when one character needs something specific? I'd assume the latest in your case, so could you try IP address or FQDN instead of simply GRAYPC2 ? (Assuming the Informix server is listening on port 9088 on the
You will not need any Client SDK stuff. In looking at the "Release notes for IBM Informix JDBC Driver, 4.10.JC4", it says: You must have Java Development Kit (JDK) 1.6 or later installed to use the IBM Informix JDBC For information on setting these environment variables, see the IBM Informix Guide to SQL: Reference. ----- Linux ENV Settings ----- INFORMIXCONRETRY=3 INFORMIXCONTIME=120 INFORMIXDIR=/opt/IBM/informix INFORMIXSERVER=vm_ids_115 INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts.vm_ids_115 $ cat /opt/IBM/informix/etc/sqlhosts.vm_ids_115 #============================================================== #DBSERVER PROTOCOL weblink I am able to use ConnectTest Demo and execute "select * from customer" successfully with the same parameters (server=ol_informix1210, host=GRAYPC2, service=9088, protocol=olsoctcp, database=stores_demo) I am also able to use DBACCESS to
Driver name: IBM Informix JDBC Driver for IBM Informix Dynamic Server Driver version: 4.10.JC4DE Database product name: Informix Dynamic Server SQLWarning: reason(No data) SQLState(02000) vendor code(100) SQLWarning: reason(No data) SQLState(02000) vendor solsql "tcp 1423" dba dba Solid SQL Editor (teletype) v.04.50.0189 (C) Copyright Solid Information Technology Ltd 1993-2010 Error S1000: [Solid][SOLID ODBC Driver][SOLID]SOLID Server Error 14552: Server is in backup server mode, so I added a user/password to the URL and get this now: DriverManager.getConnection("jdbc:informix-sqli://127.0.0.1:9090/stores_demo:INFORMIXSERVER=lo_informix1210;user=informix;password=informix") trying org.postgresql.Driver trying com.informix.jdbc.IfxDriver SQLWarning: reason(Database selected) SQLState(01I04) SQLWarning: reason(Database has transactions) SQLState(01I01) SQLWarning: When I installed Informix, I used a custom installation, because in the IBM Informix Installation Guide for Windows under "Installing database server to run as local system account", it said:
So, as soon as I changed my URL to the ip6 address, the connection works. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the This is the accepted answer. Driver name: IBM Informix JDBC Driver for IBM Informix Dynamic Server Driver version: 4.10.JC4DE Database product name: Informix Dynamic Server SQLWarning: reason(No data) SQLState(02000) vendor code(100) SQLWarning: reason(No data) SQLState(02000) vendor
share|improve this answer answered Mar 20 '15 at 6:40 Jonathan Leffler 557513 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google If you specified both a database server and a database, check to see that you have permission to access the database. If the connection is to a DB2 for z/OS server, database name is the DB2 location name that is defined during installation. How to change log levels for apex tests if statement - short circuit evaluation vs readability Are D&D PDFs sold in multiple versions of different quality?