FreeTDS Development Group

[Зверев Виталий Борисович <VZverev AT genesis.spb.ru>]

Hi David,
Your explanations look like a standard ODBC puzzle.

> I am running SQuirreL SQL as a standalone JAVA app on Solaris 
> 2.8 to test freeTDS, which I build from stable source using 

I have the same SPARC Solaris 8 configuration as you described but sp_help, 
sp_tables work properly in isql.
Before doing something weird with SQuirrelL via Jdbc-Odbc bridge you should 
try:
1) tsql (native freetds tool)
bash-2.03# tsql -C
locale is 
"/ru_RU.ISO8859-5/ru_RU.ISO8859-5/ru_RU.ISO8859-5/ru_RU.ISO8859-5/ru_RU.ISO8859-5/C"
locale charset is "ISO8859-5"
Compile-time settings (established with the "configure" script):
                           Version: freetds v0.63.dev.20040213
    MS db-lib source compatibility: no
       Sybase binary compatibility: unknown
                     Thread safety: no
                     iconv library: yes
                       TDS version: 8.0
                             iODBC: no
                          unixodbc: yes
2) isql
isql --version
unixODBC 2.2.7

After all, SQuirrelL has a nice JDBC debug options (file->global 
preferences->sql page).
Hope this help to figure out problem's cornerstone.

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: Monday, October 31, 2005 5:22 PM
> To: 'FreeTDS Development Group'
> Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
> 
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>