FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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