ODBC or ado.net connection options
20 October, 2009
I am trying to setup a new connection to our SQL database but am only receiving 2 connection options, no odbc or ado.net. Can you please let me know what I am doing wrong
Yellowfin only supports connections via XML/A and JDBC. You can connect to ODBC via the JdbcOdbc bridge, but it is not recommended. We only use the JdbcOdbc bridge for databases that don't come with a native jdbc driver, such as Lotus Notes and MS Access.
I assume you want to connect to MS SQL Server. We use the net.sourceforge.jtds.jdbc.driver for this.
The URL format is "jdbc:jtds:sqlserver://:/"
I assume you want to connect to MS SQL Server. We use the net.sourceforge.jtds.jdbc.driver for this.
The URL format is "jdbc:jtds:sqlserver://:/"