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 07:09:03 -0400 (EDT)


On Thu, 19 Apr 2001, Roman Hlynovski wrote:

> >
> > 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 ;-)

No? What's this then?

$ tfreetds.pl
SQL> CREATE TABLE "192.168.0.1" (id INTEGER, name VARCHAR(32))
SQL> INSERT INTO "192.168.0.1" VALUES(42, 'Jane Austin')
SQL> INSERT INTO "192.168.0.1" VALUES(43, 'Mary Shelley')
SQL> SELECT * FROM "192.168.0.1"
id: 42
name: Jane Austin

id: 43
name: Mary Shelley

The above was run on linux 2.2.5-15, with perl 5.005_03, and freetds
0.51 built from sources November 19 of last year, against SQL Server
7.0 running on Windows NT 4.0 SP5.

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





Archive powered by MHonArc 2.6.24.

Top of Page