Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: Cannot connect to IDS 9.3 via JDBC

    Hi guys,
    I have just installed the Informix Dynamic Server 9.3 for Windows. I can connect via dbaccess, but when I am trying to connect via JDBC (jdbc:informix-sqli://127.0.0.1:1526/shadow:INFORMIXSERVER=ol_shadow;user=informix;pass word=informix) I have the following errors:
    java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (ol_shadow) failed.

    at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliCon nect.java:950)
    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 :243)

    at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManag er.getConnection(SQLDriverManager.java:124)

    at net.sourceforge.squirrel_sql.client.mainframe.acti on.OpenConnectionCommand.execute(OpenConnectionCom mand.java:97)

    at net.sourceforge.squirrel_sql.client.mainframe.acti on.ConnectToAliasCommand$SheetHandler.run(ConnectT oAliasCommand.java:368)

    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter. run(TaskExecuter.java:82)
    at java.lang.Thread.run(Thread.java:534)

    Help me please.

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Hi,

    password is one word, your new url would be -

    jdbc:informix-sqli://127.0.0.1:1526/shadow:INFORMIXSERVER=ol_shadow;
    user=informix;password=informix

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •