[freetds] sp_cursoroption and blob fields

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Fri Oct 1 09:35:35 EDT 2004


> 
> Hi Bill,
> Great, I'm going to ask whenever I get deadlocked.
> 
> As for what I'm trying to do, I have a database engine with 
> no network support, and I want to get some exposure for it, 
> to different technologies like odbc, oledb, jdbc and dotnet. 
> Grace to this group's efforts, to jTDS and mono, TDS seems to 
> be the most open protocol to do client/server, although it 
> was not intended to be open.
> I have complaced myself into 4.2 because the MS Network 
> Monitor parser for TDS makes it easy to discover the 
> protocol, but it fails to keep in sync when encountering wide 
> characters, as in 7.0 and 8. However I'm afraid I'll have to 
> switch to wide character, since 4.2 is losing support fast, 
> for example the jdbc driver from Microsoft doesn't talk to 
> TDS 4.2; I'm not sure about Mono.
> Regarding the programming language, I use C++ with gcc and 
> Visual, I am too afraid of memory leaks to use C, and I guess 
> a server can afford to be less portable than a client.
> 

In 2004 I don't think that C++ it's so "less portable"... gcc can
compile for a lot of platforms, even cross compiling !

> How about a higher level question - is it good to stick to a 
> binary protocol for a server, or go to xml rather?
> 

If you want odbc, oledb, etc without writing many code you have to use a
protocol which provide these drivers... Oracle, DB2, MySql, postgres or
whatever. Perhaps you can find a simpler protocol... I don't know... I
think you have to implements many store procedure and emulations to make
more stuff happy... IMO a simpler db should have a simpler protocol.

> Mike
> 

freddy77


More information about the FreeTDS mailing list