[prev in list] [next in list] [prev in thread] [next in thread]
List: freetds
Subject: Re: [freetds] Squirrel JDBC-ODBC Bridge and freeTDS ODBC
From: <VZverev () genesis ! spb ! ru>
Date: 2005-11-01 12:31:21
Message-ID: 2F81A0E4C0BAF54892389F3642BA9DDC2CD887 () moon ! gen
[Download RAW message or body]
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@lists.ibiblio.org
> [mailto:freetds-bounces@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@genesis.spb.ru [mailto:VZverev@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@lists.ibiblio.org
> > [mailto:freetds-bounces@lists.ibiblio.org] On Behalf Of
> Pickett, David
> > Sent: Saturday, October 29, 2005 1:30 AM
> > To: 'freetds@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@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> FreeTDS@lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic