FreeTDS Development Group

[Jeff Fisher <JFisher AT Emery-Waterhouse.com>]

Thanks, I'll give that a try.

-----Original Message-----
From: ZIGLIO, Frediano, VF-IT [mailto:Frediano.Ziglio AT vodafone.com]
Sent: Friday, April 09, 2004 3:12 AM
To: FreeTDS Development Group
Subject: RE: [freetds] General Error in nvITrans_BeginT - rc = -1 Follow
up


> 
> > From: Jeff Fisher [mailto:JFisher AT Emery-Waterhouse.com]
> > Sent: April 8, 2004 8:40 AM
> > 
> > [Generic Connectivity Using ODBC]Record SKU_MASTER has no 
> > fields. Loading failed.
> > 
> > We've looked at the log output, but haven't seen anything 
> > obvious.  What should we be looking for in the logs?  
> 
> Good question.  Several things could be wrong, and the 
> message isn't especially helpful.  
> 
> HSODBC might be trying to assess the table through methods we 
> don't implement.  I would look for complaints that 
> such-and-such an option is not supported.  In general, 
> FreeTDS will log such a message, but not always.  
> 
> Look for error messages arriving from the server.  Under 
> certain conditions, they're not propogated back to the application.  
> 
> I suppose SKU_MASTER is a table?  There are two ways to 
> determine the columns of a table:
> 
> 1.  Get the metadata by selecting from the table ("where 0=1" 
> or somesuch).  You should see the select statement and a 
> pretty verbose description of the returned columns.  
> 
> 2.  Select the metadata (as data) from either the system 
> tables or the information schema views.  
> 
> I don't know which of these things our ODBC driver does, or 
> if HSODBC is doing the work itself.  I do know the 
> information has to come from the server in one of those two forms.  
> 
> You are in new territory, in case you don't know that 
> already.  FreeTDS is normally used in bespoke programs, where 
> the programmer can adjust to its capabilities.  HSODBC, OTOH, 
> no doubt expects to use a fully compliant driver.  I don't 
> know that FreeTDS meets that standard sufficiently well 
> enough for that purpose.  AFAIK, the only experience anyone's 
> had with plugging FreeTDS ODBC into a pre-existing system is 
> with oo.org, and that experience hasn't been positive.  
> Regardless, we're happy to help you try.  
> 

Time ago I had an off-ML chat with Andrea (in Italian). We get HSODBC
working. All test he did passed. You have to use CVS version (0.63) with
--enable-developing switch. To read columns metadata HSODBC use
SQLPrepare followed by SQLColAttribute (or similar); this mode is not so
efficient however we cannot change HSODBC so I change FreeTDS :)

freddy77
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds