Skip to Content.
Sympa Menu

freetds - Re: troubles using tds

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: troubles using tds
  • Date: Thu, 19 Apr 2001 07:35:10 -0700 (PDT)


Roman Hlynovski writes:
> > On Thu, 19 Apr 2001, Roman Hlynovski wrote:
> >
> > > Hello, i'm trying to make conversation between my linux box to ms sql
> server
> > > on win nt and have a little problem. i'm
> > > using DBD:Sybase for connection and then i'm trying to create a table
> like
> > > 192.168.0.1 it returns error response:
> > >
> > > DBD::Sybase::st execute failed: Server message number=170 severity=15
> > > state=1 line=1 server=DIAL text=Line 1: Incorrect syntax near '192'. at
> > > ./log_manager line 56.
> >
> > You're asking for trouble, but if you put double quotes around the
> > identifier, you can treat it as a delimited identifier instead of a
> > regular identifier.
> >
> > CREATE TABLE "192.168.0.1" (....)
> yep, this works from enterprise manager but not from perl ;-)
>

Add

$dbh->do("set quoted_identifier on");

(and it has nothing to do with perl - it's a protocol/syntax issue)

Michael
--
Michael Peppler - Data Migrations Inc. - mpeppler AT peppler.org
http://www.mbay.net/~mpeppler - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list AT isug.com




Archive powered by MHonArc 2.6.24.

Top of Page