Skip to Content.
Sympa Menu

freetds - Re: troubles using tds

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT speakeasy.org>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: troubles using tds
  • Date: Thu, 19 Apr 2001 23:11:48 +0000


Roman Hlynovski wrote:

> 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.
>
> the sample is:
> $query = 'create table 192.168.0.1 (BYTES_IN_CACHE datetime)';

No can do, Roman :( At least perl is telling you the truth, though.

Sybase objects have the form Server.Database.Owner.Name. I think you want to
do
something more along the lines of

$query = 'create table Machines (Address char(16), BYTES_IN_CACHE datetime)';

That will make a table called Machines in the current database owned by the
user
who's logged in.

You might want to take a look at the Sybase Create Table documentation, too.

HTH,

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page