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