FreeTDS Development Group

["Patrick Poncet" <patrickp AT pintys.com>]

Thank you!  It works!!!!!!!


That's fantastic.  You must realize that at this point (unless we hit a
wall) we have managed to connect an IBM Domino server running on Linux
to an MS SQL server.  Thanks to you guys.... Thank you!!!

Until recent nightly builds (including improved ODBC compliance!?!)
there was no opensource solution out there to do that... Th only option
IBM could give was to use the easysoft ODBC-ODBC bridge.  

You guys have broken this barrier.

We are in the process of performing more tests and running more complex
SQL qyeries, calling stored procedures etc....

Once we have conclusive results, we will let you guys know.  At which
point, we want to contribute to your project as you have allowed us a
great deal of functionality with our Lotus Domino project.


Please let me know what we can do to contribute (i.e.: Make you known by
IBM as an alternative to easysoft solution, translate documentation -
french!?!, give you $$$, send you our story & detailed config steps
etc...) - just let us know!  I have no approval from anyone on this but
I want to suggest some way of thanking you to upper management here.

Regards,

Patrick



> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org 
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of 
> ZIGLIO Frediano
> Sent: November 6, 2003 5:31 AM
> To: FreeTDS Development Group
> Subject: RE: [freetds] sp_tables (ODBC)
> 
> 
> > 
> > Hello all,
> > 
> > 
> > Far from being expert in ODBC, I managed to use unixODBC in
> > conjunction with FreeTDS on RedHat 7.3.  tsql works great, 
> > isql works great and I can tap into my data sources.
> > 
> > 
> > Now the purpose of all this is to get Lotus Domino running on
> > that box to tap into MS SQL server data sources.  
> > 
> > Up to freetds-0.61, Domino was crashing when trying to access
> > the datasource for some reason. In 0.61 the Domino ODBC test 
> > could not report on freetds-odbc drivers details (returning 
> > "Operation not supported"), now the latest nightly build does 
> > work and reports all required Domino driver details.  Now 
> > Domino does not crash anymore!!! Thanks for making that work! 
> >  Am I right to say that freetds-unixodbc wasn;t completely 
> > unixODBC compliant???
> > 
> > 
> > In Lotus Notes Designer, you can set up ODBC data sources and
> > get it to point to a unixODBC datasource on the system the 
> > Domino Server runs on. Once you have done that you can click 
> > on a button to browser metatadata (Tables of a database)  It 
> > works great with unixODBC / MyODBC (MySQL ODBC driver) - I 
> > can see and pick tables from a database.  But when I use a 
> > FreeTDS unixODBC datasource it does not work (Domino says 
> > can't find any Metadata)
> > 
> > After a bit of investigation and analysing the loigs I
> > notices that the following strored procedure was called by my 
> > "Browse Metedata" button
> > click:
> > 
> > sp_tables @table_type='TABLE'
> > 
> > Ran this from isql and no row came back
> > 
> > I went in the SQL query analyser on the MS SQL server I'm
> > trying to reach throuch unixODBX and ran it: no row came back.
> > 
> > Looked at the MS Sql books online to fine out that the
> > correct syntax shoould be:
> > 
> > sp_tables @table_type="'TABLE'"
> > 
> > Rand that from isql and all tables come back.
> > 
> > 
> > So my question is:
> > 
> > 
> > Is there a way to make freetds-unixodbc run that sp_table
> > query by enclosing the @table_type value in double quotes. Or 
> > is it domino that should know it talks to a MSSQL server and 
> > should add these double-quotes before calling unixODBC API?  
> > Or is it unixODBC API which should add those double quotes???
> > 
> > 
> > Any thoughts anyone?
> > 
> > Thanks for your help!
> > 
> > Patrick
> > 
> 
> This patch should solve your problem. ODBC support 
> quoted/unquoted types while sp_tables support only quoted one...
> 
> freddy77
>