RE: (RADIATOR) FreeTDS & DBD-Sybase InstallI found this information on the internet.
There is an open source project - FreeTDS, http://www.freetds.org/ - to create an interface to TDS-compliant database servers such as Sybase and, MS SQL. MS SQL 7.0 speaks TDS version 7.0, but will also speak TDS 4.2. The distinction twixt 4.2 and 7.0 seems to be support for unicode and long varchars. The TDS 7.0 support in FreeTDS is incomplete. By building the OpenTDS code for the 4.2 protocol level, you get libraries that can talk to MS SQL 7.0 - presumably, so long as the databases aren't unicode and don't use long varchars. Does Radiator use Unicode or long varchars when talking to MS-SQL 7.0 using the Rodopi Auth? Tim Jung System Admin Internet Gateway [EMAIL PROTECTED] ----- Original Message ----- From: Matthew Trout To: 'Tim Jung' ; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] > Sent: Wednesday, February 05, 2003 10:31 AM > To: [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
