FreeTDS Development Group

["Pickett, David" <David.Pickett AT phlx.com>]

Vitaly,

I am running SQuirreL SQL as a standalone JAVA app on Solaris 2.8 to test
freeTDS, which I build from stable source using my usual GNU and Sun pieces
with very little hassle, as myself with my own prefix dir, not as root for
default dirs.  SQuirreL is , of course, a JDBC client, but it has a handy
JDBC bridge for ODBC drivers.  SQuirreL works fine with the MS JDBC jars, of
course, so it's not a primary objective to use this in the final
configuration, but merely to use it to test the ODBC driver.  It's good to
have alternatives!

In the end, I want to use it as a Cognos 7 source under unixODBC in an
ODBC-only config.  Cognos has this half-MS half UNIX nature, where you
develop on Windows and deploy to UNIX, and so seem to need mirror image data
sources in both worlds to update reports.  Cognos does have some
database-specific knowledge, so it may have more savvy about extracting
Metadata from SQL Server, sufficient for it's query-writing needs.  Cognos 7
does not support or certify freeTDS as a source, but the price for the
supported product for our configuration, juxtaposed with our modest needs,
has generated some interest in alternatives.  (Cognos 8 seems to be
supporting JDBC, so this might not be a long term need, either.)

I suspect this is a common hole in the matrix of target databases and client
platforms, when moving database apps from Microsoft to UNIX: the client
support for the Microsoft databases (SQL Server, Access, Excel, Text file)
is missing.  Frankly, I was a bit surprised that a UNIX ODBC was not free
from MS, to increase the use of SQL Server!  I suppose it is cutting your
own throat to support UNIX as either client or server, if you sell parts for
both.  Of course, they are giving away the JDBC, so this is a bit soft.  I
am considering the Easysoft ODBC-JDBC Bridge as well as freeTDS, as it would
support both SQL Server, Interbase 4.0, and most other 'discovered'
connectivity needs.

-----Original Message-----
From: VZverev AT genesis.spb.ru [mailto:VZverev AT genesis.spb.ru]
Sent: Saturday, October 29, 2005 12:42 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC


Hi, Devid
If you mean SquirreL SQL (http://squirrel-sql.sourceforge.net) may I ask you
about a little context explanation? AFAIK in regard of SquirreL it works
splending with Eclipce 2,3 in JFaceDBc plugin (with jTds *JDBC* driver for
example) and as standalone java application (sp_who, proc editor and so on).
For what reason do you want to take ODBC stuff here? 

Sincerely yours. 
-------------------------------------------------------
Vitaly Zverev, OCP DBA 8&8i
Oracle E-Business Suite &
Infiniband Linux Cluster Administrator
Genesis Ltd., St.Petersburg, Russia

 

> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Pickett, David
> Sent: Saturday, October 29, 2005 1:30 AM
> To: 'freetds AT lists.ibiblio.org'
> Subject: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
> 
> Hi,
> 
> I was testing my build of stable freeTDS ODBC, under unixODBC 
> in ODBC-only mode to SQL Server under Windows 2000.  While it 
> seems to work in many respects with isql and SQuirreL 2 so 
> far, I cannot sp_help or sp_tables.
> Under SQuirreL the Objects Tree has only a root element and 
> the catalog
> (schema) name is blank, regardless of how the default 
> database is set in .odbc.ini.  Is there a trick to setting 
> this up for SQuirreL, or is this a freeTDS ODBC driver shortcoming?
> 
> Best regards,
> 
> David
> 
> 1-215-496-5117
>  <<David Pickett (E-mail).vcf>> 
> 
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds