freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: troubles using tds

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

troubles using tds, Roman Hlynovski, 04/19/2001
- <Possible follow-up(s)>
- Re: troubles using tds, Allen Grace, 04/19/2001
- Re: troubles using tds, Bob Kline, 04/19/2001
- Re: troubles using tds, Roman Hlynovski, 04/19/2001
- Re: troubles using tds, Bob Kline, 04/19/2001
- Re: troubles using tds, Michael Peppler, 04/19/2001
- Re: troubles using tds, Michael Peppler, 04/19/2001
- Re: troubles using tds, David G . Powers, 04/19/2001
- Re: troubles using tds, James K. Lowden, 04/19/2001
- Re: troubles using tds, James K. Lowden, 04/19/2001
- Re: troubles using tds, Roman Hlynovski, 04/20/2001