800.682.0200 | FAX: 360.568.2923 |  About Us  |  Downloads  |  Manuals  |  Home  |  Index

 
 Middleware Applications
    JDBC JDBC/ UNIXMiddleMan ODBCODBC for Eloquence ODBC/UNIX OLE DB Provider for Image/Eloquence
   
News  

Press Release: 

JDBC for UNIX

JDBC for Eloquence

JDBC Now 2.0 Compliant

 
Updates  

FREE Evaluation Copy!
(version 3.0.0.3 - July 2, 2008)

JDBC Update


Release Notes

Installation Release Notes

JDBC Manual

 
Product Review  

What is JDBC?

FAQ

 
See Also...

Tracing Facilities

JDBC running on UNIX

Java.jar files

URL Formatting

Using SQL Functions

Sun's Java™ site http://www.javasoft.com. Contains references to the JDK download page, books on Java™, and general Java™ examples.

Information on setting properties can be found at Creating a File DSN (SQLDriverConnect)

 
  
  

  

URL Formatting

Start with this:

String url;
      Class c = Class.forName( "com.minisoft.jdbc.MSJDBCDriver" );
      String hostname = "127.0.0.1";
      String portnum = "30504";

      url = "jdbc:MSJDBC:///";      
      if ( args.length > 1 ) {
            hostname = args[1];
            if ( args.length > 2 ) {
                  portnum = args[2];
            }
            url = "jdbc:MSJDBC://" + hostname + ":" + portnum + "/";
      }

Add this:

      Properties p = new Properties();
      p.put( "Server", "192.168.1.70" );
      p.put( "ServerPort", "30007" );
      p.put( "ServerType", "0" );
      p.put( "User", "MGR" );
      p.put( "UserPassword", "PASSWORD" );
      p.put( "Account", "MINISOFT" );
      p.put( "ImageDatabase0", "MSCARD,DO-ALL,1,5" );
      p.put( "Group", "" );
      
      Connection con = DriverManager.getConnection( url, p );

Or this:

      url = url+"?"
          + "Server=192.168.1.70&"
          + "ServerPort=30007&"
          + "ServerType=0&"
          + "User=MGR&"
          + "UserPassword=PASSWORD&"
          + "Account=MINISOFT&"
          + "ImageDatabase0=MSCARD.NEAL,DO-ALL,1,5&"
          + "Group=&";
      
      Connection con = DriverManager.getConnection( url );

    

 

Minisoft Inc.  1024 First Street Snohomish, WA 98290  Phone: (800) 682-0200  Fax: (360) 568-2923
 Copyright ©2008 Minisoft, Inc.   
License Agreement