Skip to Content.
Sympa Menu

freetds - [freetds] Quoted Identifiers and TDS 4.2/7.0

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Ben Gribaudo <me AT bengribaudo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Quoted Identifiers and TDS 4.2/7.0
  • Date: Mon, 12 Sep 2005 11:56:20 -0500

Hi,

I am working on setting up a Debian 3.1 box that uses FreeTDS to connect to a Microsoft SQL 7.0 server. http://www.freetds.org/userguide/choosingtdsprotocol.htm recommends using TDS version 7.0. This sounds good except for the fact that, when using TDS 7.0, it appears that quoted identifiers default to on (more details: https://lists.ibiblio.org/sympa/arc/freetds/2003q2/013103.html). We need to have quoted identifiers set to off.

Is there any way to use FreeTDS/TDS 7.0 and set quoted identifiers to off either in freetds.conf or in some kind of start up SQL script run by FreeTDS? If not, we'll need to use TDS 4.2 and keep in mind the limitations it imposes (http://www.freetds.org/userguide/choosingtdsprotocol.htm).

Thank you,
Ben




Archive powered by MHonArc 2.6.24.

Top of Page