troubles using tds

Michael Peppler mpeppler at peppler.org
Thu Apr 19 10:29:35 EDT 2001


Bob Kline 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.

As long as you set "quoted_identifier on" for the connection, that is.

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



More information about the FreeTDS mailing list