troubles using tds

Roman Hlynovski dr at citynet.kz
Thu Apr 19 00:59:36 EDT 2001


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.

the sample is:
  $query = 'create table 192.168.0.1 (BYTES_IN_CACHE datetime)';
  $sth = $dbh->prepare($query);
  $sth->execute;

i've tried many combinations of  ''' and '"' around the 192.168.0.1 value
but couldn't get proper result

ps: i'm using freetds-0.51 if it's important

... WBR, Roman Hlynovski (dr at citynet.kz)




More information about the FreeTDS mailing list