I use databasepilot (jbuilder - tool) to connect informix database. databasepilot work with jdbcdriver - ifxjdbc.jar.
informix database is suse 7.2 linux machine.

I can't connect to database
java - errormessage:
java.sql.SQLException: Database not found or no system permission.

at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliCon nect.java)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(NativeConstructorAccessorImpl.java:39)

at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(DelegatingConstructorAccessorImpl.java:27)

at java.lang.reflect.Constructor.newInstance(Construc tor.java:274)

at com.informix.jdbc.IfxDriver.connect(IfxDriver.java )

at java.sql.DriverManager.getConnection(DriverManager .java:512)

at java.sql.DriverManager.getConnection(DriverManager .java:171)

at com.borland.dx.sql.dataset.Database.openConnection (Unknown Source)

at com.borland.jdbcx.metadata.DatabaseInfo.openConnec tion(Unknown Source)

at com.borland.jdbcx.metadata.e****n(Unknown Source)



informix on aix machines work without any problems.
It is linux problem?

Is your Informix database on the linux machine?
Which user is in the connection statement of your jdbc url?
Does this user have CONNECT permissions in the database you want to connect to?
If you are executing it from a different machine, is your machine trusted?
Can you show me the URL?
I 've done this so many times, this must work!

I just checked some cases:
Could you try and set DBPATH=<path-to-db> in your URL.
If this doesn't work could you create a symbolic link to yr database in yr users home directory?

with odbc driver work's everywhere! with jdbc only on aix machine/OS

Is it possible to connect just to the server?
Maybe you shouldn't set informixserver in uppercase.
Best way to test a connection is with user informix.
try:

jdbc:informix-sqli://192.168.1.4:1543:informixserver=tuxinfx_net;user=i nformix;password=<password-of-informix>

I am also finding the same problem can you help me if find the solution
I am using suselinux7.3 ,InformixSE5.0 and jdbcdriver(type-4)
after running the jdbc java program to connect database .jdbc driver is getting loaded successfully ,but it gives the exception that can not find the database server.
thanks in advance
sanjeev

Excuse me, you are working with Informix SE. SE doesn't have the INFORMIXSERVER variable. It uses the DBPATH variable to connect to the correct databases.

sir
with respect your answer i.e instead of INFORMIXSERVER variable DBPATH.
where shall i need to change.

I have attcahed my java program.

I AM USING INFORMIX SERVER SE

This might help you:

A. NETWORK INFORMATION
----------------------

Informix JDBC Driver supports only the TCP/IP protocol, which means
you can connect to SE database servers only through the "setlitcp" or
"sesoctcp" network protocols. Some platforms, such as Solaris, only
support "setlitcp"; other platforms only support "sesoctcp." Check
your SE database server machine notes to verify the network protocol
supported by your platform.

To use the TCP/IP protocol, you must bring up an SE daemon. First
define an SE database server name in the SQLHOSTS file, specifying
either "setlitcp" or "sesoctcp," as shown in the following example:

myserver_tli setlitcp myhost sqlexec

Assume that in the example, "sqlexec" has a port number of 1525. This
information will be used in a later example.

To bring up the SE tlitcp daemon, execute the following command as
the "root" user:

$INFORMIXDIR/lib/sqlexecd myserver_tli -l /tmp/selog_tli

Use the UNIX "ps" command to check whether the SE daemon has been
successfully started.

B. DATABASE DIRECTORIES
-----------------------

INFORMIX-SE database servers can only read from or write to the
local directories on the computer where the SE daemon was started.
This means, for example, that you cannot create a database on an
NFS-mounted directory on the computer where the SE daemon was started.

By default, when you create a database through Informix JDBC Driver,
the driver asks the SE database server to create the database in your
home directory. This means that your home directory cannot be an NFS-
mounted directory.

If you do not want the database to be created in your home directory,
you can specify another directory by using the following syntax
after connecting to the SE database server:

CREATE DATABASE '//server-name/path/database_name';

For example, the following statement creates the database called
MYDB in the directory "/tmp/mydb.dbs" using the SE database server
"myserver_tli":

CREATE DATABASE '//myserver_tli/tmp/mydb';

You can specify this database in a database URL in your Java program,
as shown in the following example:

url = "jdbc:informix-
sqli://myhost:1525//tmp/mydb:informixserver=myserver_tli;user=rdtest;passw ord=test";

hello sir
Thank you very much sir,
I have don the setting as u told, I have got the out put also.
Now i am able connect infromix server from jdbc program .

once again thank you for your help from last 3-4 days

sanjeev