Re: Informix JDBC driver question

Yes, the JDBC driver was the one downloaded from www.intraware.com. I looked under the the release notes (driver directory/doc/release/jdbcrel.txt) to help me connect to the SE database. The URL I used: String url = "jdbc:informix-sqli://myhostname:1525//u3/mt5.0/fms:INFORMIXSERVER=" + "olcnet_se;user=candy;password=mypassword"; I used the IP-address for "myhostname". 1525 is the number in the "services" file for sqlexec (name for the service, could be what ever you choose). The database "fms" is located in the directory /u3/mt5.0 on the host (there's a subdirectory there called fms.dbs). I, too, tried using DBPATH, but then looked in the "jdbcrel.txt" file to help me. Hope this helps! Candy -- Candy McCall ONLINE Computing, Inc. (candym@olcinc.com) -----Original Message----- From: Huw Richards <huw@adsoft.com> To: informix-list@iiug.org <informix-list@iiug.org> Date: Tuesday, September 22, 1998 7:31 AM Subject: Re: Informix JDBC driver question >Hi, > >You say that you're using the "new Informix JDBC driver". Is this version >1.22.JC1 downloaded from www.intraware.com? > >I've been trying to use this to connect to an SE database, but with no luck. >I can connect to the server and retrieve product information, but as soon as >I try a "database x;" I always get an error "database not found or no system >permission". I've tried to pass the DBPATH variable in the url but this >doesn't seem to work! > >Can you post an example of your jdbc connection url so that I can see where >I'm going wrong? > >Huw > > >-- >------------------------------------ >Huw Richards >Advertising Software Limited >Telephone +44 (0) 171 287 4484 >Fax +44 (0) 171 287 4494 >Email huw@adsoft.com > > >Candy McCall wrote in message <6u6mn3$684$1@news.xmission.com>... >> >>I've been successful connecting to an SE database on SCO OpenServer 5.0.4 >>with the new Informix JDBC driver on the client. I've done a simple test >>of connecting and selecting data from the database. Now, I'm trying to >>use it with the IBM Visual Age for Java Data Access Beans version 1.0 and I >>get an SQLException "Read only mode not supported". Has anyone tried using >>VisualAge with the new driver and been successful? I'm using JDK1.1.6 on >>the >>client. Thanks! >> >>Candy >>-- >>Candy McCall >>ONLINE Computing, Inc. >>(candym@olcinc.com) >> >> > > >