(RADIATOR) FreeTDS & DBD-Sybase Install

[Tim Jung]

I found this out from the author of the DBD::Sybase module. He posted this
to the FreeTDS mailing list back in October 2002. He is specifically
talking about the errors that are generated when you run the 'make test'
option on the DBD::Sybase module using FreeTDS.

> No. I haven't followed things here closely, but unless FreeTDS now
> supports "dynamic sql" for the MS-SQL version of TDS (i.e. ct_dynamic()
> and friends) then you will get these errors.
>
> DBD::Sybase also uses the ct_command(CS_RPC_CMD) and ct_param() calls,
> and I don't know if these are properly supported yet.
>
> And thirdly DBD::Sybase gives access to the ct_get/send_data() primitives
> (to read/write BLOB data in chunks). Again I don't know if these are
> supported by FreeTDS.
>
> All of these are tested (to some extent) during "make test", and will
> cause errors if they are not implemented.

So it would look like that until more work is done on FreeTDS that it
doesn't support 100% of everything that MS-SQL is capable of doing. Thus
the DBD::Sybase won't pass all the 'make test' tests using FreeTDS v0.60 or
the CVS version v0.61 as of today. I guess it is possible that the release
version of v0.61 might up the level of support though. Although it would
seem than 85%-86% support isn't too bad for an Open Source package talking
to a commercial closed source database. :)

So the question that remains is which version of the TDS protocol is needed
to talk with MS-SQL 7.0 SP3 so Radiator can talk to the Rodopi databases?
Should I use the 4.2 protocol or the 7.0 protocol? Specifically I am
interested in using the "Auth Rodopi" stuff in Radiator. Anyone here know
for sure?

Tim Jung
System Admin
Internet Gateway
tjung at igateway.net


----- Original Message -----
From: Matthew Trout
To: 'Tim Jung' ; radiator at open.com.au
Sent: Wednesday, February 05, 2003 6:53 AM
Subject: RE: (RADIATOR) FreeTDS & DBD-Sybase Install


I've never managed to get DBD::Sybase to pass all of its tests, but the
install has then worked fine.
Instead of using the standard tests, might I suggest you roll your own - a
swift perl script that tests a representative sample of the sort of queries

you're going to be throwing at it live. I did this, got a build that worked
correctly for the script, and have been running the build in production for
over a year without problems. Then again, that was with freetds-0.53rc2 and
DBD::Sybase 0.93 on Mandrake and BSD/OS, so YMMV.
> -----Original Message-----
> From: Tim Jung [mailto:tjung at igateway.net]
> Sent: Wednesday, February 05, 2003 10:31 AM
> To: radiator at open.com.au
> Subject: (RADIATOR) FreeTDS & DBD-Sybase Install
>
>
> I am having a problem getting all the perl modules and database stuff
> installed correctly on my Red Hat 8.0 server. I was wondering
> if anyone
> might be able to help.
>
> I have installed all the MD4, MD5, LDAP, DBI modules without
> any problems.
> I am now working on getting the FreeTDS and DBD-Sybase stuff
> installed. I
> am trying to connect to a Windows 2000 SP3 server running
> MSSQL 7.0 SP3.
>
> I have downloaded both the FreeTDS v0.60 and today's CVS
> snapshot of v0.61
> and I have tried telling it to do any one of the following:
> ./configure --with-tdsver=4.2
> ./configure --with-tdsver=7.0
> ./configure --with-tdsver=8.0
> It compiles both v0.60 & v0.61 versions with no errors and
> whatever version
> of the TDS protocol that I tell it.
>
> I then try and install the DBD-Sybase v0.95 module without
> much luck. If I
> use the FreeTDS v0.60 I then have to edit the DBD-Sybase file
> dbdimp.c and
> change all cs_ctx_global(....) to cs_ctx_alloc(....) to get
> it to compile
> at all. If I use the current snapshot of FreeTDS I don't have
> to do this.
>
> Regardless no matter which way I do it I can't seem to get
> the DBD-Sybase
> v0.95 to pass all the "make test" tests with 100%. I get from
> 84% to 86% of
> the tests passed.
>
> Now my question is which version of the TDS protocol should I
> be using for
> MSSQL 7.0 SP3? The other question is, am I getting these
> errors because I
> somehow screwed up my "tempdb" database trying all these
> different versions
> of the software or should I just ignore the errors since it
> won't pass all
> the tests but it will work well enough for Radiator?
>
> In case it matters I am using Radiator-Demo 3.5, and I
> eventually want to
> connect it to Rodopi v5.2 SP3.
>
> Any help that anyone can give me would be appreciated.
>
> Tim Jung
> System Admin
> Internet Gateway
> tjung at igateway.net

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.