SQuirreL SQL Client是否与QODBC兼容？(Is SQuirreL SQL Client compatible with QODBC?)

SQuirreL SQL Client是否与QODBC兼容？(Is SQuirreL SQL Client compatible with QODBC?)

有谁知道SQuirreL SQL Client是否与QODBC兼容？ 如果没有，SQuirreL有一个插件可以启用吗？

任何见解都会受到赞赏，因为我从来没有使用过。

Does anyone know if the SQuirreL SQL Client is compatible with QODBC? If not is there a plugin for SQuirreL to enable so?

Any insight would be appreciated as I have never used either.

最满意答案

使用Java ODBC Bridge产品的QODBC驱动程序示例

注意：以下是我们一位满意客户的示例代码：

// QuickBooks variables Connection con =null; Statement stmt = null; ResultSet rs = null; // parameters for QuickBooks database static final String url = "jdbc:odbc:quickbooks"; // "quickbooks" is a System DSN that is the name of the QODBC driver // On WindowsXP it can be set up at Control Panel > Administrative Tools > // Data Sources (ODBC) static final String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; public static void main(String[] args) throws Exception { InsertCustomers t = new InsertCustomers(); } public InsertCustomers() throws Exception { try { Class.forName(driver); con = DriverManager.getConnection(url); stmt = con.createStatement(); System.out.println("Querying QB customer table"); rs = stmt.executeQuery("SELECT * FROM customer");

An Example of QODBC Driver working with the Java ODBC Bridge Product

Note: Below are some example code from one of our happy customers:

// QuickBooks variables Connection con =null; Statement stmt = null; ResultSet rs = null; // parameters for QuickBooks database static final String url = "jdbc:odbc:quickbooks"; // "quickbooks" is a System DSN that is the name of the QODBC driver // On WindowsXP it can be set up at Control Panel > Administrative Tools > // Data Sources (ODBC) static final String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; public static void main(String[] args) throws Exception { InsertCustomers t = new InsertCustomers(); } public InsertCustomers() throws Exception { try { Class.forName(driver); con = DriverManager.getConnection(url); stmt = con.createStatement(); System.out.println("Querying QB customer table"); rs = stmt.executeQuery("SELECT * FROM customer");