Skip to Content.
Sympa Menu

freetds - Re: troubles using tds

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: troubles using tds
  • Date: Thu, 19 Apr 2001 02:39:56 -0400 (EDT)


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" (....)

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page