Skip to Content.
Sympa Menu

freetds - Re: [freetds] ODBC Driver

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Evan Wagner <webmast84 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] ODBC Driver
  • Date: Tue, 5 Oct 2010 19:05:01 -0400

Most certainly ^_^


On Tue, Oct 5, 2010 at 4:47 PM, Peter Deacon <peterd AT iea-software.com>wrote:

> On Tue, 5 Oct 2010, Frediano Ziglio wrote:
>
> Ehmmm... I don't know why but this was in my outgoing folder since 2003...
>> and yesterday my e-mail client decided to send it!
>>
>
> I think this is an omen to get me to finish my transport patches. :)
>
> regards,
> Peter
>
>
> 2010/10/4 Frediano Ziglio <freddy77 AT gmail.com>
>>
>> Il sab, 2003-03-22 alle 02:41, Peter Deacon ha scritto:
>>>
>>>> Hi there.
>>>>
>>>
>>> Hi Peter.
>>>
>>> Grabed the latest freetds snapshot yesterday. In a few hours I managed
>>>>
>>> to
>>>
>>>> get ODBC driver working darn near perfect... Thought for sure it would
>>>> take weeks of hacking before I'd even be able to login let alone do
>>>> anything useful.
>>>>
>>>> We've played with several third party ODBC drivers for MSSQL
>>>> and Sybase over the years and I've gotta say from what I've seen so far
>>>> FreeTDS is second only to Merant/Data direct/ whatever their called
>>>>
>>> today.
>>>
>>> Thanks
>>>
>>> Best of all, there was already a visual studio project in the tarball..
>>>> all I had to do was compile.. Nothing like being able to step from
>>>> your application right into the driver (Edit and continue anyone?:)
>>>>
>>>> Heres what I've found so far..
>>>>
>>>> When we call stored procedures have a habbit of using caps to spell out
>>>> CALL. The prepare routine would fail if not all lowercase 'call'.
>>>>
>>>
>>> Fixed in CVS
>>>
>>> For SQLGetDiagField
>>>> Implemented:
>>>> SQL_DIAG_ROW_COUNT
>>>> SQL_DIAG_CLASS_ORIGIN
>>>> SQL_DIAG_SS_MSGSTATE (The SS functions I set win32 only)
>>>> SQL_DIAG_SS_LINE
>>>> SQL_DIAG_NATIVE
>>>> SQL_DIAG_SQLSTATE
>>>>
>>>
>>> Good!
>>>
>>> numRecord should be decremented after NO_DATA_FOUND check.
>>>>
>>>
>>> Fixed in CVS (with another problem...).
>>>
>>> Misc:
>>>> Return 'Microsoft SQL Server' if using MSSQL from SQLGetInfo
>>>>
>>>
>>> Fixed in CVS.
>>>
>>> With text datatypes there was an off by one.. It would move the value
>>>> pointer back one making the first letter garbage and exclude the
>>>> last.
>>>>
>>>
>>> I didn't understand...
>>>
>>> I've always wondered about where SQLStates come from. Sybase stores a
>>>>
>>> few
>>>
>>>> in their sysmessages table however as far as I can tell they don't exist
>>>> in the MS sysmessages table. Cought the bits in freetds where it can
>>>> fetch sqlstates from the wire..but it never appears to get called. If
>>>> sqlstate is not otherwise set added lookup tables for MSSQL and Sybase
>>>> which map about 150 native errors to SQL States.. Hope this sounds
>>>> reasonable?
>>>>
>>>
>>> No, simply sql server return sql state itself. Perhaps libtds discard
>>> this information... Another problem is translation from odbc2 codes to
>>> odbc3 codes...
>>>
>>> Anyway have a few weird bits left to check into before posting my diff.
>>>>
>>>
>>> Well, post your diff.
>>>
>>> You have no idea how cool this is :)
>>>>
>>>> Thanks everyone
>>>> -Peter
>>>>
>>>
>>> Frediano Ziglio
>>>
>>>
>>>
>>> _______________________________________________
>> 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
>




Archive powered by MHonArc 2.6.24.

Top of Page