| Products | Minisoft News | Events | Downloads | Product Manuals
 
  News

Minisoft Releases PCI Compliant Versions of ODBC, JDBC, and OLE DB

Demo and Updates


FREE Demo! - Click Here

Update Registration

Documentation


Release Notes

Installation Release Notes

JDBC Manual

FAQ

Product Review


What is JDBC?

Brochure -
"Minisoft PCI Compliant"

Tracing Facilities

Java.jar files

URL Formatting

Using SQL Functions

JDBC for UNIX

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)

 
   

UNIX

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 );