RE: [Squirrel-sql-users] Additional database connections

[Colin B. <Col...@as...>]

Thanks for this Ken. I'll put it in the default drivers file for the next
version.

Col

-----Original Message-----
From: Ken Arway [mailto:ka...@wo...]
Sent: Monday, 8 April 2002 7:58
To: squ...@li...
Subject: [Squirrel-sql-users] Additional database connections


  Thought you'd be interested in having the connection info for the
following databases:

Sybase
	1. Adaptive Server Anywhere (ASA) -- their personal/workgroup RDBMS
	jarFileName:  jconn2.jar
	driverClassName:  com.sybase.jdbc2.jdbc.SybDriver
            name:  ASA
            url:  jdbc:sybase:Tds:{host}:{port}?ServiceName={DBNAME}
            (Note:  The default port is 2638.)
	I've used this to connect to a local server.  Works great.

	2. Adaptive Server Enterprise (ASE) -- their enterprise RDBMS
	According to the Sybase docs, the same driver is used but the URL
changes.
Therefore,
	jarFileName:  jconn2.jar
	driverClassName:  com.sybase.jdbc2.jdbc.SybDriver
            name:  ASE
            url:  jdbc:sybase:Tds:{host}:{port}/{DBNAME}
            should work.  I have NOT tested this however, since I don't have
access to an ASE server.

IBM DB2 UDB 7.x
	jarFileName:  db2java.zip
	driverClassName:  COM.ibm.db2.jdbc.app.DB2Driver
	name:  DB2
            url:  jdbc:db2:{database}
	I've used this to connect to a local server.  Works great.

______________________________________
Ken Arway
Arway Consulting


_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users