List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:August 15 1999 8:51pm
Subject:Re: Fw: mSQL - Perl Problems
View as plain text  
Shane Richard wrote:
> 
> ----- Original Message -----
> From: Shane Richard
> To: msql-mysql-modules@stripped
> Sent: Sunday, August 15, 1999 1:15 PM
> Subject: mSQL - Perl Problems
> 
> I am trying to use a Perl script to connect to a mSQL database.  I have created a
> single table in the database (called Restaurants), and have created a sequence on that
> table.  I have verified the existence of the table and sequence using the Control Panel
> provided by my website host (Hiway).  To my knowledge, mSQL 2.? and Perl 5.0.? is being
> used.
> 
> When I try to run the following script:
> 
> print "Content-type: text/html\n\n";
> 
> use Msql;
> 
> $db1 = Msql->Connect("", "{database name}") or die;
> 
> $sth = $db1->Query("select City from Restaurants");
> 
> print $Msql::db_errstr, "\n";
> 
> 
> 
> I get the following error:
> 
> Error reading table "Restaurants" definition
> 
> When I try to run the following script:
> 
> print "Content-type: text/html\n\n";
> 
> use Msql;
> 
> $db1 = Msql->Connect("", "{database name}") or die;
> 
> $sth = $db1->Query("SELECT _seq FROM Restaurants");
> 
> print $Msql::db_errstr, "\n";
> 
> I get the following error:
> 
> Syntax error near "_"
> 
> I would appreciate any help that you can provide me in finding the cause and fixing
> these 2 errors.
> 
> Thanks,
> 
> shane@stripped

mSQL and MySQL are two very different things. This list is for MySQL
issues. There are two things you can do:

 - find an mSQL list ( not recommended)
 - upgrade to MySQL ( recommended)


-- 
Sasha Pachev
http://www.sashanet.com
Thread
Fw: mSQL - Perl ProblemsShane Richard15 Aug
  • Re: Fw: mSQL - Perl ProblemsSasha Pachev15 Aug
Re: Fw: mSQL - Perl ProblemsDerick H Siddoway16 Aug