Skip to Content.
Sympa Menu

freetds - What SQL syntax can I use with FreeTDS?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Peppi Vecchio" <PVecchio AT orangelake.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: What SQL syntax can I use with FreeTDS?
  • Date: Mon, 22 Jul 2002 13:00:36 -0400


I'm running Apache/Linux and Perl with DBD::Sybase and FreeTDS on our
server. I'm talking to a W2K box with SQL Server 7.0 on it. FreeTDS
connected easily and works great. My only problem is I'm having difficulty
querying the box. I'm used to using DBI and MySQL but the syntax in
DBD::Sybase/SQL Server is different. Am I to use Sybase syntax or SQL
Server 7.0 syntax? Specifically I have difficulty passing a string into
my SELECT query. Looks like this:<br><br>
<code>
$ENV{'SYBASE'} = '/usr/local/freetds' unless $ENV{'SYBASE'};

my $dbh =
DBI->connect('dbi:Sybase:server=myserver.com;database=this_db','usr','pass');

my $a1 = "This";
my $a2 = $dbh->quote( "SELECT COUNT(*) FROM this_table WHERE
this_column >= $a1" );
my $sth = $dbh->prepare( $a2 );
$sth->execute() or die $sth->errstr;
</code><br><br>
Any help would be appreciated. Supa Thanx
PeppiV




Archive powered by MHonArc 2.6.24.

Top of Page