Hi Rafael.

Probably you get -908 error.

-908 Attempt to connect to database server (servername) failed.

The program or application is trying to access another database server
but has failed. Note the server name in the current statement.

Make sure the following.

Server:
Have you run TCP mode ?
In your sqlhosts should be specified as bellow.
<INFORMIXSERVER> ontlitcp <YOUR HOSTNAME> <SERVICE NAME>

Client:
Have you tested iLogin and DBping ?
In your setnet32 is specified as same as Server without protcol ?
Protocol is an onsoctcp.

HTH.

--
Tsutomu Ogiwara from Tokyo Japan.
ICQ#:168106592





>From: rafapadilla@yahoo.com (Rafael Padilla)
>Reply-To: rafapadilla@yahoo.com (Rafael Padilla)
>To: informix-list@iiug.org
>Subject: JDBC Simple Connection Problem
>Date: 10 Jul 2003 11:19:06 -0700
>
>Hi all,
>I'm newbie IN JDBC, I'm just trying to run a stores7 demo Java
>program, bundled with JDBC. I want to test a connection, but it sends
>me this error..
>
>Could not connect to the database!!
>com.informix.asf.IfxASFException: Attempt to connect to database
>server (on_testtcp) failed.
>
>This is between a SUN machine like Informix Server and a PC client
>with JDBC 2.2.1 and J2sdk1.4.1
>
>My database server already exists
>I can connect through SQL Editor to my INFORMIX SERVER
>I sent this URL in that html page with correct parameters:
>jdbc:informix-sqli://10.10.2.3:2501/dbtest:INFORMIXSERVER=on_testtcp;user=informix;pas sword=ifx
>
>
>Any ideas?

__________________________________________________ _______________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

sending to informix-list

Thanks for you adivice...

Yes buddy,

In Server:
I already have in SQLHOSTS file a tcp configuration

In Client:
I tested dbping and ilogin, they worked fine...
and setnet32 has onsoctcp configured...

So I think JDBC for INFORMIX needs some extra configuration in Windows
Do you have steps to guide me with this configuration?
I realized that you have helped some people...



If this helps you...

I made this...
I put some lines in java program to review if driver is loaded and it
was successful.

In my PC...
I have Windows 2000 profesional.
JDBC 2.2.1
J2SDK1.4.2 with JRE

Thanks for you attention



"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:<bel9v6$ek5$1@terabinaries.xmission.com>...
> Hi Rafael.
>
> Probably you get -908 error.
>
> -908 Attempt to connect to database server (servername) failed.
>
> The program or application is trying to access another database server
> but has failed. Note the server name in the current statement.
>
> Make sure the following.
>
> Server:
> Have you run TCP mode ?
> In your sqlhosts should be specified as bellow.
> <INFORMIXSERVER> ontlitcp <YOUR HOSTNAME> <SERVICE NAME>
>
> Client:
> Have you tested iLogin and DBping ?
> In your setnet32 is specified as same as Server without protcol ?
> Protocol is an onsoctcp.
>
> HTH.
>
> --
> Tsutomu Ogiwara from Tokyo Japan.
> ICQ#:168106592
>
>
>
>
>
> >From: rafapadilla@yahoo.com (Rafael Padilla)
> >Reply-To: rafapadilla@yahoo.com (Rafael Padilla)
> >To: informix-list@iiug.org
> >Subject: JDBC Simple Connection Problem
> >Date: 10 Jul 2003 11:19:06 -0700
> >
> >Hi all,
> >I'm newbie IN JDBC, I'm just trying to run a stores7 demo Java
> >program, bundled with JDBC. I want to test a connection, but it sends
> >me this error..
> >
> >Could not connect to the database!!
> >com.informix.asf.IfxASFException: Attempt to connect to database
> >server (on_testtcp) failed.
> >
> >This is between a SUN machine like Informix Server and a PC client
> >with JDBC 2.2.1 and J2sdk1.4.1
> >
> >My database server already exists
> >I can connect through SQL Editor to my INFORMIX SERVER
> >I sent this URL in that html page with correct parameters:
> >jdbc:informix-sqli://10.10.2.3:2501/dbtest:INFORMIXSERVER=on_testtcp;user=informix;pas sword=ifx
> >
> >
> >Any ideas?
>
> __________________________________________________ _______________
> The new MSN 8: advanced junk mail protection and 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> sending to informix-list